{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["服务平台可视化","数据服务订阅向导","专题和基础数据"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"服务平台可视化","index":0,"n_rows":390,"n_cols":7,"rows_kept":390,"cut":false,"hidden":false,"merged":[[1,0,1,6],[78,0,78,6],[92,0,92,6],[101,0,101,6],[124,0,124,6],[145,0,145,6],[155,0,155,6],[169,0,169,6],[188,0,188,6],[204,0,204,6],[218,0,218,6],[232,0,232,6],[243,0,243,6],[258,0,258,6],[285,0,285,6],[300,0,300,6],[310,0,310,6],[319,0,319,6],[332,0,332,6],[364,0,364,6]]}
[]
["mnp_company"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键ID"]
["enterprise_type","varchar(20)","是","否","否","","企业类型"]
["is_head","varchar(2)","是","否","否","","是否总部"]
["is_imout","varchar(2)","是","否","否","","是否进出口"]
["is_foreign","varchar(2)","是","否","否","","是否外资"]
["registration_code","varchar(20)","是","否","否","","注册标识"]
["industry","varchar(255)","是","否","否","","所属行业/行业分类"]
["ssbk","varchar(50)","是","否","否","","所属板块"]
["qymc","varchar(100)","是","否","否","","企业名称"]
["shxydm","varchar(50)","是","否","否","","统一社会信用代码"]
["zczj","double(50,2)","是","否","否","","注册资金（万元）"]
["zcsj","date","是","否","否","","注册时间"]
["fddbr","varchar(50)","是","否","否","","法定代表人"]
["jyfw","varchar(2000)","是","否","否","","经营范围"]
["manage_area","varchar(255)","是","否","否","","经营面积(平方米)"]
["zcdz","varchar(500)","是","否","否","","注册地址"]
["jydz","varchar(255)","是","否","否","","经营地址"]
["zt","varchar(50)","是","否","否","","状态"]
["rzsj","date","是","否","否","","入住时间"]
["qylxr","varchar(50)","是","否","否","","企业联系人"]
["lxdh","varchar(50)","是","否","否","","联系电话"]
["email","varchar(50)","是","否","否","","email"]
["remark","varchar(500)","是","否","否","","备注"]
["qylbbq","varchar(50)","是","否","否","","企业类别标签(单选),高企、雏鹰等"]
["glygs","int(11)","是","否","否","","关联员工数"]
["sszt","varchar(1000)","是","否","否","","所属载体ID，多个载体使用、分隔"]
["ssztmc","varchar(1000)","是","否","否","","所属载体名称，多个载体使用、分隔"]
["ldmc","varchar(50)","是","否","否","","楼栋名称"]
["lcqymc","varchar(100)","是","否","否","",""]
["czrid","varchar(50)","是","否","否","","操作人ID/改成企业申请人id"]
["czr","varchar(50)","是","否","否","","操作人"]
["czsj","datetime","是","否","否","","操作时间/改成企业申请时间"]
["gxrid","varchar(50)","是","否","否","","更新人ID/改成审核人id"]
["gxr","varchar(50)","是","否","否","","更新人"]
["gxsj","datetime","是","否","否","","更新时间/改成审核时间"]
["wxmm","varchar(50)","是","否","否","","小程序登录密码"]
["wxzt","varchar(50)","是","否","否","","启用/禁用状态，控制是否登录小程序"]
["yyzzfbzp","varchar(1000)","是","否","否","","营业执照副本，存储frame_data的id使用#分隔"]
["yyzz","text","是","否","否","","营业执照"]
["cwfzr","varchar(50)","是","否","否","","财务负责人**********"]
["cwfzrdh","varchar(50)","是","否","否","","财务负责人电话*********"]
["ryxxzp","varchar(1000)","是","否","否","","荣誉信息，存储frame_data的id使用#分隔"]
["blrq","date","是","否","否","","搬离日期"]
["fksfsh","varchar(10)","是","否","否","","访客是否审核"]
["settle_in_type","varchar(255)","是","否","否","","入驻类型"]
["scale","varchar(255)","是","否","否","","规模属性"]
["floor_disc_id","varchar(255)","是","否","否","","所属区域（所属楼盘id）"]
["room_id","varchar(255)","是","否","否","","房间id"]
["is_business_account","int(1)","是","否","否","0","是否拥有企业账户"]
["currency","int(1)","是","否","否","","币种"]
["legal_person_phone","varchar(255)","是","否","否","","法人电话*****************"]
["honor_information","varchar(2000)","是","否","否","","荣誉信息**********"]
["honor_file","text","是","否","否","","荣誉信息文件*******"]
["frsfzh","text","是","否","否","","法人身份证************"]
["rd_investment","double(11,2)","是","否","否","","全年研发投入************"]
["jg_investment","double(11,2)","是","否","否","","全年技改投入***********"]
["four_openness_amount","double(11,2)","是","否","否","","四技合同金额（技术开发）******"]
["four_transference_amount","double(11,2)","是","否","否","","四技合同金额（转让）*********"]
["four_service_amount","double(11,2)","是","否","否","","四技合同金额（服务）**********"]
["four_consult_amount","double(11,2)","是","否","否","","四技合同金额（咨询）*******"]
["investment_manager","varchar(1000)","是","否","否","","招商经理*************"]
["association_company","varchar(1000)","是","否","否","","关联企业************"]
["group_id","varchar(20)","是","否","否","","组"]
["area","varchar(255)","是","否","否","","所属区域"]
["practice_number","int(11)","是","否","否","","从业人数"]
["zscqgs","int(11)","是","否","否","","拥有知识产权个数************"]
["rzjd","varchar(50)","是","否","否","","融资进度"]
["gmsx","varchar(50)","是","否","否","","规模属性"]
["qybq","varchar(1000)","是","否","否","","企业标签"]
["entry_status","varchar(255)","是","否","否","","入驻状态"]
["fr_email","varchar(255)","是","否","否","","法人邮箱**************"]
["open_id","varchar(255)","是","否","否","",""]
["service_commissioner","varchar(255)","是","否","否","","企服专员"]
["create_time","datetime","是","否","否","","创建时间"]
[]
["statistics_import_revenue(经发数据导入表(统计导入营收))"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["company_id","varchar(64)","否","否","否","","公司id"]
["yearmonth","varchar(12)","否","否","否","","任务年月份(例如:202301)"]
["taxation","decimal(12,6)","是","否","否","","税收（万元)"]
["revenue","decimal(12,6)","是","否","否","","营收（万元）"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间(导入时间)"]
["updated_by","varchar(64)","是","否","否","","修改人(操作人)id"]
["updated_at","datetime","是","否","否","","修改(更新)时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_company_yuanqu(园区和公司关系表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["company_id","varchar(64)","是","否","否","","公司id"]
["yuanqu_id","varchar(64)","是","否","否","","园区id"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["sunan_freight_entry(货运入园管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["qr_code","varchar(64)","是","否","否","","通行码为二维码，生成规则：TX年月日流水号\r\n\r\n如：TX202302020001"]
["to_companies_name","varchar(5000)","是","否","否","","收货企业名称s"]
["to_companies_is","varchar(5000)","是","否","否","","收货企业ids"]
["from_company_name","varchar(255)","是","否","否","","发货企业名称"]
["appointment_in_park_time","timestamp","是","否","否","","预约入园时间"]
["yuanqu_id","varchar(64)","是","否","否","","园区id"]
["cargo_weight","decimal(10,3)","是","否","否","","货物重量（吨）"]
["cargo_info","varchar(5000)","是","否","否","","货物信息"]
["driver_name","varchar(255)","是","否","否","","司机姓名"]
["driver_phone","varchar(64)","是","否","否","","司机电话号码"]
["car_number","varchar(32)","是","否","否","","车牌号"]
["push_type","int(4)","是","否","否","","1提交(不需要用了)"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id/预约人id"]
["created_by_company","varchar(64)","是","否","否","","预约人所属企业id"]
["created_at","datetime","是","否","否","","创建时间/提交时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_idle_resource(闲置资源管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["name","varchar(512)","是","否","否","","资源名称"]
["types","varchar(1024)","是","否","否","","资源类别(字典sunan_renting_type)数组左右用逗号隔开例如,1,2,"]
["use_type","int(3)","是","否","否","","使用方式1.租聘,2购买"]
["init_use_money","decimal(10,2)","是","否","否","","参考金额元"]
["connect_name","varchar(255)","是","否","否","","联系人名称"]
["connect_phone","varchar(255)","是","否","否","","联系电话"]
["picture_url","varchar(1024)","是","否","否","","资源图片"]
["info","varchar(5000)","是","否","否","","资源描述"]
["push_type","int(4)","是","否","否","","1上架,2下架"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
["update_by_frame_user","varchar(64)","是","否","否","","平台操作人id"]
["update_at_frame_user","datetime","是","否","否","","平台操作时的时间"]
[]
["sunan_idle_resource_type(闲置资源表的资源类别(暂时不用))"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_portal_management(门户信息管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["type","int(4)","是","否","否","","园区类型(字典[portal_type]:1,园区简介,2服务定位,3产业集群)"]
["info","text","是","否","否","","描述"]
["picture_info","varchar(2000)","是","否","否","","图片信息"]
["push_type","int(4)","是","否","否","","发布状态1已发布,2待发布"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_renting(招租管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["yuanqu_id","varchar(64)","是","否","否","","关联园区"]
["types","varchar(1024)","是","否","否","","招租类别(字典sunan_renting_type)数组左右用逗号隔开例如,1,2,"]
["info","varchar(5000)","是","否","否","","招租描述"]
["picture_url","varchar(1024)","是","否","否","","招租图片"]
["connect_name","varchar(255)","是","否","否","","联系人"]
["connect_phone","varchar(255)","是","否","否","","联系电话"]
["push_type","int(4)","是","否","否","","1上架,2下架"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
["update_by_frame_user","varchar(64)","是","否","否","","平台操作人id"]
["update_at_frame_user","datetime","是","否","否","","平台操作时的时间"]
[]
["sunan_seeking_rent(求租管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["info","varchar(5000)","是","否","否","","求租描述"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["connect_name","varchar(255)","是","否","否","","联系人"]
["connect_phone","varchar(255)","是","否","否","","联系电话"]
["push_type","int(4)","是","否","否","","1上架,2下架"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
["update_by_frame_user","varchar(64)","是","否","否","","平台操作人id"]
["update_at_frame_user","datetime","是","否","否","","平台操作时的时间"]
[]
["sunan_video(视频管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["yuanqu_id","varchar(64)","是","否","否","","关联园区"]
["give_person","varchar(255)","是","否","否","","视频提供方"]
["address","varchar(512)","是","否","否","","详细地址"]
["video_url","varchar(255)","是","否","否","","视频码流"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_yuanqu_info_management(园区信息管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["yuanqu_id","varchar(64)","是","否","否","","园区id"]
["info","varchar(5000)","是","否","否","","信息描述"]
["yuanqu_info_type_id","varchar(64)","是","否","否","","信息类型表的id"]
["push_type","int(4)","是","否","否","","1已发布,2待发布"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_yuanqu_info_type(园区信息类型)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["type_info","varchar(512)","是","否","否","","类型名称"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注(作为排序使用)"]
[]
["park_fill_import_task(填报导入任务)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["belong_date","varchar(100)","是","否","否","","任务月份"]
["task_id","varchar(100)","是","否","否","","任务id"]
["tem_id","varchar(100)","是","否","否","","模板id"]
["operate_id","varchar(100)","是","否","否","","操作人"]
["operate_name","varchar(255)","是","否","否","","操作人名称"]
["operate_time","datetime","是","否","否","","操作时间"]
["operate_num","int(11)","是","否","否","","数据量"]
["states","varchar(10)","是","否","否","","状态(0=未导,1=已导)"]
["files","varchar(255)","是","否","否","","导入文件ids"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_fill_info(填报信息)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["group_id","varchar(100)","是","否","否","","园区id"]
["tem_id","varchar(100)","是","否","否","","模板id"]
["task_id","varchar(100)","是","否","否","","任务id"]
["enter_id","varchar(100)","是","否","否","","企业id"]
["fill_type","varchar(10)","是","否","否","","填报类型(0=企,1=管,2=导)"]
["belong_date","varchar(100)","是","否","否","","归属月份"]
["options","varchar(255)","是","否","否","","填报项目"]
["content","varchar(255)","是","否","否","","填报内容"]
["fill_user_id","varchar(100)","是","否","否","","填报人id"]
["fill_user_type","varchar(255)","是","否","否","","填报人类型(0=企,1=管)"]
["fill_user_name","varchar(255)","是","否","否","","填报人名称"]
["fill_time","datetime","是","否","否","","填报时间"]
["require_finish_time","datetime","是","否","否","","要求完成时间"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
["revenue","double(11,2)","是","否","否","","营业收入"]
["taxation","double(11,2)","是","否","否","","税收收入"]
["property","double(11,2)","是","否","否","","拥有知识产权"]
["practice","double(11,2)","是","否","否","","从业人数"]
["output","double(11,2)","是","否","否","","产值"]
["profit","double(11,2)","是","否","否","","利润"]
["electricity","double(11,2)","是","否","否","","用电量(改成吞吐量(吨))"]
["save_type","varchar(10)","是","否","否","","保存类型(0=已填，1=未填)"]
[]
["park_fill_task(预填报任务)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["task_no","varchar(100)","是","否","否","","任务编号"]
["tem_id","varchar(255)","是","否","否","","填报模板id"]
["refer","varchar(255)","是","否","否","","推送对象描述"]
["receive_ids","varchar(500)","是","否","否","","推送企业ids"]
["belong_date","varchar(100)","是","否","否","","归属年月份"]
["require_finish_time","datetime","是","否","否","","要求完成时间"]
["push_num","int(11)","是","否","否","","推送企业数"]
["finish_num","int(11)","是","否","否","","填报企业数"]
["unfinish_num","int(11)","是","否","否","","未填报企业数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(100)","是","否","否","","创建人"]
[]
["park_fill_template(预填报模板)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["tem_name","varchar(255)","是","否","否","","模板名称"]
["tem_reserve","varchar(255)","是","否","否","","模板预留字段"]
["options","varchar(255)","是","否","否","","填报选项"]
["play_num","int(11)","是","否","否","","引用次数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_floor_disc(楼盘)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["name","varchar(255)","是","否","否","",""]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["group_id","varchar(255)","是","否","否","",""]
[]
["park_info(园区信息)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["group_id","varchar(255)","是","否","否","",""]
["park_type","varchar(255)","是","否","否","",""]
["size","varchar(255)","是","否","否","",""]
["address","varchar(255)","是","否","否","",""]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["group_name","varchar(255)","是","否","否","",""]
["introduction","text","是","否","否","",""]
[]
["park_room(园区房间)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["build_id","varchar(20)","是","否","否","",""]
["room_no","varchar(255)","是","否","否","","房号"]
["img_no","varchar(255)","是","否","否","","平面图房号"]
["size","varchar(255)","是","否","否","","面积"]
["direction","varchar(255)","是","否","否","","朝向"]
["state","varchar(255)","是","否","否","","租赁状态"]
["current_state","varchar(255)","是","否","否","","当前状态（招商状态）"]
["group_id","varchar(255)","是","否","否","",""]
["disc_id","varchar(255)","是","否","否","","楼盘id"]
["room_use","char(1)","是","否","否","","用途"]
["guide_price","double(10,2)","是","否","否","","租赁指导价"]
["guide_price_interval_start","double(10,2)","是","否","否","","指导价区间"]
["guide_price_interval_end","double(10,2)","是","否","否","","指导价区间"]
["property_nature","char(1)","是","否","否","","物业性质"]
["decoration_situation","text","是","否","否","","装修情况"]
["remark","text","是","否","否","","备注"]
["is_enable","char(1)","是","否","否","","当前可用状态 1 可用 2 禁用"]
["plan_picture","varchar(255)","是","否","否","","房型图（存储frame_date的id）"]
["environment_picture","varchar(255)","是","否","否","","室内外环境（存储frame_date的id）"]
["region","varchar(255)","是","否","否","","区域"]
["floor","varchar(255)","是","否","否","","楼层"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["state_updated_at","datetime","是","否","否","","租赁状态变更时间"]
["is_enable_updated_at","datetime","是","否","否","","可用状态变更时间"]
["is_rented","char(1)","是","否","否","","是否已租"]
["retreat_date","datetime","是","否","否","","退租时间"]
[]
["mnp_building"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["QYID","varchar(50)","是","否","否","","企业ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["LPMC","varchar(50)","是","否","否","","楼盘名称"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["LCMC","varchar(50)","是","否","否","","楼层名称"]
["LCQYMC","varchar(50)","是","否","否","","楼层区域名称"]
["ROOMNO","varchar(50)","是","否","否","","房间号"]
["ROOMCX","varchar(50)","是","否","否","","朝向"]
["MJ","double(50,2)","是","否","否","","面积（平方米）"]
["YT","varchar(50)","是","否","否","","用途"]
["REMARK","varchar(500)","是","否","否","","备注"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
["ROOMZP","varchar(1000)","是","否","否","","房间照片，存储frame_data的id使用#分隔"]
["group_id","varchar(20)","是","否","否","","园区id"]
["group_name","varchar(255)","是","否","否","","园区名称"]
["disc_id","varchar(20)","是","否","否","","楼盘id"]
["type","varchar(255)","是","否","否","","类型"]
["lon","varchar(255)","是","否","否","","精度"]
["lat","varchar(255)","是","否","否","","维度"]
["introduction","text","是","否","否","",""]

{"sheet":"数据服务订阅向导","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,6],[15,0,15,6],[22,0,22,6],[36,0,36,6]]}
[]
["park_wait_handle(待办模块)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["handle_type","int(2)","是","否","否","","待办类型(1企业审核,2入驻,3退租，4清退,5开账,6开票,7红冲)"]
["title","varchar(255)","是","否","否","","标题"]
["src_user_id","varchar(200)","是","否","否","","来源人id"]
["src_user_type","int(2)","是","否","否","","来源人类型(0管理,1企业)"]
["src_user_name","varchar(255)","是","否","否","","来源人name"]
["receive_user_id","varchar(200)","是","否","否","","接收人id(0全部)"]
["route_url","varchar(255)","是","否","否","","跳转路由地址"]
["route_param","varchar(255)","是","否","否","","携带参数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_wait_handle_on"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["handle_id","varchar(200)","是","否","否","","待办id"]
["handle_user_id","varchar(200)","是","否","否","","办理人id"]
["handle_time","datetime","是","否","否","","办理时间"]
[]
["park_wait_read"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["read_type","int(11)","是","否","否","","待阅类型(1合同到期,2应收款调整,3风险与提醒,4人员管理,5经发)"]
["title","varchar(255)","是","否","否","","标题"]
["src_user_id","varchar(200)","是","否","否","","来源人id"]
["src_user_type","int(11)","是","否","否","","来源人类型(0管理,1企业)"]
["src_user_name","varchar(255)","是","否","否","","来源人name"]
["receive_user_id","varchar(200)","是","否","否","","接收人id(0全部)"]
["route_url","varchar(255)","是","否","否","","跳转路由地址"]
["route_param","varchar(255)","是","否","否","","携带参数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_wait_read_on"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["read_id","varchar(200)","是","否","否","","待阅id"]
["read_user_id","varchar(200)","是","否","否","","阅读人id"]
["read_time","datetime","是","否","否","","阅读时间"]

{"sheet":"专题和基础数据","index":2,"n_rows":3241,"n_cols":7,"rows_kept":3241,"cut":false,"hidden":false,"merged":[[1,0,1,6],[14,0,14,6],[28,0,28,6],[55,0,55,6],[68,0,68,6],[93,0,93,6],[106,0,106,6],[112,0,112,6],[136,0,136,6],[169,0,169,6],[186,0,186,6],[199,0,199,6],[214,0,214,6],[225,0,225,6],[270,0,270,6],[291,0,291,6],[319,0,319,6],[414,0,414,6],[443,0,443,6],[449,0,449,6],[463,0,463,6],[482,0,482,6],[492,0,492,6],[507,0,507,6],[572,0,572,6],[584,0,584,6],[600,0,600,6],[641,0,641,6],[648,0,648,6],[663,0,663,6],[671,0,671,6],[680,0,680,6],[690,0,690,6],[701,0,701,6],[712,0,712,6],[718,0,718,6],[731,0,731,6],[743,0,743,6],[749,0,749,6],[763,0,763,6],[768,0,768,6],[781,0,781,6],[791,0,791,6],[797,0,797,6],[802,0,802,6],[810,0,810,6],[816,0,816,6],[851,0,851,6],[859,0,859,6],[868,0,868,6],[897,0,897,6],[905,0,905,6],[925,0,925,6],[931,0,931,6],[951,0,951,6],[1003,0,1003,6],[1051,0,1051,6],[1078,0,1078,6],[1155,0,1155,6],[1231,0,1231,6],[1253,0,1253,6],[1269,0,1269,6],[1282,0,1282,6],[1289,0,1289,6],[1297,0,1297,6],[1313,0,1313,6],[1343,0,1343,6],[1351,0,1351,6],[1378,0,1378,6],[1386,0,1386,6],[1396,0,1396,6],[1403,0,1403,6],[1416,0,1416,6],[1423,0,1423,6],[1448,0,1448,6],[1472,0,1472,6],[1501,0,1501,6],[1516,0,1516,6],[1526,0,1526,6],[1539,0,1539,6],[1573,0,1573,6],[1592,0,1592,6],[1626,0,1626,6],[1644,0,1644,6],[1653,0,1653,6],[1663,0,1663,6],[1674,0,1674,6],[1688,0,1688,6],[1705,0,1705,6],[1734,0,1734,6],[1745,0,1745,6],[1770,0,1770,6],[1792,0,1792,6],[1817,0,1817,6],[1836,0,1836,6],[1899,0,1899,6],[1915,0,1915,6],[1922,0,1922,6],[1940,0,1940,6],[1955,0,1955,6],[1982,0,1982,6],[1997,0,1997,6],[2007,0,2007,6],[2016,0,2016,6],[2026,0,2026,6],[2039,0,2039,6],[2065,0,2065,6],[2082,0,2082,6],[2102,0,2102,6],[2125,0,2125,6],[2137,0,2137,6],[2173,0,2173,6],[2190,0,2190,6],[2206,0,2206,6],[2229,0,2229,6],[2256,0,2256,6],[2288,0,2288,6],[2296,0,2296,6],[2307,0,2307,6],[2316,0,2316,6],[2326,0,2326,6],[2339,0,2339,6],[2347,0,2347,6],[2382,0,2382,6],[2393,0,2393,6],[2406,0,2406,6],[2420,0,2420,6],[2427,0,2427,6],[2441,0,2441,6],[2448,0,2448,6],[2456,0,2456,6],[2464,0,2464,6],[2482,0,2482,6],[2504,0,2504,6],[2533,0,2533,6],[2620,0,2620,6],[2634,0,2634,6],[2651,0,2651,6],[2666,0,2666,6],[2680,0,2680,6],[2698,0,2698,6],[2713,0,2713,6],[2741,0,2741,6],[2756,0,2756,6],[2819,0,2819,6],[2833,0,2833,6],[2842,0,2842,6],[2865,0,2865,6],[2886,0,2886,6],[2896,0,2896,6],[2910,0,2910,6],[2929,0,2929,6],[2945,0,2945,6],[2959,0,2959,6],[2973,0,2973,6],[2984,0,2984,6],[2994,0,2994,6],[3010,0,3010,6],[3019,0,3019,6],[3035,0,3035,6],[3044,0,3044,6],[3052,0,3052,6],[3064,0,3064,6],[3072,0,3072,6],[3086,0,3086,6],[3103,0,3103,6],[3122,0,3122,6],[3129,0,3129,6],[3139,0,3139,6],[3149,0,3149,6],[3161,0,3161,6],[3182,0,3182,6],[3195,0,3195,6],[3212,0,3212,6]]}
[]
["user_relation"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["user_id","varchar(50)","是","否","否","",""]
["user_type","varchar(100)","是","否","否","","用户关联身份类型，3是企业主账号,2是企业子账号"]
["reference_id","varchar(50)","是","否","否","","关联类型的对应主表ID"]
["relation_status","varchar(1)","是","否","否","","0申请中，1身份确认，2身份取消"]
["apply_info","text","是","否","否","","申请的明细，根据申请关联类型而定"]
["audited_at","datetime","是","否","否","","审批时间"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
[]
["bill_back_invoice_log(账单_坏账红冲记录表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["bill_management_id","varchar(255)","是","否","否","","账单,开票,收款主表联合表id"]
["back_invoice_amount","decimal(11,2)","是","否","否","","红冲金额(全部红冲就不填了)"]
["back_invoice_reason","text","是","否","否","","红冲原因"]
["file_address","text","是","否","否","","上传附件地址"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["bill_company_electricity(账单管理/开账管理/账单导入 电费导入模块)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_id","varchar(50)","是","否","否","","公司匹配公司id"]
["company_name","varchar(255)","是","否","否","","导入公司名称(户号)"]
["bill_management_id","varchar(128)","是","否","否","","账单,开票,收款主表联合表id"]
["receivable_name","varchar(255)","是","否","否","","账单名称"]
["rest_amount","decimal(11,2)","是","否","否","","充值卡剩余金额（元）"]
["building","varchar(255)","是","否","否","","所在楼栋"]
["energy_type","varchar(50)","是","否","否","","能耗类型(1电费，2水费)"]
["month","varchar(50)","是","否","否","","账单归属"]
["bill_date","varchar(50)","是","否","否","","归属账期时间段如:2021/01/012021/01/31"]
["group_id","varchar(50)","是","否","否","","园区"]
["number","int(11)","是","否","否","","数量"]
["unit","varchar(50)","是","否","否","","单位"]
["unit_price","decimal(11,2)","是","否","否","","单价"]
["receivable_amount","decimal(11,2)","是","否","否","","账单金额（元）"]
["expiration_time","datetime","是","否","否","","到期时间(暂时不用)"]
["expiration_date","date","是","否","否","","账单到期日"]
["import_time","datetime","是","否","否","","导入时间"]
["import_person","varchar(64)","是","否","否","","导入人"]
["created_by","varchar(64)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["status","int(4)","是","否","否","","状态"]
[]
["bill_company_electricity_relationship(公司电费导入时公司名称和系统公司信息的匹配关系)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["import_company_name","varchar(255)","否","否","否","","导入时用的公司名称"]
["company_id","varchar(128)","否","否","否","","对应的系统公司id"]
["bill_company_electricity_id","varchar(128)","否","否","否","","对应添加时相应的导入记录表id"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["bill_company_energy(企业能耗账单改造成:==>账单管理/开账管理/账单导入 水电费导入模块)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_id","varchar(50)","是","否","否","","公司匹配公司id"]
["company_name","varchar(255)","是","否","否","","导入公司名称"]
["bill_management_id","varchar(128)","是","否","否","","账单,开票,收款主表联合表id"]
["building","varchar(255)","是","否","否","","所在楼栋"]
["energy_type","varchar(50)","是","否","否","","能耗类型(1电费，2水费,3公摊电费)"]
["month","varchar(50)","是","否","否","","账单归属"]
["bill_date","varchar(50)","是","否","否","","归属账期时间段如:2021/01/012021/01/31"]
["group_id","varchar(50)","是","否","否","","园区"]
["number","int(11)","是","否","否","","数量"]
["unit","varchar(50)","是","否","否","","单位"]
["unit_price","decimal(11,2)","是","否","否","","单价"]
["receivable_amount","decimal(11,2)","是","否","否","","账单金额（元）"]
["expiration_time","datetime","是","否","否","","到期时间(暂时不用)"]
["expiration_date","date","是","否","否","","账单到期日"]
["import_time","datetime","是","否","否","","导入时间"]
["import_person","varchar(64)","是","否","否","","导入人"]
["created_by","varchar(64)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["status","int(4)","是","否","否","","状态"]
[]
["bill_company_energy_relationship(公司水电费导入时公司名称和系统公司信息的匹配关系)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["import_company_name","varchar(255)","否","否","否","","导入时用的公司名称"]
["company_id","varchar(128)","否","否","否","","对应的系统公司id"]
["bill_company_energy_id","varchar(128)","否","否","否","","对应添加时相应的导入记录表id"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["bill_contract_house(合同和房子对应的名称信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","bigint(20)","否","是","是","",""]
["contract_id","varchar(255)","是","否","否","","合同id"]
["house_name","text","是","否","否","",""]
[]
["bill_create_detail(账单_租金/物业费账单详细统计表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["bill_management_id","varchar(128)","是","否","否","","账单,开票,收款主表联合表id"]
["bill_company_id","varchar(128)","是","否","否","","账单付款公司id"]
["contract_id","varchar(255)","是","否","否","","对应合同id"]
["contract_number","varchar(255)","是","否","否","","对应合同编号"]
["contract_rent_id","varchar(255)","是","否","否","","合同租金单价表id"]
["contract_rent_price","decimal(10,2)","是","否","否","","合同租金单价"]
["contract_type","int(4)","是","否","否","","账单类型(1租金,4物业费)"]
["bill_date_str","varchar(255)","是","否","否","","归属账期"]
["bill_date_start","datetime","是","否","否","","归属账期开始时间"]
["bill_date_end","datetime","是","否","否","","归属账期结束时间"]
["bill_name","varchar(255)","是","否","否","","账单名称"]
["bill_amount","decimal(12,2)","是","否","否","","账单金额"]
["expiration_date","date","是","否","否","","账单到期日"]
["open_date","date","是","否","否","","开账任务生成日期"]
["status","int(4)","是","否","否","","状态0正常,1删除,2,合同异常终止情况"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["bill_management(账单,开票,收款主表联合表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["bill_type","int(4)","是","否","否","","账单类型(1租金,2水费,3电费,4物业费,5公摊电费)"]
["contract_id","varchar(255)","是","否","否","","对应合同id"]
["contract_rent_id","varchar(255)","是","否","否","","合同租金单价表id"]
["contract_rent_price","decimal(10,2)","是","否","否","","合同租金单价"]
["contract_number","varchar(255)","是","否","否","","对应合同编号"]
["bill_date_str","varchar(255)","是","否","否","","归属账期"]
["bill_name","varchar(255)","是","否","否","","账单名称"]
["expiration_date","date","是","否","否","","账单到期日"]
["bill_company_id","varchar(255)","是","否","否","","账单付款公司id"]
["bill_create_total_money","decimal(12,2)","是","否","否","","生成的账单总金额"]
["bill_update_money","decimal(12,2)","是","否","否","","调整金额,正值为加钱,负值为减钱"]
["bill_real_total_money","decimal(12,2)","是","否","否","","最终账单总金额"]
["bill_agree","int(4)","是","否","否","","1同意开账,null未开账, 2不同意开账,0待开账"]
["bill_operater_id","varchar(64)","是","否","否","","开账操作人id"]
["bill_operate_address","varchar(128)","是","否","否","","'开账操作人记录地址id"]
["bill_operate_time","datetime","是","否","否","","开账操作时间"]
["invoice_is_need","int(4)","是","否","否","","初始必填项,是否需要开票,1需要开票,2不需要开票,3因为坏账红冲所以申请停止开票"]
["collect_is_need","int(4)","是","否","否","","初始必填项,是否需要收款,1需要收款,2不需要收款,3因为红冲停止收款"]
["collect_total_money","decimal(12,2)","是","否","否","","当前收款金额"]
["collect_operater_id","varchar(64)","是","否","否","","最新收款确认人id"]
["collect_operater_time","datetime","是","否","否","","最新收款确认时间"]
["collect_is_success","int(4)","是","否","否","0","'是否完成收款1完成,null/0没有完成,2部分收款',"]
["bad_bill_time","datetime","是","否","否","","修改为坏账的日期"]
["status","int(4)","是","否","否","","状态0正常,1删除,2合同终止"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["bill_pay_log(账单_收款/红冲记录表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["pay_money","decimal(12,2)","是","否","否","","当前收款/红冲金额"]
["company_id","varchar(128)","是","否","否","","收款公司id"]
["pay_type","int(4)","是","否","否","","收款类型(1.线下收款,2线上收款,3线下红冲,4线上红冲)"]
["other_bank_number","varchar(255)","是","否","否","","对方银行号"]
["my_bank_number","varchar(255)","是","否","否","","自己银行号"]
["my_serial_number","varchar(255)","是","否","否","","自己流水号"]
["pay_time","datetime","是","否","否","","收款到账日期"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(512)","是","否","否","","说明(备注)"]
[]
["bill_pay_log_detail(账单_收款/红冲拆分对应到账单的记录表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["bill_pay_log_id","varchar(255)","是","否","否","","收款/红冲记录表id"]
["bill_management_id","varchar(255)","是","否","否","","账单,开票,收款主表联合表id"]
["pay_money","decimal(12,2)","是","否","否","","拆分收款/红冲金额"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["bill_update_log(账单_账单应收调整表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["bill_management_id","varchar(255)","是","否","否","","账单,开票,收款主表联合表id"]
["update_amount","decimal(11,2)","是","否","否","","调整金额(为加金额为减金额)"]
["real_total_money","decimal(11,2)","是","否","否","","调整后金额"]
["update_reason","text","是","否","否","","调整原因"]
["file_address","text","是","否","否","","上传附件地址"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["biz_dept"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["dept_name","varchar(50)","是","否","否","",""]
["dept_code","varchar(50)","是","否","否","",""]
["comment","varchar(200)","是","否","否","",""]
["main_id","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","",""]
[]
["biz_main"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["pid","varchar(50)","是","否","否","","关联的上一级合作商"]
["business_name","varchar(100)","否","否","否","","名称"]
["business_scope","varchar(1024)","是","否","否","","经营范围"]
["address_code","varchar(100)","是","否","否","","址地编码"]
["address_display","varchar(100)","是","否","否","","址地显示"]
["address_other","varchar(100)","是","否","否","","址地其他详情"]
["user_name_default","varchar(100)","是","否","否","","默认登录用户"]
["legal_person","varchar(100)","是","否","否","","法人"]
["tax_number","varchar(50)","是","否","否","","税号"]
["bank_user","varchar(100)","是","否","否","","开户名称"]
["bank_name","varchar(100)","是","否","否","","开户行"]
["bank_account","varchar(50)","是","否","否","","银行账号"]
["receipt_has","varchar(1)","是","否","否","","是否提供发票，0是，1否"]
["receipt_type","varchar(1)","是","否","否","","发票类型，0增票，1普票"]
["receipt_from","varchar(255)","是","否","否","","发票提供单位"]
["contact_user","varchar(50)","是","否","否","","联系人"]
["contact_phone","varchar(50)","是","否","否","","联系电话"]
["contact_no","varchar(50)","是","否","否","","公司电话"]
["specification","varchar(255)","是","否","否","","特长说明"]
["dev_ability","text","是","否","否","","研发能力"]
["type","varchar(10)","是","否","否","","类型，字典项"]
["is_headquarters","varchar(10)","是","否","否","","是否总部"]
["is_import_export","varchar(10)","是","否","否","","是否进出口"]
["is_foreign_owned","varchar(10)","是","否","否","","是否外资企业"]
["registered_category","varchar(10)","是","否","否","","行业分类"]
["registered_tag","varchar(10)","是","否","否","","注册标识"]
["registered_capital","varchar(10)","是","否","否","","注册资金"]
["registered_at","datetime","是","否","否","","注册时间"]
["mail","varchar(50)","是","否","否","","邮箱"]
["mode_code","varchar(20)","是","否","否","","业务模式码"]
["fixable","varchar(1)","是","否","否","1","0不可删除，1常规"]
["status","varchar(1)","是","否","否","","0启用，1禁用"]
["is_init","char(1)","是","否","否","","0未初始化，1已初始化"]
["enable_at","datetime","是","否","否","","启用时间"]
["disable_at","datetime","是","否","否","","禁用时间"]
["created_from","varchar(20)","是","否","否","","0平台，1注册"]
["created_by","varchar(50)","是","否","否","","创建人，平台创建才有创建人"]
["created_at","datetime","是","否","否","",""]
["updated_by","varchar(50)","是","否","否","","操作人"]
["updated_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","",""]
[]
["biz_user"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["username","varchar(50)","否","否","否","","登录用户"]
["password","varchar(50)","否","否","否","","登录密码"]
["disp_name","varchar(50)","是","否","否","","显示名"]
["phone","varchar(50)","是","否","否","","手机号"]
["gender","varchar(1)","是","否","否","","性别，1男，2女"]
["profession","varchar(50)","是","否","否","","职务"]
["remark","varchar(1024)","是","否","否","","备注说明"]
["main_name","varchar(100)","是","否","否","",""]
["main_id","varchar(50)","是","否","否","",""]
["dept_id","varchar(50)","是","否","否","",""]
["fixable","varchar(1)","是","否","否","","0不可删除，1常规"]
["is_init","char(1)","是","否","否","","0未初始化，1已初始化"]
["created_by","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_by","varchar(50)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","",""]
[]
["bond_manage"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["credit_code","varchar(255)","是","否","否","","企业信用代码"]
["contract_id","varchar(255)","是","否","否","","合同id"]
["contract_no","varchar(255)","是","否","否","","合同编号"]
["contract_nature","varchar(255)","是","否","否","","合同性质（1 新增、2 续签）"]
["start_date","datetime","是","否","否","","合同开始时间"]
["end_date","datetime","是","否","否","","合同结束时间"]
["total_rent","decimal(20,2)","是","否","否","","总租金额（万元）"]
["total_property_cost","decimal(20,2)","是","否","否","","总物业费金额（万元）"]
["bond","decimal(20,2)","是","否","否","","房屋保证金"]
["status","varchar(255)","是","否","否","","保证金状态"]
["account_date","datetime","是","否","否","","保证金到账日期"]
["settle_in_id","varchar(255)","是","否","否","","关联入驻单入驻单id"]
["refund_date","datetime","是","否","否","","se"]
["refund_amount","decimal(20,2)","是","否","否","","实退金额"]
["letter_of_guarantee","text","是","否","否","","保函"]
["remark","text","是","否","否","","备注"]
["is_recovery","varchar(255)","是","否","否","","保证金压条是否回收"]
["difference_remark","text","是","否","否","","差额说明"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_id","varchar(255)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["clearance(清退表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["node","varchar(255)","是","否","否","","节点"]
["status","varchar(255)","是","否","否","","流转状态"]
["no","varchar(255)","是","否","否","","退租单号"]
["enterprise_id","varchar(20)","是","否","否","","企业ID"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["credit_code","varchar(255)","是","否","否","","信用代码"]
["contract_id","varchar(255)","是","否","否","","合同id"]
["area","decimal(20,2)","是","否","否","","面积"]
["address","varchar(255)","是","否","否","","租赁地点"]
["retreat_type","varchar(255)","是","否","否","","退租类型（离园、本园换租赁载体、其他）"]
["retreat_nature","varchar(255)","是","否","否","","退租性质（到期退租、提前退租）"]
["reason_enterprise","varchar(255)","是","否","否","","原因说明（企业端）"]
["check_out_apply_date","datetime","是","否","否","","申请退房日期"]
["authorized_agent","varchar(255)","是","否","否","","退房授权代理人"]
["phone","varchar(255)","是","否","否","","联系电话"]
["refund_bond","decimal(10,2)","是","否","否","","需退房屋保证金"]
["bond_receipt","varchar(255)","是","否","否","","保证金收据"]
["enterprise_submit_date","datetime","是","否","否","","企业提交退租申请的日期"]
["retreat_type_confirm","varchar(255)","是","否","否","","退租类型确认（离园、不离园）"]
["retreat_reason","varchar(255)","是","否","否","","退租原因（本园换租赁载体、经验不善离园、其他原因离园）"]
["retreat_explain","varchar(255)","是","否","否","","退租说明"]
["settlement_time","datetime","是","否","否","","确认结算时间"]
["circulation_order","text","是","否","否","","流转单"]
["confirm_date","datetime","是","否","否","","确认日期"]
["confirm_name","varchar(255)","是","否","否","","确认人"]
["confirm_room","varchar(2000)","是","否","否","","确认本次退租房间"]
["confirm_room_options","varchar(2000)","是","否","否","","确认本次退租房间下拉框数据（方便回显）"]
["supplement_money","decimal(20,2)","是","否","否","","需企业补交租金物业费"]
["refund_money","decimal(20,2)","是","否","否","","需退企业预缴租金物业费"]
["supplement_refund_explain","text","是","否","否","","补交或退费说明"]
["handling_opinions","text","是","否","否","","退房办理意见"]
["arrears_confirm_date","datetime","是","否","否","","欠款及退房确认提交申请日期"]
["arrears_confirm_name","varchar(255)","是","否","否","","欠款及退房确认提交人姓名"]
["house_repair_opinion","text","是","否","否","","房源修复意见"]
["house_repair_cost","decimal(20,2)","是","否","否","","房源修复涉及费用"]
["water_electricity_reading","varchar(255)","是","否","否","","水电表读数"]
["water_electricity_cost","decimal(20,2)","是","否","否","","水电表读数涉及费用"]
["key_handover","varchar(255)","是","否","否","","钥匙交接"]
["key_handover_cost","decimal(20,2)","是","否","否","","钥匙交接涉及费用"]
["goods_handover","text","是","否","否","","物品交接"]
["goods_handover_cost","decimal(20,2)","是","否","否","","物品交接涉及费用"]
["fire_fighting","varchar(255)","是","否","否","","消防"]
["fire_fighting_cost","decimal(10,2)","是","否","否","","消防涉及费用"]
["aircondition","varchar(255)","是","否","否","","空调"]
["aircondition_cost","decimal(20,2)","是","否","否","","空调涉及费用"]
["weak_current","varchar(255)","是","否","否","","弱电"]
["weak_current_cost","decimal(20,2)","是","否","否","","弱电涉及费用"]
["others","text","是","否","否","","其他说明"]
["others_cost","decimal(20,2)","是","否","否","","其他说明涉及费用"]
["total_cost","decimal(20,2)","是","否","否","","总费用"]
["handover_date","datetime","是","否","否","","交接日期"]
["handover_name","varchar(255)","是","否","否","","交接人"]
["bill_balance","decimal(20,2)","是","否","否","","当前企业账单结余（元）"]
["refunded_bond","decimal(20,2)","是","否","否","","待退保证金"]
["handover_cost","decimal(20,2)","是","否","否","","物业交接需扣除费用合计"]
["refund_bond_total","decimal(20,2)","是","否","否","","合计应退保证金金额"]
["refunded_property_fee","decimal(20,2)","是","否","否","","需退企业预缴租金物业费"]
["refunded_file","text","是","否","否","","退费及退款附件上传"]
["refunded_remark","text","是","否","否","","退费及退款办理备注"]
["handle_date","datetime","是","否","否","","办理日期"]
["handle_name","varchar(255)","是","否","否","","办理人"]
["actual_check_out_date","datetime","是","否","否","","实际退房日期"]
["check_out_templete","text","是","否","否","","退房单模板"]
["check_out_file","text","是","否","否","","退房单"]
["completion_remark","text","是","否","否","","退房办结备注"]
["completion_date","datetime","是","否","否","","办结日期"]
["completion_name","varchar(255)","是","否","否","","办结人"]
["clearance_date","datetime","是","否","否","","清退日期"]
["clearance_type","varchar(255)","是","否","否","","清退类型（正常退租、快速清退）"]
["quick_reason","text","是","否","否","","场地状态及快速清退原因"]
["judgment_num","varchar(255)","是","否","否","","判决书编号"]
["judgment_file","text","是","否","否","","判决书文件"]
["quick_initiation_time","datetime","是","否","否","","快速清退发起时间"]
["quick_initiation_name","varchar(255)","是","否","否","","快速清退发起人"]
["quick_handover_time","datetime","是","否","否","","快速清退现场交接日期"]
["quick_handover_name","varchar(255)","是","否","否","","快速清退现场交接人"]
["quick_settlement_type","varchar(255)","是","否","否","","费用结算类型（1  退回、2追缴）"]
["quick_refund","decimal(20,2)","是","否","否","","费用结算退回"]
["quick_recovery","decimal(20,2)","是","否","否","","费用结算追缴"]
["quick_fee_settlement_file","text","是","否","否","","费用结算附件"]
["quick_fee_settlement_remark","text","是","否","否","","费用结算备注"]
["quick_handle_time","datetime","是","否","否","","费用结算办理时间"]
["quick_handle_name","varchar(255)","是","否","否","","费用结算办理人"]
["return_order_template","varchar(255)","是","否","否","","清退单模板"]
["return_order","text","是","否","否","","清退单签字版"]
["quick_completion_time","datetime","是","否","否","","快速清退办结时间"]
["quick_completion_name","varchar(255)","是","否","否","","快速清退办结人"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["update_id","varchar(255)","是","否","否","",""]
[]
["company_info"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","","主键ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["FRDB","varchar(50)","是","否","否","","法人代表"]
["QYLXR","varchar(50)","是","否","否","","企业联系人"]
["LXDH","varchar(50)","是","否","否","","联系电话"]
["GSZCSJ","date","是","否","否","","工商注册时间"]
["GSBGSJ","date","是","否","否","","工商变更时间"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["TZXY","varchar(50)","是","否","否","","投资协议"]
["ZCZB","double(50,2)","是","否","否","","注册资本"]
["BZ","varchar(50)","是","否","否","","币种"]
["JYFW","varchar(2000)","是","否","否","","经营范围"]
["ZCDZ","varchar(500)","是","否","否","","注册地址"]
["QYXZ","varchar(50)","是","否","否","","企业性质"]
["ZT","varchar(50)","是","否","否","","状态"]
["ZLS","varchar(50)","是","否","否","","专利数"]
["RS","varchar(50)","是","否","否","","人数"]
["DZXLRS","varchar(50)","是","否","否","","大专以上学历人数"]
["SSXLRS","varchar(50)","是","否","否","","硕士以上学历人数"]
["LXRS","varchar(50)","是","否","否","","留学人员数"]
["HDFT","varchar(50)","是","否","否","","获得风投(万元)"]
["SFGXJSQY","varchar(50)","是","否","否","","是否高新技术企业"]
["QYFWLXR","varchar(50)","是","否","否","","企业服务联系人"]
["REMARK","varchar(500)","是","否","否","","备注"]
["RZRQ","date","是","否","否","","入住日期"]
["QCRQ","date","是","否","否","","迁出日期"]
[]
["contract_house(合同房屋管理表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["contract_id","varchar(255)","是","否","否","","合同id"]
["house_id","varchar(255)","是","否","否","","房屋id"]
[]
["contract_rent"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["contract_id","varchar(50)","是","否","否","","合同id"]
["start_date","datetime","是","否","否","","开始时间"]
["end_date","datetime","是","否","否","","结束时间"]
["price","decimal(10,2)","是","否","否","","该时间段租金单价"]
["month_price","decimal(10,2)","是","否","否","","该时间段月租金"]
["lease_cycle","decimal(10,2)","是","否","否","","该时间段阶段周期"]
["total_rent","decimal(10,2)","是","否","否","","该时间段阶段租金合计"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["customer_main"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["cust_name","varchar(100)","否","否","否","","客户名称"]
["nick_name","varchar(100)","是","否","否","",""]
["img_url","varchar(255)","是","否","否","",""]
["address_code","varchar(100)","是","否","否","","址地编码"]
["address_display","varchar(100)","是","否","否","","址地编码显示"]
["address_other","varchar(100)","是","否","否","","址地其他详情"]
["tax_number","varchar(50)","是","否","否","","税号"]
["bank_name","varchar(100)","是","否","否","","开户行"]
["bank_account","varchar(50)","是","否","否","","银行账号"]
["contact_user","varchar(50)","是","否","否","","联系人"]
["contact_phone","varchar(50)","是","否","否","",""]
["type","varchar(1)","是","否","否","","类型,0企业，1个人"]
["biz_id","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["demo_student(学生演示表（框架演示用）)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["name","varchar(50)","是","否","否","","姓名"]
["gender","varchar(10)","是","否","否","","性别"]
["birthday","datetime","是","否","否","","生日"]
["comment","varchar(100)","是","否","否","","备注"]
["created_at","datetime","是","否","否","","创建时间"]
["created_by","varchar(50)","是","否","否","","创建人"]
[]
["ec_company_actual(实际营收 税收表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","","主键ID"]
["SSBK","varchar(50)","是","否","否","","所属板块"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["YF","varchar(50)","是","否","否","","导入月份yyyyMM"]
["DRSJ","datetime","是","否","否","","导入时间"]
["SJLX","varchar(50)","是","否","否","","数据类型营收导入、税收导入"]
["JE","decimal(50,2)","是","否","否","","税收/营收金额"]
["cfje","decimal(50,2)","是","否","否","","餐费金额,只有营业导入的时候才可能有值"]
["ZT","varchar(50)","是","否","否","","状态"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
[]
["ec_company_info(企业信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","","主键ID"]
["SSBK","varchar(50)","是","否","否","","所属板块"]
["SJLY","varchar(50)","是","否","否","","数据来源"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["FRDB","varchar(50)","是","否","否","","法人代表"]
["ZCZB","double(50,2)","是","否","否","","注册资本"]
["JYFW","varchar(2000)","是","否","否","","经营范围"]
["ZCDZ","varchar(500)","是","否","否","","注册地址"]
["ZT","varchar(50)","是","否","否","","状态"]
["HZXY","varchar(50)","是","否","否","","合作协议"]
["SYZTMJ","varchar(50)","是","否","否","","使用载体面积"]
["RZRQ","date","是","否","否","","入住日期"]
["QCRQ","date","是","否","否","","迁出日期"]
["QYLXR","varchar(50)","是","否","否","","企业联系人"]
["LXDH","varchar(50)","是","否","否","","联系电话"]
["REMARK","varchar(500)","是","否","否","","备注"]
["ZTZ","double(50,2)","是","否","否","","总投资(万元)"]
["QYFWZYID","varchar(50)","是","否","否","","企业服务专员ID"]
["QYFWZY","varchar(50)","是","否","否","","企业服务专员"]
["QYFWBMID","varchar(50)","是","否","否","","企业服务部门ID"]
["QYFWBM","varchar(50)","是","否","否","","企业服务部门"]
["QYXZ","varchar(50)","是","否","否","","通用属性企业性质如二产、三产"]
["HYMC","varchar(50)","是","否","否","","通用属性行业名称"]
["YJGM","varchar(50)","是","否","否","","规模属性一级规模"]
["EJGM","varchar(50)","是","否","否","","规模属性二级规模"]
["CYLB","varchar(50)","是","否","否","","产业属性产业类别"]
["JJLB","varchar(50)","是","否","否","","产业属性经济类别(多选),芯片经济、电商经济、数字经济、其他"]
["SWSX","varchar(50)","是","否","否","","商务属性(多选),总部经济、外贸、跨境电商、服务外包"]
["QYKJXZ","varchar(100)","是","否","否","","企业科技性质(多选),高新技术企业、高企入库、科技中小型企业、雏鹰、瞪羚、准独角兽、独角兽，前端展示的时候转换一下"]
["GXJSQYZHRQ","date","是","否","否","","高新技术企业转化日期"]
["GQRKZHRQ","date","是","否","否","","高企入库转化日期"]
["KJZXXQYZHRQ","date","是","否","否","","科技中小型企业转化日期"]
["CYZHRQ","date","是","否","否","","雏鹰转化日期"]
["DLZHRQ","date","是","否","否","","瞪羚转化日期"]
["ZDJSZHRQ","date","是","否","否","","准独角兽转化日期"]
["DJSZHRQ","date","是","否","否","","独角兽转化日期"]
["ZLS","varchar(50)","是","否","否","","专利数"]
["SSXLRS","varchar(50)","是","否","否","","硕士以上学历人数"]
["BSXLRS","varchar(50)","是","否","否","","博士以上学历人数"]
["LXGGRS","varchar(50)","是","否","否","","留学归国人数"]
["XYKQLX","varchar(50)","是","否","否","","新引科企类型(多选)普通、科技人才、高企培育、重大项目"]
["YJRQ","date","是","否","否","","引进日期"]
["SSLD","varchar(50)","是","否","否","","所属楼栋"]
["RKZT","varchar(50)","是","否","否","","规上入库状态，调整后同步调整一级规模，二级规模"]
["GSRKRQ","date","是","否","否","","规上入库日期"]
["GSCKRQ","date","是","否","否","","规上出库日期"]
["rksm","varchar(1000)","是","否","否","","入库说明"]
["cksm","varchar(1000)","是","否","否","","出库说明"]
["CRKCZRID","varchar(50)","是","否","否","","操作人ID"]
["CRKCZR","varchar(50)","是","否","否","","操作人"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
["SFNT","varchar(50)","是","否","否","","是否拟推"]
["RKBZ","double(50,0)","是","否","否","","入库标准万,根据行业名称来联动调整"]
["WXMM","varchar(50)","是","否","否","","小程序登录密码"]
["BNDLJYS","double(50,0)","是","否","否","","本年度累计营收，数据导入时同步更新"]
["BNDLJSS","double(50,0)","是","否","否","","本年度累计税收，数据导入时同步更新"]
["WXZT","varchar(50)","是","否","否","","启用/禁用状态，控制是否登录小程序"]
["hyxfl","varchar(50)","是","否","否","","行业细分类"]
["bndyjys","double(50,0)","是","否","否","","本年度预计营收，数据导入时同步更新"]
[]
["ec_company_no_report(未填报企业表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","",""]
["SHXYDM","varchar(50)","是","否","否","",""]
["QYMC","varchar(50)","是","否","否","",""]
["YF","varchar(50)","是","否","否","",""]
["SJLX","varchar(50)","是","否","否","",""]
["YLZD1","varchar(50)","是","否","否","",""]
["YLZD2","varchar(50)","是","否","否","",""]
["YLZD3","varchar(50)","是","否","否","",""]
["YLZD4","varchar(50)","是","否","否","",""]
[]
["ec_company_predict(营收预估、餐费预估、薪资预估)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","","主键ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["TBLX","varchar(50)","是","否","否","","填报类型"]
["YF","varchar(50)","是","否","否","","填报月份yyyyMM"]
["TBSJ","datetime","是","否","否","","填报时间"]
["YYSR","double(50,0)","是","否","否","","营业收入"]
["QNTQYYSR","double(50,0)","是","否","否","","去年同期营业收入"]
["XZZE","double(50,0)","是","否","否","","薪资总额"]
["CFSR","double(50,0)","是","否","否","","餐费收入,只有餐饮业企业有"]
["DXCB","varchar(50)","是","否","否","","短信催办"]
["TBRID","varchar(50)","是","否","否","","填报人ID"]
["TBR","varchar(50)","是","否","否","","填报人"]
[]
["ec_company_report(报表相关表 建个视图 关联企业表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","","主键ID"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["YF","varchar(50)","是","否","否","","月份yyyyMM"]
["CFSR","double(50,0)","是","否","否","","本月餐费收入"]
["YYSR","double(50,0)","是","否","否","","本月营业收入"]
["SYYYSR","double(50,0)","是","否","否","","上月营业收入"]
["QNTQYYSR","double(50,0)","是","否","否","","去年同期营业收入"]
["BNLJYYSR","double(50,0)","是","否","否","","本年累计营业收入"]
["QNLJTQYYSR","double(50,0)","是","否","否","","去年累计同期营业收入"]
["NSSR","double(50,0)","是","否","否","","本月纳税收入"]
["SYNSSR","double(50,0)","是","否","否","","上月纳税收入"]
["QNTQNSSR","double(50,0)","是","否","否","","去年同期纳税收入"]
["BNLJNSSR","double(50,0)","是","否","否","","本年累计纳税收入"]
["QNLJTQNSSR","double(50,0)","是","否","否","","去年累计同期纳税收入"]
["PCFSR","double(50,0)","是","否","否","","本月餐费预估收入"]
["PYYSR","double(50,0)","是","否","否","","本月营业预估收入"]
["PSYYYSR","double(50,0)","是","否","否","","上月营业预估收入"]
["PQNTQYYSR","double(50,0)","是","否","否","","去年同期营业预估收入"]
["PBNLJYYSR","double(50,0)","是","否","否","","本年累计营业预估收入"]
["PQNLJTQYYSR","double(50,0)","是","否","否","","去年累计同期营业预估收入"]
["PNSSR","double(50,0)","是","否","否","","本月纳税预估收入"]
["PSYNSSR","double(50,0)","是","否","否","","上月纳税预估收入"]
["PQNTQNSSR","double(50,0)","是","否","否","","去年同期纳税预估收入"]
["PBNLJNSSR","double(50,0)","是","否","否","","本年累计纳税预估收入"]
["PQNLJTQNSSR","double(50,0)","是","否","否","","去年累计同期纳税预估收入"]
["JDYYSR","double(50,0)","是","否","否","","本季度营业收入"]
["JDNSSR","double(50,0)","是","否","否","","本季度纳税收入"]
["SJDYYSR","double(50,0)","是","否","否","","上季度营业收入"]
["SJDNSSR","double(50,0)","是","否","否","","上季度纳税收入"]
["QNTJDNSSR","double(50,0)","是","否","否","","去年同季度纳税收入"]
["QNTJDYYSR","double(50,0)","是","否","否","","去年同季度营业收入"]
["PJDYYSR","double(50,0)","是","否","否","","本季度营业预计收入"]
["PJDNSSR","double(50,0)","是","否","否","","本季度纳税预计收入"]
["PSJDYYSR","double(50,0)","是","否","否","","上季度营业预计收入"]
["PSJDNSSR","double(50,0)","是","否","否","","上季度纳税预计收入"]
["PQNTJDNSSR","double(50,0)","是","否","否","","去年同季度纳税预计收入"]
["PQNTJDYYSR","double(50,0)","是","否","否","","去年同季度营业预计收入"]
[]
["ec_company_scale_revenue"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["hymc","varchar(4)","否","否","否","","行业名称"]
["hyxfl","varchar(12)","是","否","否","","行业细分类"]
["gsys","varchar(4)","否","否","否","","规上营收"]
["qzgsys","varchar(4)","否","否","否","","潜上规上营收"]
[]
["ec_import_task(导入填报任务表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ROWGUID","varchar(50)","否","是","否","","主键ID"]
["YF","varchar(50)","是","否","否","","任务月份yyyyMM"]
["SSDRBJ","varchar(50)","是","否","否","","税收收入导入标记"]
["YSDRBJ","varchar(100)","是","否","否","","营收收入导入标记"]
["TBBJ","varchar(100)","是","否","否","","填报标记"]
["ZT","varchar(50)","是","否","否","","状态"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
["TBRID","varchar(50)","是","否","否","","填报人ID"]
["TBR","varchar(50)","是","否","否","","填报人"]
["TBSJ","datetime","是","否","否","","填报时间"]
[]
["ec_import_task_queue"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["rowguid","varchar(100)","否","是","否","",""]
["shxydm","varchar(100)","是","否","否","",""]
["yf","varchar(50)","否","否","否","",""]
["sjlx","varchar(50)","否","否","否","",""]
["xrsj","date","否","否","否","",""]
[]
["frame_agreement"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["agree_type","varchar(50)","是","否","否","","USER, PLATFORM, THIRD..."]
["agree_version","varchar(50)","是","否","否","","版本"]
["agree_content","text","是","否","否","","正文"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["frame_data(文件表存储表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["file_name","varchar(255)","是","否","否","","文件名"]
["file_path","varchar(255)","是","否","否","","文件路径"]
["file_type","varchar(255)","是","否","否","","文件类型"]
["file_content_type","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["thumbnail_path","varchar(255)","是","否","否","",""]
[]
["frame_exclusive_user(用户专属页面配置)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["user_id","varchar(50)","否","否","否","","用户ID"]
["page_table_name","varchar(255)","是","否","否","","页面名称"]
["table_column_info","text","是","否","否","","table配置"]
["created_by","varchar(50)","是","否","否","",""]
["updated_by","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["frame_file(文件信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","","主键"]
["file_name","varchar(255)","是","否","否","","图片名字"]
["create_user_id","varchar(255)","是","否","否","","创建人id"]
["create_user_name","varchar(255)","是","否","否","","创建人名字"]
["create_time","datetime","是","否","否","","创建时间"]
["update_user_id","varchar(255)","是","否","否","","修改人"]
["update_user_name","varchar(255)","是","否","否","","修改人名字"]
["update_time","datetime","是","否","否","","修改时间"]
[]
["frame_file_data(文件数据外键绑定表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["data_id","varchar(255)","是","否","否","",""]
["file_id","varchar(255)","是","否","否","文件id",""]
[]
["frame_op_log(日志记录表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["title","varchar(100)","是","否","否","","标题"]
["method","varchar(255)","是","否","否","","方法"]
["oper_name","varchar(100)","是","否","否","","操作人"]
["oper_url","varchar(255)","是","否","否","","url"]
["oper_param","varchar(1024)","是","否","否","","参数"]
["error_msg","varchar(1024)","是","否","否","","错误日志"]
["oper_time","date","是","否","否","","操作日期"]
["oper_at","datetime","是","否","否","","操作时间"]
["oper_ip","varchar(100)","是","否","否","","ip"]
[]
["frame_permission(权限表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","","id"]
["name","varchar(255)","是","否","否","","权限名称"]
["descripion","varchar(255)","是","否","否","","权限描述"]
["url","varchar(255)","是","否","否","","授权链接"]
["pid","varchar(255)","是","否","否","","父节点id"]
["perms","varchar(255)","是","否","否","","权限标识"]
["type","int(11)","是","否","否","","类型   0：目录   1：菜单   2：按钮"]
["icon","varchar(255)","是","否","否","","菜单图标"]
["order_num","int(11)","是","否","否","","排序"]
[]
["frame_permission_role(角色权限中间表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["role_id","varchar(255)","是","否","否","","角色id"]
["permission_id","varchar(255)","是","否","否","","权限id"]
[]
["frame_post(岗位信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","岗位ID"]
["group_id","varchar(50)","是","否","否","","集团分公司ID"]
["post_code","varchar(64)","否","否","否","","岗位编码"]
["post_name","varchar(50)","否","否","否","","岗位名称"]
["post_sort","int(11)","否","否","否","","显示顺序"]
["status","char(1)","否","否","否","","状态（0正常 1停用）"]
["created_by","varchar(64)","是","否","否","","创建者"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新者"]
["updated_at","datetime","是","否","否","","更新时间"]
["remark","varchar(500)","是","否","否","","备注"]
[]
["frame_post_user(用户与岗位关联表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["user_id","varchar(50)","否","是","否","","用户ID"]
["post_id","varchar(50)","否","是","否","","岗位ID"]
[]
["frame_role(角色表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","","id"]
["name","varchar(255)","否","否","否","","角色名称"]
["role_key","varchar(100)","是","否","否","","角色权限字符串"]
["role_sort","int(11)","是","否","否","","显示顺序"]
["data_scope","char(1)","是","否","否","1","数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）"]
["status","char(1)","是","否","否","","角色状态（0正常 1停用）"]
["checks","text","是","否","否","",""]
["halfChecks","text","是","否","否","",""]
["comments","varchar(255)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["frame_role_data"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["role_name","varchar(255)","是","否","否","","数据角色名称"]
["role_key","varchar(255)","是","否","否","","数据角色关键字，上线后不可变更"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["role_type","varchar(255)","是","否","否","",""]
["status","varchar(255)","是","否","否","",""]
[]
["frame_role_data_user"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["user_id","varchar(255)","是","否","否","",""]
["role_data_id","varchar(255)","是","否","否","","数据角色ID"]
[]
["frame_role_dept(角色和部门关联表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["role_id","bigint(20)","否","是","否","","角色ID"]
["dept_id","bigint(20)","否","是","否","","部门ID"]
[]
["frame_role_mobile"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["role_name","varchar(255)","是","否","否","","数据角色名称"]
["role_key","varchar(255)","是","否","否","","数据角色关键字，逗号分隔"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["frame_role_user(用户角色中间表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["sys_user_id","varchar(255)","是","否","否","",""]
["sys_role_id","varchar(255)","是","否","否","","角色id"]
[]
["frame_user(用户表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["group_id","varchar(50)","是","否","否","","集团ID"]
["staff_code","varchar(50)","是","否","否","","员工编号"]
["department","varchar(50)","是","否","否","","部门ID"]
["department_code","varchar(255)","是","否","否","","部门编码"]
["leader","varchar(50)","是","否","否","","上级领导ID"]
["posts","varchar(255)","是","否","否","","岗位，逗号分隔"]
["username","varchar(255)","是","否","否","","用户账号"]
["password","varchar(255)","是","否","否","","用户密码"]
["truename","varchar(255)","是","否","否","","用户姓名"]
["gender","varchar(1)","是","否","否","","性别，1男，2女"]
["phone","varchar(255)","是","否","否","","联系电话"]
["email","varchar(255)","是","否","否","","联系邮箱"]
["position","varchar(50)","是","否","否","","职位"]
["flag","varchar(10)","是","否","否","","标识，用于不同系统定义不同内容\r\n本系统中：\r\n0或空非销售，1销售人员"]
["del_flag","char(1)","是","否","否","","删除标志（0代表存在 2代表删除）"]
["status","varchar(10)","否","否","否","1","状态：0禁用， 1启用"]
["data_role","varchar(700)","是","否","否","","权限关键字，暂用于数据权限"]
["data_role_key","varchar(700)","是","否","否","",""]
["mobile_role","varchar(255)","是","否","否","","移动端权限"]
["mobile_role_key","varchar(255)","是","否","否","",""]
["sequence_no","float(11,0)","是","否","否","","顺序号"]
["secret_key","varchar(255)","是","否","否","","密钥关键字"]
["image_data","text","是","否","否","","图片数据"]
["comment","varchar(255)","是","否","否","","备注"]
["reset_at","datetime","是","否","否","","密码最新重置时间"]
["login_at","datetime","是","否","否","","最后登录时间"]
["login_ip","varchar(50)","是","否","否","","最后登录IP"]
["is_init","char(1)","是","否","否","","0未初始化，1已初始化"]
["is_lock","char(1)","是","否","否","0","0未锁定，1已锁定"]
["createdat","datetime","是","否","否","",""]
["updatedat","datetime","是","否","否","",""]
[]
["frame_user_dept"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["attr_id","varchar(50)","是","否","否","",""]
["user_id","varchar(50)","是","否","否","",""]
["dept_id","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
[]
["help_topic(help topics)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["help_topic_id","int(10) unsigned","否","是","否","",""]
["name","char(64)","否","否","否","",""]
["help_category_id","smallint(5) unsigned","否","否","否","",""]
["description","text","否","否","否","",""]
["example","text","否","否","否","",""]
["url","text","否","否","否","",""]
[]
["hik_access_record(海康推送通行记录)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","","登记id"]
["employee_no","varchar(255)","是","否","否","","设备上人员的唯一ID"]
["name","varchar(255)","是","否","否","","姓名。刷身份证、刷脸有。"]
["identity_id","varchar(255)","是","否","否","","身份证号码。刷身份证、刷脸有。"]
["sex","varchar(16)","是","否","否","","性别 男/女"]
["telephone_no","varchar(50)","是","否","否","","手机号"]
["mask","varchar(50)","是","否","否","","是否戴口罩,unknown未知，yes戴口罩，no不戴口罩"]
["qrCode_info","varchar(255)","是","否","否","","二维码字符串,刷二维码模式才有的值"]
["event_type_code","varchar(128)","是","否","否","","事件类型。IDCardInfoEvent 身份证事件；QRCodeEvent二维码事件"]
["alarm_time","timestamp","是","否","否","","登记时间 毫秒值"]
["temperature","float","是","否","否","","抓拍温度。测温模式有"]
["exceeding_threshold","int(4)","是","否","否","","体温是否异常。0正常；1异常。测温模式有"]
["health_code","varchar(16)","是","否","否","","健康码状态。01表示绿码、11表示黄码、31表示红码、21暂无用处、51其他。"]
["health_msg","varchar(255)","是","否","否","","健康码提示。如：绿码请通行。"]
["vaccine_status","int(4)","是","否","否","","疫苗接种状态(0未接种，2已接种，NULL未知)"]
["vaccine_times","int(4)","是","否","否","","疫苗接种针数"]
["travel_code","int(4)","是","否","否","","0 低风险 1 中风险 2高风险 3 其他"]
["travel_msg","varchar(255)","是","否","否","","行程消息"]
["nad_code","int(4)","是","否","否","","核酸状态(0未查询到核酸检测结果；1核酸检测阴性；2核酸检测阳性；3核酸检测有效期已过)"]
["nad_msg","varchar(255)","是","否","否","","核酸内容"]
["video_url","varchar(2000)","是","否","否","","抓拍图片。有效时间为7天，7天后无法访问。第三方平台如有需要，自行存储图片。"]
["device_serial","varchar(255)","是","否","否","","设备序列号"]
["device_name","varchar(255)","是","否","否","","设备名称"]
["payload","text","是","否","否","","设备上报的原始报文（非必要无需解析）"]
["get_date_time","timestamp","是","否","否","","获取推送数据的时间"]
["get_data_status","int(4)","是","否","否","","获取的状态,备用字段"]
[]
["hik_device_data"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","",""]
["SBXLH","varchar(50)","是","否","否","",""]
["EMPLOYEEID","varchar(50)","是","否","否","",""]
["XM","varchar(50)","是","否","否","",""]
["REMARK","varchar(500)","是","否","否","",""]
[]
["interview_escalation(走访上报)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["interview_user_id","varchar(50)","是","否","否","","走访人"]
["company_id","varchar(50)","是","否","否","","企业ID"]
["interview_user_name","varchar(255)","是","否","否","","走访人名"]
["status","varchar(50)","是","否","否","","0 保存 1提交"]
["interview_time","datetime","是","否","否","","走访时间"]
["interview_type","varchar(50)","是","否","否","","走访类型"]
["interview_record","text","是","否","否","","走访记录"]
["is_status","varchar(20)","是","否","否","","是否需要处理 （1否，2是）"]
["handle_user_id","varchar(50)","是","否","否","","处理人"]
["handle_user_name","varchar(255)","是","否","否","","处理人"]
["handle_result","text","是","否","否","","处理结果"]
["created_by","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_by","varchar(50)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["handle_time","datetime","是","否","否","","处理时间"]
[]
["invoice_bank(开票销方开户行信息)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["bank_name","varchar(255)","是","否","否","","开户行"]
["bank_number","varchar(255)","是","否","否","","开户行账号"]
[]
["invoice_header(发票抬头信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["company_id","varchar(128)","是","否","否","","公司id"]
["invoice_name","varchar(255)","是","否","否","","发票抬头名称"]
["invoice_number","varchar(255)","是","否","否","","纳税人识别号"]
["address","varchar(512)","是","否","否","","地址"]
["phone","varchar(255)","是","否","否","","电话"]
["email","varchar(255)","是","否","否","","发票发送邮箱"]
["mobile_phone","varchar(255)","是","否","否","","发票发送手机"]
["bank","varchar(255)","是","否","否","","开户行"]
["bank_number","varchar(255)","是","否","否","","账号"]
["header_finish","varchar(255)","是","否","否","","0未添加 1已添加"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["invoice_manage(开票管理信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["company_id","varchar(255)","是","否","否","","企业id"]
["bill_management_id","varchar(255)","是","否","否","","开账id"]
["contract_id","varchar(255)","是","否","否","","合同id"]
["contract_no","varchar(255)","是","否","否","","合同编号"]
["cost_type","varchar(255)","是","否","否","","费用类型"]
["belong_bill_date","varchar(255)","是","否","否","","归属账期"]
["bill_name","varchar(255)","是","否","否","","账单名称"]
["bill_amount","decimal(18,2)","是","否","否","","账单金额（元）"]
["invoice_status","varchar(255)","是","否","否","","开票状态（0待开票 1已开票 2已错开红冲 3待坏账红冲 4已坏账红冲）"]
["invoice_date","datetime","是","否","否","","开票日期"]
["invoice_code","varchar(255)","是","否","否","","发票代码"]
["invoice_no","varchar(255)","是","否","否","","发票号"]
["invoice_type","varchar(255)","是","否","否","","开票类型"]
["invoice_amount","decimal(18,2)","是","否","否","","开票金额（元）"]
["invoice_tax","varchar(255)","是","否","否","","开票税率"]
["invoice_count","decimal(18,10)","是","否","否","","开票数量"]
["invoice_price","decimal(18,2)","是","否","否","","开票单价"]
["invoice_goods_code","varchar(255)","是","否","否","","开票税收商品编码"]
["invoice_goods_name","varchar(255)","是","否","否","","商品名称"]
["invoice_seller_name","varchar(255)","是","否","否","","开票销方名称"]
["invoice_seller_number","varchar(255)","是","否","否","","开票销方税号"]
["invoice_seller_bank","varchar(255)","是","否","否","","开票销方开户行"]
["invoice_seller_bank_number","varchar(255)","是","否","否","","开票销方开户行账号"]
["invoice_seller_address","varchar(255)","是","否","否","","开票销方地址"]
["invoice_seller_phone","varchar(255)","是","否","否","","开票销方电话"]
["invoice_email","varchar(255)","是","否","否","","发票发送邮箱"]
["invoice_phone","varchar(255)","是","否","否","","发票发送手机"]
["invoice_content","varchar(255)","是","否","否","","开票内容"]
["submit_time","datetime","是","否","否","","提交开票时间"]
["submit_user","varchar(255)","是","否","否","","经办人"]
["invoice_header_id","varchar(255)","是","否","否","","发票抬头id"]
["invoice_header_name","varchar(255)","是","否","否","","发票抬头名称"]
["invoice_header_number","varchar(255)","是","否","否","","纳税人识别号"]
["invoice_header_address","varchar(512)","是","否","否","","地址"]
["invoice_header_phone","varchar(255)","是","否","否","","电话"]
["invoice_header_bank","varchar(255)","是","否","否","","开户行"]
["invoice_header_bank_number","varchar(255)","是","否","否","","账号"]
["bad_debt_reason","varchar(255)","是","否","否","","坏账红冲申请原因"]
["create_user","varchar(255)","是","否","否","","创建人id"]
["create_time","datetime","是","否","否","","创建时间"]
["update_user","varchar(255)","是","否","否","","修改人id"]
["update_time","datetime","是","否","否","","修改时间"]
["invoice_file","varchar(510)","是","否","否","","发票文件"]
["take_status","varchar(255)","是","否","否","","取票状态（0待取票 1已取票）"]
["take_user","varchar(255)","是","否","否","","取票人"]
["take_date","datetime","是","否","否","","取票日期"]
["take_notes","varchar(255)","是","否","否","","取票备注"]
["take_update_user","varchar(255)","是","否","否","","取票登记人"]
[]
["invoice_manage_history(开票管理历史信息表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["invoice_manage_id","varchar(255)","否","否","否","","开票管理id"]
["company_id","varchar(255)","是","否","否","","企业id"]
["bill_management_id","varchar(255)","是","否","否","","开账id"]
["contract_id","varchar(255)","是","否","否","","合同id"]
["contract_no","varchar(255)","是","否","否","","合同编号"]
["cost_type","varchar(255)","是","否","否","","费用类型"]
["belong_bill_date","varchar(255)","是","否","否","","归属账期"]
["bill_name","varchar(255)","是","否","否","","账单名称"]
["bill_amount","decimal(18,2)","是","否","否","","账单金额（元）"]
["invoice_status","varchar(255)","是","否","否","","开票状态（0待开票 1已开票 2已错开红冲 3待坏账红冲 4已坏账红冲）"]
["invoice_date","datetime","是","否","否","","开票日期"]
["invoice_code","varchar(255)","是","否","否","","发票代码"]
["invoice_no","varchar(255)","是","否","否","","发票号"]
["invoice_type","varchar(255)","是","否","否","","开票类型"]
["invoice_amount","decimal(18,2)","是","否","否","","开票金额（元）"]
["invoice_tax","varchar(255)","是","否","否","","开票税率"]
["invoice_count","decimal(18,4)","是","否","否","","开票数量"]
["invoice_price","decimal(18,2)","是","否","否","","开票单价"]
["invoice_goods_code","varchar(255)","是","否","否","","开票税收商品编码"]
["invoice_goods_name","varchar(255)","是","否","否","","商品名称"]
["invoice_seller_name","varchar(255)","是","否","否","","开票销方名称"]
["invoice_seller_number","varchar(255)","是","否","否","","开票销方税号"]
["invoice_seller_bank","varchar(255)","是","否","否","","开票销方开户行"]
["invoice_seller_bank_number","varchar(255)","是","否","否","","开票销方开户行账号"]
["invoice_seller_address","varchar(255)","是","否","否","","开票销方地址"]
["invoice_seller_phone","varchar(255)","是","否","否","","开票销方电话"]
["invoice_email","varchar(255)","是","否","否","","发票发送邮箱"]
["invoice_phone","varchar(255)","是","否","否","","发票发送手机"]
["invoice_content","varchar(255)","是","否","否","","开票内容"]
["submit_time","datetime","是","否","否","","提交开票时间"]
["submit_user","varchar(255)","是","否","否","","经办人"]
["invoice_header_id","varchar(255)","是","否","否","","发票抬头id"]
["invoice_header_name","varchar(255)","是","否","否","","发票抬头名称"]
["invoice_header_number","varchar(255)","是","否","否","","纳税人识别号"]
["invoice_header_address","varchar(512)","是","否","否","","地址"]
["invoice_header_phone","varchar(255)","是","否","否","","电话"]
["invoice_header_bank","varchar(255)","是","否","否","","开户行"]
["invoice_header_bank_number","varchar(255)","是","否","否","","账号"]
["bad_debt_reason","varchar(255)","是","否","否","","坏账红冲申请原因"]
["create_user","varchar(255)","是","否","否","","创建人id"]
["create_time","datetime","是","否","否","","创建时间"]
["update_user","varchar(255)","是","否","否","","修改人id"]
["update_time","datetime","是","否","否","","修改时间"]
["invoice_file","varchar(510)","是","否","否","","发票文件"]
[]
["mnp_building"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["QYID","varchar(50)","是","否","否","","企业ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["LPMC","varchar(50)","是","否","否","","楼盘名称"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["LCMC","varchar(50)","是","否","否","","楼层名称"]
["LCQYMC","varchar(50)","是","否","否","","楼层区域名称"]
["ROOMNO","varchar(50)","是","否","否","","房间号"]
["ROOMCX","varchar(50)","是","否","否","","朝向"]
["MJ","double(50,2)","是","否","否","","面积（平方米）"]
["YT","varchar(50)","是","否","否","","用途"]
["REMARK","varchar(500)","是","否","否","","备注"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
["ROOMZP","varchar(1000)","是","否","否","","房间照片，存储frame_data的id使用#分隔"]
["group_id","varchar(20)","是","否","否","","园区id"]
["group_name","varchar(255)","是","否","否","","园区名称"]
["disc_id","varchar(20)","是","否","否","","楼盘id"]
["type","varchar(255)","是","否","否","","类型"]
["lon","varchar(255)","是","否","否","","精度"]
["lat","varchar(255)","是","否","否","","维度"]
["introduction","text","是","否","否","",""]
[]
["mnp_company"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键ID"]
["enterprise_type","varchar(20)","是","否","否","","企业类型"]
["is_head","varchar(2)","是","否","否","","是否总部"]
["is_imout","varchar(2)","是","否","否","","是否进出口"]
["is_foreign","varchar(2)","是","否","否","","是否外资"]
["registration_code","varchar(20)","是","否","否","","注册标识"]
["industry","varchar(255)","是","否","否","","所属行业/行业分类"]
["ssbk","varchar(50)","是","否","否","","所属板块"]
["qymc","varchar(100)","是","否","否","","企业名称"]
["shxydm","varchar(50)","是","否","否","","统一社会信用代码"]
["zczj","double(50,2)","是","否","否","","注册资金（万元）"]
["zcsj","date","是","否","否","","注册时间"]
["fddbr","varchar(50)","是","否","否","","法定代表人"]
["jyfw","varchar(2000)","是","否","否","","经营范围"]
["manage_area","varchar(255)","是","否","否","","经营面积(平方米)"]
["zcdz","varchar(500)","是","否","否","","注册地址"]
["jydz","varchar(255)","是","否","否","","经营地址"]
["zt","varchar(50)","是","否","否","","状态"]
["rzsj","date","是","否","否","","入住时间"]
["qylxr","varchar(50)","是","否","否","","企业联系人"]
["lxdh","varchar(50)","是","否","否","","联系电话"]
["email","varchar(50)","是","否","否","","email"]
["remark","varchar(500)","是","否","否","","备注"]
["qylbbq","varchar(50)","是","否","否","","企业类别标签(单选),高企、雏鹰等"]
["glygs","int(11)","是","否","否","","关联员工数"]
["sszt","varchar(1000)","是","否","否","","所属载体ID，多个载体使用、分隔"]
["ssztmc","varchar(1000)","是","否","否","","所属载体名称，多个载体使用、分隔"]
["ldmc","varchar(50)","是","否","否","","楼栋名称"]
["lcqymc","varchar(100)","是","否","否","",""]
["czrid","varchar(50)","是","否","否","","操作人ID/改成企业申请人id"]
["czr","varchar(50)","是","否","否","","操作人"]
["czsj","datetime","是","否","否","","操作时间/改成企业申请时间"]
["gxrid","varchar(50)","是","否","否","","更新人ID/改成审核人id"]
["gxr","varchar(50)","是","否","否","","更新人"]
["gxsj","datetime","是","否","否","","更新时间/改成审核时间"]
["wxmm","varchar(50)","是","否","否","","小程序登录密码"]
["wxzt","varchar(50)","是","否","否","","启用/禁用状态，控制是否登录小程序"]
["yyzzfbzp","varchar(1000)","是","否","否","","营业执照副本，存储frame_data的id使用#分隔"]
["yyzz","text","是","否","否","","营业执照"]
["cwfzr","varchar(50)","是","否","否","","财务负责人**********"]
["cwfzrdh","varchar(50)","是","否","否","","财务负责人电话*********"]
["ryxxzp","varchar(1000)","是","否","否","","荣誉信息，存储frame_data的id使用#分隔"]
["blrq","date","是","否","否","","搬离日期"]
["fksfsh","varchar(10)","是","否","否","","访客是否审核"]
["settle_in_type","varchar(255)","是","否","否","","入驻类型"]
["scale","varchar(255)","是","否","否","","规模属性"]
["floor_disc_id","varchar(255)","是","否","否","","所属区域（所属楼盘id）"]
["room_id","varchar(255)","是","否","否","","房间id"]
["is_business_account","int(1)","是","否","否","0","是否拥有企业账户"]
["currency","int(1)","是","否","否","","币种"]
["legal_person_phone","varchar(255)","是","否","否","","法人电话*****************"]
["honor_information","varchar(2000)","是","否","否","","荣誉信息**********"]
["honor_file","text","是","否","否","","荣誉信息文件*******"]
["frsfzh","text","是","否","否","","法人身份证************"]
["rd_investment","double(11,2)","是","否","否","","全年研发投入************"]
["jg_investment","double(11,2)","是","否","否","","全年技改投入***********"]
["four_openness_amount","double(11,2)","是","否","否","","四技合同金额（技术开发）******"]
["four_transference_amount","double(11,2)","是","否","否","","四技合同金额（转让）*********"]
["four_service_amount","double(11,2)","是","否","否","","四技合同金额（服务）**********"]
["four_consult_amount","double(11,2)","是","否","否","","四技合同金额（咨询）*******"]
["investment_manager","varchar(1000)","是","否","否","","招商经理*************"]
["association_company","varchar(1000)","是","否","否","","关联企业************"]
["group_id","varchar(20)","是","否","否","","组"]
["area","varchar(255)","是","否","否","","所属区域"]
["practice_number","int(11)","是","否","否","","从业人数"]
["zscqgs","int(11)","是","否","否","","拥有知识产权个数************"]
["rzjd","varchar(50)","是","否","否","","融资进度"]
["gmsx","varchar(50)","是","否","否","","规模属性"]
["qybq","varchar(1000)","是","否","否","","企业标签"]
["entry_status","varchar(255)","是","否","否","","入驻状态"]
["fr_email","varchar(255)","是","否","否","","法人邮箱**************"]
["open_id","varchar(255)","是","否","否","",""]
["service_commissioner","varchar(255)","是","否","否","","企服专员"]
["create_time","datetime","是","否","否","","创建时间"]
[]
["mnp_company_examine"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["SSBK","varchar(50)","是","否","否","","所属板块"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","统一社会信用代码"]
["ZCZJ","double(50,2)","是","否","否","","注册资金（万元）"]
["ZCSJ","date","是","否","否","","注册时间"]
["FDDBR","varchar(50)","是","否","否","","法定代表人"]
["JYFW","varchar(2000)","是","否","否","","经营范围"]
["ZCDZ","varchar(500)","是","否","否","","注册地址"]
["JYDZ","varchar(255)","是","否","否","","经营地址"]
["ZT","varchar(50)","是","否","否","","状态"]
["RZSJ","date","是","否","否","","入住时间"]
["QYLXR","varchar(50)","是","否","否","","企业联系人"]
["LXDH","varchar(50)","是","否","否","","联系电话"]
["EMAIL","varchar(50)","是","否","否","","email"]
["REMARK","varchar(500)","是","否","否","","备注"]
["QYLBBQ","varchar(50)","是","否","否","","企业类别标签(单选),高企、雏鹰等"]
["GLYGS","int(11)","是","否","否","","关联员工数"]
["SSZT","varchar(1000)","是","否","否","","所属载体ID，多个载体使用、分隔"]
["SSZTMC","varchar(1000)","是","否","否","","所属载体名称，多个载体使用、分隔"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["LCQYMC","varchar(100)","是","否","否","",""]
["CZRID","varchar(50)","是","否","否","","操作人ID"]
["CZR","varchar(50)","是","否","否","","操作人"]
["CZSJ","datetime","是","否","否","","操作时间"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
["WXMM","varchar(50)","是","否","否","","小程序登录密码"]
["WXZT","varchar(50)","是","否","否","","启用/禁用状态，控制是否登录小程序"]
["YYZZFBZP","varchar(1000)","是","否","否","","营业执照副本，存储frame_data的id使用#分隔"]
["YYZZ","text","是","否","否","","营业执照"]
["CWFZR","varchar(50)","是","否","否","","财务负责人"]
["CWFZRDH","varchar(50)","是","否","否","","财务负责人电话"]
["RYXXZP","varchar(1000)","是","否","否","","荣誉信息，存储frame_data的id使用#分隔"]
["BLRQ","date","是","否","否","","搬离日期"]
["FKSFSH","varchar(10)","是","否","否","","访客是否审核"]
["settle_in_type","varchar(255)","是","否","否","","入驻类型"]
["scale","varchar(255)","是","否","否","","规模属性"]
["floor_disc_id","varchar(255)","是","否","否","","所属区域（所属楼盘id）"]
["room_id","varchar(255)","是","否","否","","房间id"]
["is_business_account","int(1)","是","否","否","0","是否拥有企业账户"]
["currency","int(1)","是","否","否","","币种"]
["legal_person_phone","varchar(255)","是","否","否","","法人电话"]
["honor_information","varchar(2000)","是","否","否","","荣誉信息"]
["honor_file","text","是","否","否","","荣誉信息文件"]
["FRSFZH","text","是","否","否","","法人身份证"]
["rd_investment","double(11,2)","是","否","否","","全年研发投入"]
["jg_investment","double(11,2)","是","否","否","","全年技改投入"]
["four_openness_amount","double(11,2)","是","否","否","","四技合同金额（技术开发）"]
["four_transference_amount","double(11,2)","是","否","否","","四技合同金额（转让）"]
["four_service_amount","double(11,2)","是","否","否","","四技合同金额（服务）"]
["four_consult_amount","double(11,2)","是","否","否","","四技合同金额（咨询）"]
["investment_manager","varchar(1000)","是","否","否","","招商经理"]
["association_company","varchar(1000)","是","否","否","","关联企业"]
["group_id","varchar(20)","是","否","否","","组"]
["area","varchar(255)","是","否","否","","所属区域"]
["practice_number","int(11)","是","否","否","","从业人数"]
["ZSCQGS","int(11)","是","否","否","","拥有知识产权个数"]
["RZJD","varchar(50)","是","否","否","","融资进度"]
["GMSX","varchar(50)","是","否","否","","规模属性"]
["QYBQ","varchar(1000)","是","否","否","","企业标签"]
["prove_type","varchar(2)","是","否","否","","企业认证类型(1=认证，2=修改)"]
["apply_time","datetime","是","否","否","","认证申请时间"]
["state","varchar(20)","是","否","否","","审核结果 1审核通过  2审核未通过  0'待审核'"]
["examine_time","datetime","是","否","否","","审核时间"]
["examine_user_id","varchar(20)","是","否","否","","审核人"]
["status","varchar(20)","是","否","否","","状态 1待审  3已审"]
["source","varchar(50)","是","否","否","","流程名称 企业入库审核1    企业信息完善审核2"]
["title","varchar(50)","是","否","否","","主题"]
["company_id","varchar(50)","是","否","否","","企业ID"]
["handle_opinions","text","是","否","否","","处理意见"]
["fr_email","varchar(255)","是","否","否","","法人邮箱"]
[]
["mnp_company_keynote"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["corporate_valuation","decimal(20,2)","是","否","否","","企业估值"]
["main_business","text","是","否","否","","主营业务"]
["remark","text","是","否","否","","备注"]
["register_time","datetime","是","否","否","","注册时间"]
["tags","varchar(255)","是","否","否","","企业标签"]
["current_revenue","decimal(20,2)","是","否","否","","当前累计营收"]
["last_year_revenue","decimal(20,2)","是","否","否","","上年同期营收"]
["revenue_increase","decimal(20,2)","是","否","否","","增幅"]
["current_tax","decimal(20,2)","是","否","否","","当前累计税收"]
["last_year_tax","decimal(20,2)","是","否","否","","上年同期税收"]
["tax_increase","decimal(20,2)","是","否","否","","增幅"]
["create_by","varchar(255)","是","否","否","",""]
["create_date","datetime","是","否","否","",""]
["update_date","datetime","是","否","否","",""]
["update_by","varchar(255)","是","否","否","",""]
["is_keynote","varchar(255)","是","否","否","","是否重点企业 1 重点 0 非重点"]
[]
["mnp_company_reserve"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","",""]
["enterprise_name","varchar(255)","是","否","否","",""]
["list_progress","varchar(255)","是","否","否","","上市进度"]
["list_sector","varchar(255)","是","否","否","","上市板块"]
["linked_leadership","varchar(255)","是","否","否","","挂钩领导"]
["company_profile","varchar(255)","是","否","否","","公司简介"]
["latest_developments","varchar(255)","是","否","否","","最新进展"]
["create_by","varchar(255)","是","否","否","",""]
["create_date","datetime","是","否","否","",""]
["update_date","datetime","是","否","否","",""]
["update_by","varchar(255)","是","否","否","",""]
["is_reserve","varchar(255)","是","否","否","","是否上市后备企业 1 是 0 否"]
[]
["mnp_company_subsidy"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["credit_code","varchar(255)","是","否","否","","统一社会信用代码"]
["project_name","varchar(255)","是","否","否","","项目名称"]
["subsidy_month","varchar(255)","是","否","否","","补贴月份"]
["subsidy_money","decimal(20,2)","是","否","否","","补贴金额"]
["import_time","datetime","是","否","否","","导入时间"]
["import_name","varchar(255)","是","否","否","","导入人"]
["is_correct","varchar(255)","是","否","否","","是否匹配 1 匹配 0 不匹配"]
[]
["mnp_company_tag"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
["tag_id","varchar(255)","是","否","否","","企业标签id"]
["effective_date","varchar(255)","是","否","否","","标签效期"]
[]
["mnp_company_tag_record(标签导入历史详情)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["credit_code","varchar(255)","是","否","否","","统一社会信用代码"]
["record_id","varchar(255)","是","否","否","","导入历史id"]
[]
["mnp_device"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["LPMC","varchar(50)","是","否","否","","楼盘名称"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["LCMC","varchar(50)","是","否","否","","楼层名称"]
["LCQYMC","varchar(50)","是","否","否","","楼层区域名称"]
["SBXLH","varchar(50)","是","否","否","","设备序列号"]
["SBMC","varchar(100)","是","否","否","","设备名称"]
["SBLB","varchar(50)","是","否","否","","设备类别"]
["SBZT","varchar(10)","是","否","否","","设备状态"]
["DTKLL","int(11)","是","否","否","","当天客流量"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
[]
["mnp_employee"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["QYID","varchar(50)","是","否","否","","企业ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["XM","varchar(50)","是","否","否","","姓名"]
["XB","varchar(1)","是","否","否","","性别"]
["SJHM","varchar(11)","是","否","否","","手机号码"]
["MJLX","varchar(20)","是","否","否","","门禁类型可多选1身份证、2人脸识别、3IC卡"]
["SFZMHM","varchar(18)","是","否","否","","身份证号"]
["RLZP","varchar(1000)","是","否","否","","人脸照片，存储frame_data的id使用#分隔"]
["ICCARDNO","varchar(18)","是","否","否","","IC卡号"]
["RZRQ","date","是","否","否","","入职日期"]
["LZRQ","date","是","否","否","","离职日期"]
["ZW","varchar(50)","是","否","否","","职位"]
["XL","varchar(50)","是","否","否","","学历"]
["JTZZ","varchar(50)","是","否","否","","家庭住址"]
["JJLXR","varchar(50)","是","否","否","","紧急联系人"]
["JJLXRDH","varchar(11)","是","否","否","","紧急联系人电话"]
["XLZSZP","varchar(1000)","是","否","否","","学历证书，存储frame_data的id使用#分隔"]
["QTZSZP","varchar(1000)","是","否","否","","其他证书，存储frame_data的id使用#分隔"]
["ZT","varchar(10)","是","否","否","","状态"]
["QQSTART","date","是","否","否","","缺勤开始时间"]
["QQEND","date","是","否","否","","缺勤结束时间"]
["LASTJCSJ","datetime","是","否","否","","最后一次进出时间"]
["XFZT","varchar(10)","是","否","否","0","门禁下发状态"]
["XFSBYY","varchar(500)","是","否","否","","下发失败原因"]
[]
["mnp_employee_permission"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["EMPLOYEEID","varchar(50)","是","否","否","","员工ID"]
["LPMC","varchar(50)","是","否","否","","楼盘名称"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["SBXLH","varchar(50)","是","否","否","","设备序列号，有就填，没有可空"]
[]
["mnp_record"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["JLSJ","datetime","是","否","否","","记录时间"]
["JCFX","varchar(1)","是","否","否","","进出方向"]
["QYID","varchar(50)","是","否","否","","企业ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["LDMC","varchar(50)","是","否","否","",""]
["XM","varchar(50)","是","否","否","","姓名"]
["XB","varchar(1)","是","否","否","","性别"]
["RYLX","varchar(10)","是","否","否","","人员类型,企业员工、访客、未登记人员"]
["SJHM","varchar(11)","是","否","否","","手机号码"]
["SFID","varchar(50)","是","否","否","","身份ID"]
["SBXLH","varchar(50)","是","否","否","","设备序列号"]
["SBMC","varchar(100)","是","否","否","","设备名称"]
["SFYC","varchar(1)","是","否","否","","是否异常"]
["YCLX","varchar(10)","是","否","否","","异常类型，体温异常、途径中风险"]
["TWXX","varchar(50)","是","否","否","","体温信息，正常、异常"]
["JKMXX","varchar(50)","是","否","否","","健康码信息，绿码、黄码、红码、暂无用处、其他"]
["HSXX","varchar(50)","是","否","否","","核酸信息，未查询到核酸检测结果；核酸检测阴性；核酸检测阳性；核酸检测有效期已过"]
["XCMXX","varchar(50)","是","否","否","","行程码信息，途径低风险 、 中风险 、高风险 、其他"]
["SFJZYM","varchar(50)","是","否","否","","是否接种疫苗，是/第3针"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
[]
["mnp_sms_send"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键"]
["SJHM","varchar(20)","是","否","否","","手机号码"]
["YZM","varchar(10)","是","否","否","","验证码"]
["FSSJ","datetime","是","否","否","","发送时间"]
["ZT","varchar(10)","是","否","否","","是否验证，0未验证，1已验证"]
[]
["mnp_tag"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["name","varchar(255)","是","否","否","","标签类别名称"]
["is_show","char(1)","是","否","否","","是否对企业可见"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_id","varchar(255)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["mnp_tag_history(标签操作历史)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["update_at","datetime","是","否","否","","更新时间"]
["tag_name","varchar(255)","是","否","否","","标签名称"]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
[]
["mnp_tag_info(标签详情)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["tag_category","varchar(255)","是","否","否","","标签类别"]
["tag_category_id","varchar(255)","是","否","否","","标签类别id"]
["tag_name","varchar(255)","是","否","否","","标签名称"]
["remark","varchar(255)","是","否","否","","标签说明"]
["is_effective","char(1)","是","否","否","","有无有效期"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_id","varchar(255)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["mnp_tag_record(标签导入历史)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["tag_id","varchar(255)","是","否","否","","标签详情id"]
["import_time","datetime","是","否","否","","标签导入时间"]
["effective_date","varchar(255)","是","否","否","","本次导入的标签效期"]
[]
["mnp_visit"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["QYID","varchar(50)","是","否","否","","企业ID"]
["QYMC","varchar(100)","是","否","否","","拜访对象企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["XM","varchar(50)","是","否","否","","姓名"]
["SFZMHM","varchar(18)","是","否","否","","身份证号"]
["SJHM","varchar(11)","是","否","否","","手机号码"]
["LFSY","varchar(200)","是","否","否","","来访事由"]
["BFSJ","datetime","是","否","否","","拜访时间"]
["YXSX","varchar(10)","是","否","否","","有效时限"]
["ZT","varchar(10)","是","否","否","","状态，0待审核，1已通过，2已退回"]
["THYY","varchar(200)","是","否","否","","退回原因"]
["GXRID","varchar(50)","是","否","否","","更新人ID(审核人)"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","CURRENT_TIMESTAMP","更新时间"]
["XCMZP","varchar(1000)","是","否","否","","行程码照片，存储frame_data的id使用#分隔"]
["RLZP","varchar(1000)","是","否","否","","人脸照片，存储frame_data的id使用#分隔"]
["CREATETIME","datetime","是","否","否","CURRENT_TIMESTAMP","申请创建时间"]
["ISVISITED","varchar(3)","是","否","否","","是否到访null未到访,1已到访"]
["DFSJ","datetime","是","否","否","","到访时间"]
["OPENID","varchar(128)","是","否","否","","微信的open_id存放值"]
[]
["mnp_warn"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["ID","varchar(50)","否","是","否","","主键ID"]
["YJSJ","datetime","是","否","否","","预警时间"]
["YJBH","varchar(20)","是","否","否","","预警编号"]
["YCLX","varchar(10)","是","否","否","","异常类型，疑似已离职等等"]
["QYID","varchar(50)","是","否","否","","企业ID"]
["QYMC","varchar(100)","是","否","否","","企业名称"]
["SHXYDM","varchar(50)","是","否","否","","社会信用代码"]
["LDMC","varchar(50)","是","否","否","","楼栋名称"]
["XM","varchar(50)","是","否","否","","姓名"]
["SFZMHM","varchar(18)","是","否","否","","身份证明号码"]
["SJHM","varchar(11)","是","否","否","","手机号码"]
["SFID","varchar(50)","是","否","否","","身份ID"]
["JCSJ","datetime","是","否","否","","最后一次进出时间"]
["YCYY","varchar(50)","是","否","否","","异常原因"]
["QYSFQR","varchar(50)","是","否","否","","企业是否确认，0未确认，1确认已离职，2确认未离职"]
["GXRID","varchar(50)","是","否","否","","更新人ID"]
["GXR","varchar(50)","是","否","否","","更新人"]
["GXSJ","datetime","是","否","否","","更新时间"]
["QQYY","varchar(50)","是","否","否","","缺勤原因"]
["QQSTART","date","是","否","否","","缺勤开始时间"]
["QQEND","date","是","否","否","","缺勤结束时间"]
[]
["oa_supplier(供应商信息)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["supplier_name","varchar(255)","是","否","否","","供应商名称"]
["supplier_code","varchar(255)","是","否","否","","统一社会信用代码"]
["enterprise_type","varchar(255)","是","否","否","","企业类型（字典enterprise_type）"]
["is_head","varchar(10)","是","否","否","","是否总部（0是1否）"]
["is_in_out","varchar(10)","是","否","否","","是否进出口（0是1否）"]
["is_foreign","varchar(10)","是","否","否","","是否外资"]
["supplier_industry","varchar(255)","是","否","否","","行业分类（字典Industry）"]
["dept_id","varchar(100)","是","否","否","","涉及部门id"]
["supplier_file","text","是","否","否","","供应商附件"]
["registered_capital","decimal(18,6)","是","否","否","","注册资金"]
["registered_time","datetime","是","否","否","","注册时间"]
["business_scope","text","是","否","否","","产品/服务内容（经营范围）"]
["contact_user","varchar(255)","是","否","否","","联系人"]
["contact_mobile","varchar(255)","是","否","否","","手机号"]
["contact_phone","varchar(255)","是","否","否","","固定电话"]
["contact_fax","varchar(255)","是","否","否","","传真号"]
["contact_email","varchar(255)","是","否","否","","邮箱"]
["contact_wechat","varchar(255)","是","否","否","","微信号"]
["supplier_address","varchar(255)","是","否","否","","供应商地址"]
["supplier_status","varchar(10)","是","否","否","","供应商状态（0启用1禁用）"]
["create_user","varchar(100)","是","否","否","","创建人"]
["create_time","datetime","是","否","否","","创建时间"]
["update_user","varchar(100)","是","否","否","","更新人"]
["update_time","datetime","是","否","否","","更新时间"]
["group_id","varchar(100)","是","否","否","","集团id"]
[]
["ops_server"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["server_ip","varchar(50)","否","否","否","",""]
["server_name","varchar(255)","是","否","否","",""]
["serial_num","varchar(255)","是","否","否","","特征码"]
["app_id","varchar(50)","是","否","否","",""]
["app_secret","varchar(50)","是","否","否","",""]
["status","varchar(10)","是","否","否","","当前状态"]
["curr_cpu","varchar(100)","是","否","否","",""]
["curr_memory","varchar(100)","是","否","否","",""]
["last_report_at","datetime","是","否","否","","最新上报时间"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["ops_server_backup"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["server_id","varchar(50)","否","否","否","",""]
["serial_num","varchar(50)","是","否","否","",""]
["backup_type","varchar(20)","是","否","否","","DB数据库"]
["file_id","varchar(50)","是","否","否","","备份的文件id"]
["backup_name","varchar(255)","是","否","否","","备份名"]
["created_at","datetime","是","否","否","",""]
[]
["ops_server_record"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["server_id","varchar(50)","否","否","否","",""]
["serial_num","varchar(50)","是","否","否","",""]
["cpu","varchar(100)","是","否","否","",""]
["memory","varchar(100)","是","否","否","",""]
["capacity","varchar(100)","是","否","否","",""]
["jvm","varchar(100)","是","否","否","",""]
["others","text","是","否","否","",""]
["type","varchar(10)","是","否","否","","记录类型"]
["created_at","datetime","是","否","否","",""]
[]
["out_order_main(外包采购单)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["pro_id","varchar(50)","是","否","否","","项目ID"]
["pro_name","varchar(255)","是","否","否","","项目名称"]
["cust_name","varchar(255)","是","否","否","","客户名称"]
["status","varchar(1)","是","否","否","0","订单状态，0待支付，1部分支付，2已支付"]
["biz_id","varchar(50)","是","否","否","","外采团队ID"]
["biz_name","varchar(255)","是","否","否","",""]
["biz_by","varchar(50)","是","否","否","","外包联系人"]
["order_no","varchar(50)","是","否","否","","采购单号"]
["deal_at","datetime","是","否","否","","发包时间"]
["out_timeline","datetime","是","否","否","","要求完成时间"]
["delivery_at","datetime","是","否","否","","交付时间"]
["trans_at","datetime","是","否","否","","移交时间"]
["order_amount","double","是","否","否","","订单总金额"]
["tax_rate","double","是","否","否","","税率"]
["pid_amount","double","是","否","否","","已付款"]
["should_amount","double","是","否","否","","应付款"]
["pay_type","varchar(255)","是","否","否","","支付方式"]
["deal_by","varchar(50)","是","否","否","","发包人"]
["created_at","datetime","是","否","否","","创建时间"]
["created_by","varchar(50)","是","否","否","","创建人"]
["updated_by","varchar(50)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["first","varchar(255)","是","否","否","","备用字段"]
["second","varchar(255)","是","否","否","","备用字段"]
["remark","varchar(255)","是","否","否","","备注"]
["source","varchar(255)","是","否","否","","来源"]
["group_id","varchar(50)","是","否","否","","集团ID"]
["supplier_id","varchar(100)","是","否","否","","供应商id"]
["amount_belong","varchar(100)","是","否","否","","费用、成本归属"]
["amount_belong_type","varchar(100)","是","否","否","","费用、成本归属类型"]
[]
["out_order_pay(支付明细)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["out_order_main_id","varchar(50)","是","否","否","","采购单ID"]
["pay_detail_type","varchar(255)","是","否","否","","支付方式"]
["pay_at","datetime","是","否","否","","付款日期"]
["pay_name","varchar(255)","是","否","否","","付款名称"]
["pay_amount","double","是","否","否","","付款金额"]
["invoice_amount","double","是","否","否","","发票金额"]
["rate","double","是","否","否","","税率"]
["invoice_no","varchar(255)","是","否","否","","发票号"]
["apply_time","datetime","是","否","否","","申请时间"]
["apply_by","varchar(50)","是","否","否","","申请人"]
["created_at","datetime","是","否","否","","创建时间"]
["created_by","varchar(50)","是","否","否","","创建人"]
["updated_by","varchar(50)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["group_id","varchar(50)","是","否","否","","集团ID"]
[]
["park_activity_info(活动管理表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["group_id","varchar(50)","是","否","否","","园区id"]
["activity_name","varchar(255)","是","否","否","","活动名称"]
["activity_type","varchar(255)","是","否","否","","活动类型"]
["activity_annex","text","是","否","否","","主题图"]
["activity_status","varchar(10)","是","否","否","","活动状态"]
["contact_phone","varchar(20)","是","否","否","","联系电话"]
["partake_number","int(10)","是","否","否","","参与人数"]
["sign_in_number","int(10)","是","否","否","","签到人数"]
["activity_hold","varchar(255)","是","否","否","","活动举办"]
["activity_content","text","是","否","否","","活动内容"]
["activity_start_time","datetime","是","否","否","","活动开始时间"]
["activity_end_time","datetime","是","否","否","","活动结束时间"]
["activity_address","varchar(255)","是","否","否","","活动地址"]
["registration_conditions","varchar(255)","是","否","否","","报名条件"]
["registration_start_time","datetime","是","否","否","","报名开始时间"]
["registration_end_time","datetime","是","否","否","","报名结束时间"]
["registration_status","varchar(255)","是","否","否","","报名状态"]
["activity_quota","int(10)","是","否","否","","活动名额"]
["publish_date","datetime","是","否","否","","发布日期"]
["publish_status","varchar(50)","是","否","否","","发布状态"]
["style_status","varchar(255)","是","否","否","","风采发布状态"]
["style_content","text","是","否","否","","风采内容"]
["created_by","varchar(255)","是","否","否","","创建者"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新者"]
["updated_at","datetime","是","否","否","","更新时间"]
["limit_group_ids","varchar(255)","是","否","否","","限制园区"]
["limit_person_number","varchar(255)","是","否","否","","限制人数"]
["activity_template_id","varchar(255)","是","否","否","","活动模板id"]
["activity_file","text","是","否","否","","活动附件"]
[]
["park_activity_notice(物业管理通知公告表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["checked","varchar(255)","是","否","否","","选择类型1全部公司,2全部公司和个人(未来会作废用下面的)"]
["is_all_company","tinyint(1)","是","否","否","","是否全部公司"]
["is_all_person","tinyint(1)","是","否","否","","是否全部个人（非企业用户）"]
["publish_user","varchar(255)","是","否","否","","发布人"]
["publish_date","datetime","是","否","否","","发布日期"]
["publish_status","varchar(255)","是","否","否","","发布状态（0待发布、1已发布、2已撤回）"]
["notice_title","varchar(255)","是","否","否","","标题"]
["notice_content","text","是","否","否","","内容"]
["notice_file_id","text","是","否","否","","附件(json)"]
["create_user","varchar(255)","是","否","否","","创建人id"]
["create_time","datetime","是","否","否","","创建时间"]
["update_user","varchar(255)","是","否","否","","修改人id"]
["update_time","datetime","是","否","否","","修改时间"]
["group_id","varchar(255)","是","否","否","","集团id"]
[]
["park_activity_notice_company(物业管理通知公告通知企业表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["activity_notice_id","varchar(255)","是","否","否","","通知公告id"]
["company_id","varchar(255)","是","否","否","","企业id"]
["read_status","varchar(255)","是","否","否","","状态（0未阅 1已阅）"]
["create_user","varchar(255)","是","否","否","","创建人id"]
["create_time","datetime","是","否","否","","创建时间"]
[]
["park_activity_notice_user(物业管理通知公告通知用户表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["activity_notice_id","varchar(255)","是","否","否","","通知公告id"]
["company_id","varchar(255)","是","否","否","","企业id"]
["wx_user_id","varchar(64)","是","否","否","","手机用户id"]
["read_status","varchar(255)","是","否","否","","状态（0未阅 1已阅）"]
["create_user","varchar(255)","是","否","否","","创建人id"]
["create_time","datetime","是","否","否","","创建时间"]
[]
["park_activity_template(活动模板)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["template_name","varchar(255)","是","否","否","","模板名称"]
["theme_pic_id","varchar(255)","是","否","否","","主题图片id"]
["created_by","varchar(255)","是","否","否","","创建者"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新者"]
["updated_at","datetime","是","否","否","","更新时间"]
["group_id","varchar(50)","是","否","否","","园区id"]
[]
["park_brief(园区简介)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["group_id","varchar(20)","是","否","否","","园区ID"]
["content","longtext","是","否","否","","内容"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_at","datetime","是","否","否","","修改时间"]
["brief_img","varchar(255)","是","否","否","","主题图"]
["attract_phone","varchar(255)","是","否","否","","招商电话"]
["operate_phone","varchar(255)","是","否","否","","运营支持电话"]
["environment_img","text","是","否","否","","园区环境"]
["address","varchar(255)","是","否","否","","园区地址"]
[]
["park_build(楼宇)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["group_id","varchar(20)","是","否","否","",""]
["disc_id","varchar(20)","是","否","否","",""]
["build_no","varchar(255)","是","否","否","",""]
["type","varchar(255)","是","否","否","",""]
["size","varchar(255)","是","否","否","",""]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["lon","varchar(255)","是","否","否","","精度"]
["lat","varchar(255)","是","否","否","","维度"]
["region","varchar(255)","是","否","否","","区域"]
["floor","varchar(255)","是","否","否","","楼层"]
["\r\nintroduction","text","是","否","否","",""]
[]
["park_company_bill(企业账单)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_id","varchar(50)","是","否","否","","公司"]
["type","varchar(50)","是","否","否","","账单类型（1租赁，2物业费，3水电费）"]
["group_id","varchar(50)","是","否","否","","园区"]
["amount","decimal(11,2)","是","否","否","","账单总金额"]
["payment","decimal(11,2)","是","否","否","","已支付金额"]
["expiration_time","datetime","是","否","否","","到期时间"]
["expiration_date","date","是","否","否","","到期日期"]
["status","varchar(50)","是","否","否","","状态（1待缴费，2已缴费，3缴费中）"]
["month","varchar(50)","是","否","否","","账单月份"]
["company_name","varchar(255)","是","否","否","","企业名称"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["contract_id","varchar(50)","是","否","否","","合同ID"]
["default_amount","decimal(11,2)","是","否","否","","违约金"]
["late_fee","decimal(11,2)","是","否","否","","滞纳金"]
["receivable_amount","decimal(11,2)","是","否","否","","应收金额"]
["adjustment_amount","decimal(11,2)","是","否","否","","调整金额"]
["adjustment_reason","varchar(255)","是","否","否","","调整原因"]
["adjustment_date","datetime","是","否","否","","调整日期"]
["adjustment_user_id","varchar(50)","是","否","否","","调整人"]
["bill_date","varchar(50)","是","否","否","","账单日期"]
["adjustment_explain","varchar(255)","是","否","否","","调整说明"]
["adjustment_after","decimal(11,2)","是","否","否","","调整后应收金额"]
[]
["park_company_bill_detail(账单详情)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_bill_id","varchar(50)","是","否","否","",""]
["cost_name","varchar(255)","是","否","否","","明细名称"]
["cost_amount","decimal(11,2)","是","否","否","","明细费用"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
[]
["park_company_bill_invoice(账单发票)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_bill_ids","varchar(255)","是","否","否","","企业账单Id"]
["total_amount","decimal(11,2)","是","否","否","","申请金额"]
["invoice_type","varchar(50)","是","否","否","","开票类型（1普通电子发票 2普通纸质发票 3增税专用发票）"]
["email","varchar(255)","是","否","否","","电子邮箱"]
["invoice_info","varchar(255)","是","否","否","","开票信息"]
["applicant_user_id","varchar(255)","是","否","否","","申请人"]
["applicant_date","date","是","否","否","","申请日期"]
["status","varchar(50)","是","否","否","","开票状态（1待开票，2已开票）"]
["applicant_no","varchar(255)","是","否","否","","申请单号"]
["group_id","varchar(50)","是","否","否","","园区"]
["bill_type","varchar(255)","是","否","否","","账单类型（1租赁，2物业费，3水电费）"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["company_id","varchar(50)","是","否","否","","公司Id"]
["billing_date","datetime","是","否","否","","开票日期"]
["billing_amount","decimal(11,2)","是","否","否","","开票金额"]
["invoice_no","varchar(255)","是","否","否","","发票号"]
["discription","varchar(255)","是","否","否","","说明"]
["handler_person","varchar(255)","是","否","否","","经办人"]
[]
["park_company_bill_pay"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_bill_id","varchar(50)","是","否","否","",""]
["pay_type","varchar(50)","是","否","否","","支付方式（1微信支付，2电汇）"]
["pay_person","varchar(255)","是","否","否","","支付人名称"]
["file_url","varchar(255)","是","否","否","","支付凭证"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["pay_amount","decimal(11,2)","是","否","否","","支付金额"]
["write_off_status","varchar(255)","是","否","否","","核销状态(1未核销 2 已核销)"]
["write_off_result","varchar(255)","是","否","否","","核销结果（1未到账 2已到账）"]
["write_off_time","datetime","是","否","否","","核销时间"]
["write_off_person","varchar(255)","是","否","否","","核销人"]
["pay_time","datetime","是","否","否","","缴费日期"]
["bill_type","varchar(255)","是","否","否","","账单类型（1租赁，2物业费，3水电费）"]
["order_no","varchar(255)","是","否","否","","订单编号"]
["transaction_id","varchar(255)","是","否","否","","微信支付订单号"]
["status","varchar(255)","是","否","否","","支付状态 0待支付 2支付成功 1支付失败"]
[]
["park_company_energy_bill(企业能耗账单)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_id","varchar(50)","是","否","否","","公司"]
["company_name","varchar(255)","是","否","否","","公司名称"]
["type","varchar(50)","是","否","否","","账单类型（1租赁，2物业费，3水电费 //）"]
["building","varchar(255)","是","否","否","","所在楼栋"]
["energy_type","varchar(50)","是","否","否","","能耗类型(1电费，2水费)"]
["month","varchar(50)","是","否","否","","账单归属"]
["bill_date","varchar(50)","是","否","否","","账单日期"]
["group_id","varchar(50)","是","否","否","","园区"]
["number","int(11)","是","否","否","","数量"]
["unit","varchar(50)","是","否","否","","单位"]
["unit_price","decimal(11,2)","是","否","否","","单价"]
["receivable_amount","decimal(11,2)","是","否","否","","应收金额"]
["expiration_time","datetime","是","否","否","","到期时间"]
["expiration_date","date","是","否","否","","到期日期"]
["import_time","datetime","是","否","否","","导入时间"]
["import_person","varchar(64)","是","否","否","","导入人"]
["created_by","varchar(64)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["company_bill_id","varchar(50)","是","否","否","","账单ID"]
[]
["park_company_propaganda(企业宣传)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["company_name","varchar(255)","是","否","否","","企业名称"]
["park","varchar(255)","是","否","否","","面向园区"]
["content","longtext","是","否","否","","内容"]
["publisher_user_id","varchar(255)","是","否","否","","发布人"]
["release_time","datetime","是","否","否","","发布时间"]
["logo","varchar(255)","是","否","否","","企业LOGO"]
["status","varchar(255)","是","否","否","","状态"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["company_id","varchar(50)","是","否","否","","公司ID"]
["introduction","varchar(255)","是","否","否","","简介"]
["company_type","varchar(255)","是","否","否","","企业类型"]
["build_id","varchar(255)","是","否","否","","所在楼栋(目前没有用)"]
[]
["park_contract_manage(合同管理表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["project_id","varchar(255)","是","否","否","","项目id"]
["project_name","varchar(255)","是","否","否","","项目名称"]
["enterprise_id","varchar(20)","是","否","否","","企业ID"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["examine_id","varchar(255)","是","否","否","","企业审核id"]
["credit_code","varchar(255)","是","否","否","","企业信用代码"]
["party_c","varchar(255)","是","否","否","","丙方"]
["contract_no","varchar(255)","是","否","否","","合同编号"]
["contract_no_lease","varchar(255)","是","否","否","","母合同编号租赁"]
["contract_no_property","varchar(255)","是","否","否","","母合同编号物业"]
["estate_building_room_no","text","是","否","否","","楼盘/楼栋/房间号"]
["contract_type","varchar(255)","是","否","否","","合同类型（租赁合同）"]
["template_type","varchar(255)","是","否","否","","模板类型（租赁模板A、租赁模板B）"]
["area","varchar(255)","是","否","否","","合同面积"]
["pay_type","varchar(255)","是","否","否","","缴费方式"]
["start_date","datetime","是","否","否","","合同日期起"]
["end_date","datetime","是","否","否","","合同日期止"]
["retreat_date","datetime","是","否","否","","退租结算日期"]
["limit_date","int(11)","是","否","否","","合同租期（天）"]
["limit_month","double(10,2)","是","否","否","","合同租期（月）"]
["preparation_period","varchar(255)","是","否","否","","筹备期"]
["signing_date","datetime","是","否","否","","签约日期"]
["signing_name","varchar(255)","是","否","否","","签约人"]
["remark","varchar(255)","是","否","否","","备注"]
["price","decimal(20,2)","是","否","否","","租金单价"]
["month_price","decimal(20,2)","是","否","否","","月租金"]
["lease_cycle","double(10,2)","是","否","否","","租赁周期"]
["total_rent","decimal(20,4)","是","否","否","","总租金额（万元）"]
["first_rent","decimal(20,2)","是","否","否","","第一期租金"]
["property_management_fee_price","decimal(20,2)","是","否","否","","物业费单价"]
["monthly_property_management_fee","decimal(20,2)","是","否","否","","月物业管理费（元）"]
["property_cycle","varchar(255)","是","否","否","","物业周期"]
["total_property_cost","decimal(20,4)","是","否","否","","总物业费金额（万元）"]
["bond","decimal(10,2)","是","否","否","","保证金"]
["first_property_management_fee","decimal(10,2)","是","否","否","","第一期物业费"]
["settlement_payment","decimal(10,2)","是","否","否","","入驻款"]
["settlement_payment_deadline","datetime","是","否","否","","入驻款截止日期"]
["contract_status","varchar(255)","是","否","否","","合同状态"]
["settle_in_status","varchar(255)","是","否","否","","入驻状态"]
["bond_status","varchar(255)","是","否","否","","保证金状态"]
["contract_original","text","是","否","否","","合同原件"]
["contract_other","text","是","否","否","","其他附件"]
["project_signing_materials","text","是","否","否","","签约资料"]
["is_renewal","char(1)","是","否","否","","是否为续签合同 (1是 0否)"]
["renewal_type","char(1)","是","否","否","","续签类型（1 不变更载体 2 变更载体）"]
["is_renting_out","char(1)","是","否","否","","是否退租 （1 已退租 0 未退租）"]
["is_wait_read","char(1)","是","否","否","","是否已推送待阅（针对合同到期）1 已推送 0 未推送"]
["is_send","char(1)","是","否","否","0","是否已发送到期提醒短信（1 已发送 0 未发送）"]
["send_type","varchar(10)","是","否","否","","短信发送类型（1 企业法人 2 企业联系人）逗号分隔"]
["enterprise_legal_person","varchar(255)","是","否","否","","企业法人 姓名/手机号"]
["enterprise_contact_person","varchar(255)","是","否","否","","企业联系人 姓名手机号"]
["old_contract_id","varchar(255)","是","否","否","","原合同id"]
["contract_template_path","varchar(2550)","是","否","否","","生成的租赁合同路径"]
["property_template_path","varchar(2550)","是","否","否","","生成的物业合同路径"]
["data_source","varchar(255)","是","否","否","","数据来源"]
["created_by","varchar(255)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
[]
["park_economy_report_info(经发记录)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","","主键"]
["year","varchar(6)","是","否","否","","年份"]
["month","varchar(6)","是","否","否","","月份"]
["business_income","varchar(255)","是","否","否","","营业收入（W）"]
["tax_revenue","varchar(255)","是","否","否","","税收收入（W）"]
["investment","varchar(255)","是","否","否","","投融资金额"]
["staff_number","int(11)","是","否","否","","员工总人数"]
["undergraduate_number","int(11)","是","否","否","","本科以上人数"]
["is_save","varchar(20)","是","否","否","","是否为保存"]
["enterprise_id","varchar(20)","是","否","否","","所属企业ID"]
["group_id","varchar(20)","是","否","否","","所属园区"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["park_enterprise_relation(企业园区关联)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["enterprise_id","varchar(255)","是","否","否","","企业id"]
["group_id","varchar(255)","是","否","否","","园区id"]
["created_at","datetime","是","否","否","",""]
[]
["park_feedback_info(系统反馈表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["group_id","varchar(50)","是","否","否","","园区id"]
["feedback_type","varchar(50)","是","否","否","","反馈类型"]
["feedback_content","varchar(2000)","是","否","否","","反馈内容"]
["feedback_id","varchar(50)","是","否","否","","反馈人id"]
["feedback_name","varchar(255)","是","否","否","","反馈人"]
["feedback_time","datetime","是","否","否","","反馈时间"]
["status","varchar(10)","是","否","否","","状态"]
["receive_id","varchar(50)","是","否","否","","受理人id"]
["receive_time","datetime","是","否","否","","受理时间"]
["reply_content","varchar(2000)","是","否","否","","回复内容"]
["created_by","varchar(255)","是","否","否","","创建者id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新者id"]
["updated_at","datetime","是","否","否","","更新时间"]
[]
["park_fill_import_task(填报导入任务)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["belong_date","varchar(100)","是","否","否","","任务月份"]
["task_id","varchar(100)","是","否","否","","任务id"]
["tem_id","varchar(100)","是","否","否","","模板id"]
["operate_id","varchar(100)","是","否","否","","操作人"]
["operate_name","varchar(255)","是","否","否","","操作人名称"]
["operate_time","datetime","是","否","否","","操作时间"]
["operate_num","int(11)","是","否","否","","数据量"]
["states","varchar(10)","是","否","否","","状态(0=未导,1=已导)"]
["files","varchar(255)","是","否","否","","导入文件ids"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_fill_info(填报信息)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["group_id","varchar(100)","是","否","否","","园区id"]
["tem_id","varchar(100)","是","否","否","","模板id"]
["task_id","varchar(100)","是","否","否","","任务id"]
["enter_id","varchar(100)","是","否","否","","企业id"]
["fill_type","varchar(10)","是","否","否","","填报类型(0=企,1=管,2=导)"]
["belong_date","varchar(100)","是","否","否","","归属月份"]
["options","varchar(255)","是","否","否","","填报项目"]
["content","varchar(255)","是","否","否","","填报内容"]
["fill_user_id","varchar(100)","是","否","否","","填报人id"]
["fill_user_type","varchar(255)","是","否","否","","填报人类型(0=企,1=管)"]
["fill_user_name","varchar(255)","是","否","否","","填报人名称"]
["fill_time","datetime","是","否","否","","填报时间"]
["require_finish_time","datetime","是","否","否","","要求完成时间"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
["revenue","double(11,2)","是","否","否","","营业收入"]
["taxation","double(11,2)","是","否","否","","税收收入"]
["property","double(11,2)","是","否","否","","拥有知识产权"]
["practice","double(11,2)","是","否","否","","从业人数"]
["output","double(11,2)","是","否","否","","产值"]
["profit","double(11,2)","是","否","否","","利润"]
["electricity","double(11,2)","是","否","否","","用电量(改成吞吐量(吨))"]
["save_type","varchar(10)","是","否","否","","保存类型(0=已填，1=未填)"]
[]
["park_fill_task(预填报任务)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["task_no","varchar(100)","是","否","否","","任务编号"]
["tem_id","varchar(255)","是","否","否","","填报模板id"]
["refer","varchar(255)","是","否","否","","推送对象描述"]
["receive_ids","varchar(500)","是","否","否","","推送企业ids"]
["belong_date","varchar(100)","是","否","否","","归属年月份"]
["require_finish_time","datetime","是","否","否","","要求完成时间"]
["push_num","int(11)","是","否","否","","推送企业数"]
["finish_num","int(11)","是","否","否","","填报企业数"]
["unfinish_num","int(11)","是","否","否","","未填报企业数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(100)","是","否","否","","创建人"]
[]
["park_fill_template(预填报模板)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["tem_name","varchar(255)","是","否","否","","模板名称"]
["tem_reserve","varchar(255)","是","否","否","","模板预留字段"]
["options","varchar(255)","是","否","否","","填报选项"]
["play_num","int(11)","是","否","否","","引用次数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_floor_disc(楼盘)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["name","varchar(255)","是","否","否","",""]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["group_id","varchar(255)","是","否","否","",""]
[]
["park_floor_role_user(楼栋用户角色绑定)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","","主键"]
["floor_id","varchar(20)","是","否","否","","楼盘id"]
["user_id","varchar(20)","是","否","否","","用户id"]
["role_id","varchar(20)","是","否","否","","角色id"]
["group_id","varchar(20)","是","否","否","","园区id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_at","datetime","是","否","否","",""]
[]
["park_info(园区信息)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(255)","否","是","否","",""]
["group_id","varchar(255)","是","否","否","",""]
["park_type","varchar(255)","是","否","否","",""]
["size","varchar(255)","是","否","否","",""]
["address","varchar(255)","是","否","否","",""]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["group_name","varchar(255)","是","否","否","",""]
["introduction","text","是","否","否","",""]
[]
["park_meeting_appoint_info(会议室预约记录)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["appointTime","datetime","是","否","否","","预约时间"]
["subject","varchar(255)","是","否","否","","会议主题"]
["meeting_room_id","varchar(20)","是","否","否","","会议室id"]
["enterprise_id","varchar(20)","是","否","否","","企业id"]
["use_time","datetime","是","否","否","","使用时间"]
["time_slot","varchar(255)","是","否","否","","使用时段"]
["people_number","varchar(20)","是","否","否","","参会人数"]
["contacts","varchar(255)","是","否","否","","联系人"]
["phone","varchar(255)","是","否","否","","联系电话"]
["remarks","varchar(255)","是","否","否","","备注"]
["state","varchar(255)","是","否","否","","状态(等待审核、等待付费、等待确认、预定成功、已取消)"]
["pay_type","varchar(255)","是","否","否","","支付方式（微信，电汇）"]
["pay_user_name","varchar(255)","是","否","否","","支付人名称"]
["pay_proof","varchar(255)","是","否","否","","支付凭证"]
["cancel_reason","varchar(255)","是","否","否","","取消原因"]
["handler_id","varchar(20)","是","否","否","","经办人"]
["handler_Time","datetime","是","否","否","","经办时间"]
["group_id","varchar(20)","是","否","否","","所属园区"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["examine_id","varchar(20)","是","否","否","","审核人"]
["examine_time","datetime","是","否","否","","审核时间"]
[]
["park_meeting_room_info(会议室)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["room_img","varchar(255)","是","否","否","","会议室图片"]
["room_name","varchar(255)","是","否","否","","会议室名称"]
["seat_number","varchar(20)","是","否","否","","座位数"]
["position","varchar(255)","是","否","否","","位置"]
["match","varchar(255)","是","否","否","","配套"]
["appoint_phone","varchar(255)","是","否","否","","预约电话"]
["charges","varchar(255)","是","否","否","","收费标准"]
["explain","varchar(255)","是","否","否","","说明"]
["state","varchar(255)","是","否","否","","状态"]
["group_id","varchar(20)","是","否","否","","所属园区"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["time_slot","varchar(255)","是","否","否","","开放时间"]
[]
["park_notice(园区通知管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["group_id","varchar(50)","是","否","否","",""]
["title","varchar(255)","是","否","否","","标题"]
["content","text","是","否","否","","具体内容"]
["file_url","text","是","否","否","","附件"]
["parks","varchar(255)","是","否","否","","面向园区"]
["short_message_person","varchar(255)","是","否","否","","短信通知对象"]
["short_message_content","varchar(255)","是","否","否","","短信通知内容"]
["status","varchar(20)","是","否","否","","状态（1待发布，2已发布，3已撤回）"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["release_time","datetime","是","否","否","","发布时间"]
["publisher_user_id","varchar(255)","是","否","否","","发布人"]
["dept_id","varchar(255)","是","否","否","","发布部门"]
["source","varchar(255)","是","否","否","","数据来源（1pc端  2手机端）"]
[]
["park_policy_info(政策管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["is_to_all_co","tinyint(1)","是","否","否","","是否选择全部企业1是0否"]
["industry","varchar(2000)","是","否","否","","对应企业类型,多个用逗号隔开(原来的行业分类作废)"]
["group_id","varchar(50)","是","否","否","",""]
["title","varchar(255)","是","否","否","","标题"]
["policy_big","varchar(255)","是","否","否","","政策大类"]
["policy_small","varchar(255)","是","否","否","","政策小类"]
["content","text","是","否","否","","具体内容"]
["file_url","text","是","否","否","","附件"]
["parks","varchar(255)","是","否","否","","面向园区"]
["short_message_person","varchar(255)","是","否","否","","短信通知对象"]
["short_message_content","varchar(255)","是","否","否","","短信通知内容"]
["status","varchar(20)","是","否","否","","状态（unpublished待发布，published已发布，off_shelf已下架）"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["release_time","datetime","是","否","否","","发布时间"]
["publisher_user_id","varchar(255)","是","否","否","","发布人"]
["type","varchar(255)","是","否","否","","面向企业类型"]
[]
["park_policy_type"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["name","varchar(255)","是","否","否","",""]
["pid","varchar(50)","是","否","否","",""]
["type","varchar(255)","是","否","否","","类型，（大类，小类）"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["code","varchar(255)","是","否","否","",""]
[]
["park_prove_info(企业认证)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","","主键"]
["company_id","varchar(64)","是","否","否","","公司id"]
["currency","int(1)","是","否","否","","币种"]
["zcdz","varchar(500)","是","否","否","","注册地址"]
["settle_in_type","varchar(255)","是","否","否","","入驻类型"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["enterprise_code","varchar(255)","是","否","否","","机构代码"]
["register_amount","varchar(255)","是","否","否","","注册资金（W）"]
["legal_user","varchar(255)","是","否","否","","法定代表人"]
["contacts","varchar(255)","是","否","否","","联系人"]
["phone","varchar(11)","是","否","否","","联系电话"]
["industry","varchar(255)","是","否","否","","所属行业"]
["group_id","varchar(20)","是","否","否","","所在园区修改成数组"]
["apply_time","datetime","是","否","否","","认证申请时间"]
["state","varchar(20)","是","否","否","","审核结果"]
["examine_time","datetime","是","否","否","","审核时间"]
["examine_user_id","varchar(20)","是","否","否","","审核人"]
["enterprise_type","varchar(20)","是","否","否","","企业类型"]
["is_head","varchar(2)","是","否","否","","是否总部"]
["is_imout","varchar(2)","是","否","否","","是否进出口"]
["is_foreign","varchar(2)","是","否","否","","是否外资"]
["registration_code","varchar(20)","是","否","否","","注册标识"]
["manage_address","varchar(255)","是","否","否","","经营地址"]
["social_credit_code","varchar(255)","是","否","否","","统一社会信用代码"]
["register_time","datetime","是","否","否","","注册时间"]
["manage_range","varchar(255)","是","否","否","","经营范围"]
["business_license","varchar(500)","是","否","否","","营业执照"]
["manage_area","varchar(255)","是","否","否","","经营面积(平方米)"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_at","datetime","是","否","否","","修改时间"]
["prove_type","varchar(2)","是","否","否","","企业认证类型(1=认证，2=修改)"]
["is_sava","varchar(2)","是","否","否","","\"待审核\",\"0\"\"审核通过\",\"1\"\"审核未通过\",\"2\""]
[]
["park_recruit_info(招聘记录)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","","主键"]
["position","varchar(255)","是","否","否","","招聘职位"]
["salary","varchar(10)","是","否","否","","薪水待遇"]
["people_number","varchar(20)","是","否","否","","招聘人数"]
["work_require","varchar(2000)","是","否","否","","工作经验要求"]
["recruit_recruit","varchar(2000)","是","否","否","","招聘要求"]
["contacts","varchar(20)","是","否","否","","联系人"]
["phone","varchar(20)","是","否","否","","联系电话"]
["enterprise_id","varchar(20)","是","否","否","","所属企业ID"]
["validity_date","datetime","是","否","否","","有效期"]
["group_id","varchar(20)","是","否","否","","所属园区"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
["state","varchar(255)","是","否","否","","发布状态(保存，1已发布，2已下架)"]
[]
["park_refund_info"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["exit_order_id","varchar(100)","是","否","否","","关联退租单"]
["custom_id","varchar(100)","是","否","否","","企业id"]
["custom_name","varchar(255)","是","否","否","","企业名称"]
["contacts","varchar(255)","是","否","否","","联系人"]
["phone","varchar(255)","是","否","否","","联系电话"]
["need_pay","varchar(255)","是","否","否","","需退企业预缴纳物业费"]
["refund_num","varchar(100)","是","否","否","","实际退款金额"]
["refund_date","datetime","是","否","否","","实际退款日期"]
["remark","varchar(255)","是","否","否","","备注"]
["create_name","varchar(255)","是","否","否","","创建人名称"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_regis_sign_info(报名签到记录表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["group_id","varchar(50)","是","否","否","","园区id"]
["company_name","varchar(255)","是","否","否","","公司名称"]
["participants","varchar(50)","是","否","否","","参与人"]
["participants_position","varchar(50)","是","否","否","","参与人职位"]
["participants_phone","varchar(50)","是","否","否","","联系电话"]
["remark","varchar(255)","是","否","否","","说明"]
["reference_id","varchar(50)","是","否","否","","关联id"]
["reference_type","varchar(50)","是","否","否","","关联类型(1:活动2:培训)"]
["registration_time","datetime","是","否","否","","报名时间"]
["sign_in_code","varchar(255)","是","否","否","","签到码"]
["sign_in_status","varchar(255)","是","否","否","","签到状态(1:未核销2:已核销)"]
["sign_in_time","datetime","是","否","否","","签到时间"]
["created_by","varchar(255)","是","否","否","","创建者"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新者"]
["updated_at","datetime","是","否","否","","更新时间"]
["user_id","varchar(50)","是","否","否","","注册用户id"]
["sign_in_annex","text","是","否","否","","二维码图"]
["participants_number","int(11)","是","否","否","","总参与人数"]
[]
["park_report_repair(报事报修)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["group_id","varchar(50)","是","否","否","",""]
["company_id","varchar(50)","是","否","否","",""]
["company_name","varchar(255)","是","否","否","",""]
["type","varchar(20)","是","否","否","","报事类型 1报事 2咨询"]
["service_type","varchar(20)","是","否","否","","服务类型  挂件安装 我要投诉 更换灯泡"]
["description","varchar(255)","是","否","否","","报修描述"]
["position","varchar(255)","是","否","否","","位置 1室内 2公区"]
["file_url","text","是","否","否","","补充说明 6张图片"]
["user_id","varchar(255)","是","否","否","","报事人"]
["status","varchar(20)","是","否","否","","状态 （1待受理 2已受理 3已处理 4已评价）"]
["dispatch_user_id","varchar(50)","是","否","否","","派单人"]
["dispatch_time","datetime","是","否","否","","派单时间"]
["handle_user_id","varchar(50)","是","否","否","","处理人"]
["handle_time","datetime","是","否","否","","处理时间"]
["score","int(11)","是","否","否","","评分"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["remark","varchar(255)","是","否","否","","备注"]
["handle_url","text","是","否","否","","处理附件"]
["handle_explain","varchar(255)","是","否","否","","处理说明"]
["evaluate_num","int(11)","是","否","否","","评价人数"]
[]
["park_room(园区房间)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["build_id","varchar(20)","是","否","否","",""]
["room_no","varchar(255)","是","否","否","","房号"]
["img_no","varchar(255)","是","否","否","","平面图房号"]
["size","varchar(255)","是","否","否","","面积"]
["direction","varchar(255)","是","否","否","","朝向"]
["state","varchar(255)","是","否","否","","租赁状态"]
["current_state","varchar(255)","是","否","否","","当前状态（招商状态）"]
["group_id","varchar(255)","是","否","否","",""]
["disc_id","varchar(255)","是","否","否","","楼盘id"]
["room_use","char(1)","是","否","否","","用途"]
["guide_price","double(10,2)","是","否","否","","租赁指导价"]
["guide_price_interval_start","double(10,2)","是","否","否","","指导价区间"]
["guide_price_interval_end","double(10,2)","是","否","否","","指导价区间"]
["property_nature","char(1)","是","否","否","","物业性质"]
["decoration_situation","text","是","否","否","","装修情况"]
["remark","text","是","否","否","","备注"]
["is_enable","char(1)","是","否","否","","当前可用状态 1 可用 2 禁用"]
["plan_picture","varchar(255)","是","否","否","","房型图（存储frame_date的id）"]
["environment_picture","varchar(255)","是","否","否","","室内外环境（存储frame_date的id）"]
["region","varchar(255)","是","否","否","","区域"]
["floor","varchar(255)","是","否","否","","楼层"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["state_updated_at","datetime","是","否","否","","租赁状态变更时间"]
["is_enable_updated_at","datetime","是","否","否","","可用状态变更时间"]
["is_rented","char(1)","是","否","否","","是否已租"]
["retreat_date","datetime","是","否","否","","退租时间"]
[]
["park_room_handle_user"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","","主键"]
["room_id","varchar(20)","是","否","否","","房间ID"]
["user_id","varchar(20)","是","否","否","","用户id"]
["creation_time","datetime","是","否","否","","创建时间"]
["group_id","varchar(20)","是","否","否","","园区ID"]
[]
["park_room_user_bind"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["group_id","varchar(20)","是","否","否","","园区ID"]
["user_id","varchar(20)","是","否","否","","人员ID"]
["floor_id","varchar(20)","是","否","否","","楼盘id"]
["build_id","varchar(20)","是","否","否","","楼栋Id"]
["room_ids","varchar(255)","是","否","否","","房间ids"]
["created_id","varchar(20)","是","否","否","","创建人"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["park_sequence"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["type","varchar(50)","是","否","否","","类型"]
["date","varchar(50)","是","否","否","","时间"]
["sequence","int(11)","是","否","否","0",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["park_staff_prove_info(员工认证)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["user_id","varchar(20)","是","否","否","","用户ID"]
["biz_id","varchar(20)","是","否","否","","公司ID"]
["creation_time","datetime","是","否","否","","创建时间"]
["handle_user_id","varchar(20)","是","否","否","","审核人"]
["handle_time","datetime","是","否","否","","审核时间"]
["handle_result","int(2)","是","否","否","","审核结果(待审核，审核成功，审核失败)"]
[]
["park_system_msg_info"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键"]
["title","varchar(255)","是","否","否","","标题"]
["content","varchar(500)","是","否","否","","内容"]
["msg_type","varchar(50)","是","否","否","","类型"]
["version_num","varchar(255)","是","否","否","","版本号"]
["state","varchar(255)","是","否","否","","状态"]
["creation_time","datetime","是","否","否","","创建时间"]
["release_time","datetime","是","否","否","","发布时间"]
["group_id","varchar(20)","是","否","否","","园区ID"]
["msg_mold","varchar(255)","是","否","否","","消息类型(1:反馈回复 2:报事报修处理待评价 3:会议室审核完成 4:会议室确认完成 5:路演申请确认 6:内部通知 7:我的达人服务 8：协助达人服务)"]
[]
["park_system_msg_read"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(20)","否","是","否","",""]
["msg_id","varchar(20)","是","否","否","","消息id"]
["user_type","varchar(10)","是","否","否","","用户类型"]
["user_id","varchar(20)","是","否","否","","用户ID"]
["read_time","datetime","是","否","否","","阅读时间"]
[]
["park_train_info(培训管理表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["group_id","varchar(50)","是","否","否","","园区id"]
["publish_date","datetime","是","否","否","","发布日期"]
["publish_status","varchar(50)","是","否","否","","发布状态"]
["train_type","varchar(50)","是","否","否","","培训类别"]
["train_title","varchar(255)","是","否","否","","培训主题"]
["train_start_time","datetime","是","否","否","","培训开始时间"]
["train_end_time","datetime","是","否","否","","培训结束时间"]
["registration_status","varchar(50)","是","否","否","","报名状态"]
["train_address","varchar(500)","是","否","否","","培训地址"]
["partake_number","int(10)","是","否","否","","报名数量(参与人数)"]
["sign_in_number","int(10)","是","否","否","","签到数量"]
["train_hold","varchar(500)","是","否","否","","培训主办方"]
["train_quota","int(10)","是","否","否","","参与人数限制"]
["train_annex","text","是","否","否","","主题图片"]
["lecturer_name","varchar(50)","是","否","否","","讲师姓名"]
["start_time","datetime","是","否","否","","开播开始时间"]
["end_time","datetime","是","否","否","","开播结束时间"]
["train_status","varchar(50)","是","否","否","","培训状态"]
["lecturer_introduction","varchar(2000)","是","否","否","","讲师简介"]
["lecturer_annex","text","是","否","否","","讲师形象照"]
["contact_phone","varchar(255)","是","否","否","","联系电话"]
["train_content","varchar(2000)","是","否","否","","培训内容"]
["registration_conditions","varchar(255)","是","否","否","","报名条件"]
["registration_start_time","datetime","是","否","否","","报名开始时间"]
["registration_end_time","datetime","是","否","否","","报名结束时间"]
["online_offline_status","varchar(50)","是","否","否","","线上线下状态"]
["created_by","varchar(255)","是","否","否","","创建者"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新者"]
["updated_at","datetime","是","否","否","","更新时间"]
["video_annex","text","是","否","否","","视频路径"]
[]
["park_user_collectors(我的收藏表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["user_id","varchar(50)","是","否","否","","用户id"]
["collectors_id","varchar(50)","是","否","否","","收藏活动id"]
["collectors_type","varchar(255)","是","否","否","","收藏类型(1:园区活动2:园区培训3:园区通知4:物业通知5:公告通知)"]
["created_by","varchar(255)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
[]
["park_user_information(我的消息表（小程序）)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["user_id","varchar(50)","是","否","否","","用户id"]
["information_id","varchar(50)","是","否","否","","消息ID"]
["information_type","varchar(255)","是","否","否","","消息类型(1:反馈回复 2:报事报修处理待评价 3:会议室审核完成 4:会议室确认完成 5:路演申请确认 6:内部通知)"]
["information_content","varchar(255)","是","否","否","","消息内容"]
["created_by","varchar(255)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(255)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
["status","varchar(50)","是","否","否","","状态 1 未读 0 已读"]
[]
["park_wait_handle(待办模块)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["handle_type","int(2)","是","否","否","","待办类型(1企业审核,2入驻,3退租，4清退,5开账,6开票,7红冲)"]
["title","varchar(255)","是","否","否","","标题"]
["src_user_id","varchar(200)","是","否","否","","来源人id"]
["src_user_type","int(2)","是","否","否","","来源人类型(0管理,1企业)"]
["src_user_name","varchar(255)","是","否","否","","来源人name"]
["receive_user_id","varchar(200)","是","否","否","","接收人id(0全部)"]
["route_url","varchar(255)","是","否","否","","跳转路由地址"]
["route_param","varchar(255)","是","否","否","","携带参数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_wait_handle_on"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["handle_id","varchar(200)","是","否","否","","待办id"]
["handle_user_id","varchar(200)","是","否","否","","办理人id"]
["handle_time","datetime","是","否","否","","办理时间"]
[]
["park_wait_read"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["read_type","int(11)","是","否","否","","待阅类型(1合同到期,2应收款调整,3风险与提醒,4人员管理,5经发)"]
["title","varchar(255)","是","否","否","","标题"]
["src_user_id","varchar(200)","是","否","否","","来源人id"]
["src_user_type","int(11)","是","否","否","","来源人类型(0管理,1企业)"]
["src_user_name","varchar(255)","是","否","否","","来源人name"]
["receive_user_id","varchar(200)","是","否","否","","接收人id(0全部)"]
["route_url","varchar(255)","是","否","否","","跳转路由地址"]
["route_param","varchar(255)","是","否","否","","携带参数"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
[]
["park_wait_read_on"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["read_id","varchar(200)","是","否","否","","待阅id"]
["read_user_id","varchar(200)","是","否","否","","阅读人id"]
["read_time","datetime","是","否","否","","阅读时间"]
[]
["park_work_trends"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["work_type","varchar(10)","是","否","否","","工作类型"]
["title","varchar(255)","是","否","否","","标题"]
["wcontent","varchar(255)","是","否","否","","内容(预留)"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["park_work_trends_delete20240520"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(200)","否","是","否","","主键"]
["work_type","varchar(10)","是","否","否","","工作类型"]
["title","varchar(255)","是","否","否","","标题"]
["wcontent","varchar(255)","是","否","否","","内容(预留)"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["pro_risk_course(项目风险进度)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["pro_id","varchar(100)","是","否","否","","项目id"]
["pro_name","varchar(255)","是","否","否","","项目名称"]
["risk_id","varchar(100)","是","否","否","","风险id"]
["course_at","date","是","否","否","","进度日期"]
["brief","varchar(255)","是","否","否","","处理说明"]
["handle_by","varchar(255)","是","否","否","","处理人id"]
["handle_name","varchar(255)","是","否","否","","处理人名称"]
["annex","varchar(500)","是","否","否","","附件"]
["state","varchar(255)","是","否","否","","状态(0=处理中,1=已关闭)"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(100)","是","否","否","","创建人"]
["update_at","datetime","是","否","否","","修改时间"]
["update_by","varchar(100)","是","否","否","","修改人"]
["group_id","varchar(100)","是","否","否","","group_id"]
[]
["pro_risk_info(项目风险)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","",""]
["pro_id","varchar(100)","是","否","否","","项目id"]
["pro_name","varchar(255)","是","否","否","","项目名称"]
["title","varchar(255)","是","否","否","","风险标题"]
["rtype","varchar(255)","是","否","否","","风险类别"]
["grade","varchar(100)","是","否","否","","风险等级"]
["content","text","是","否","否","","风险内容说明"]
["annex","varchar(500)","是","否","否","","附件"]
["viewed_by","varchar(800)","是","否","否","","查阅人S"]
["state","varchar(10)","是","否","否","","状态:0=待发布，1=待处理，2=处理中，3=已关闭"]
["push_at","datetime","是","否","否","","发布时间"]
["push_by","varchar(100)","是","否","否","","发布人"]
["close_at","datetime","是","否","否","","关闭时间"]
["created_at","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
["update_at","datetime","是","否","否","","修改时间"]
["update_by","varchar(100)","是","否","否","","修改人"]
["source","varchar(255)","是","否","否","","来源"]
["group_id","varchar(100)","是","否","否","","group_id"]
[]
["rectification_management(文明创建整改管理_管理表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["company_id","varchar(128)","是","否","否","","公司id(没有用到)"]
["company_name","varchar(128)","是","否","否","","物业公司名称(没有用到)"]
["open_user","varchar(128)","是","否","否","","发布人id"]
["open_time","datetime","是","否","否","","发布日期"]
["update_type","varchar(4)","是","否","否","","整改类型(1绿化管养,2环卫作业,3违章建筑(是字典))"]
["info","varchar(2048)","是","否","否","","描述"]
["update_address","varchar(512)","是","否","否","","地址名称(整改地址)"]
["update_address_x","varchar(32)","是","否","否","","地址经度"]
["update_address_y","varchar(32)","是","否","否","","地址纬度"]
["info_more_picture_url","text","是","否","否","","补充说明照片(整改前照片)"]
["need_finish_time","datetime","是","否","否","","要求完成日期"]
["finish_user","varchar(128)","是","否","否","","处理人id"]
["finish_info","varchar(2048)","是","否","否","","处理结果"]
["finish_picture_url","text","是","否","否","","整改后照片"]
["finish_time","datetime","是","否","否","","处理日期(整改日期)"]
["check_time","datetime","是","否","否","","确认时间"]
["finish_type","varchar(4)","是","否","否","","处理状态(1待派单,2待处理,3待确认,4已完成)"]
["finish_state","varchar(4)","是","否","否","","整改确认状态(1完成整改,2整改不到位，重新整改)"]
["recheck_id","varchar(128)","是","否","否","","重新整改对应的最初的表id(新增的整改数据保存最开始的整改数据id)"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["safety_company_info(安全管理模块_企业安全信息库)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["company_id","varchar(128)","是","否","否","","公司id"]
["year_collect","decimal(12,2)","是","否","否","","年销售收入（万元）"]
["safety_user","varchar(255)","是","否","否","","安全管理员"]
["safety_user_phone","varchar(255)","是","否","否","","联系人手机"]
["is_lease","int(4)","是","否","否","","是否租赁企业"]
["leaser_name","varchar(255)","是","否","否","","出租方"]
["safety_department","varchar(255)","是","否","否","","安全管理部门"]
["district","varchar(255)","是","否","否","","所属区（县）"]
["street","varchar(255)","是","否","否","","所属街道（镇）"]
["community","varchar(255)","是","否","否","","所属社区（村）"]
["employees_count","int(11)","是","否","否","","企业员工总数"]
["new_employees_count","int(11)","是","否","否","","两年内新员工数"]
["industry","varchar(255)","是","否","否","","所属行业"]
["industry_code","varchar(255)","是","否","否","","行业代码"]
["industry_type","varchar(255)","是","否","否","","行业类型"]
["registration_type","varchar(255)","是","否","否","","登记注册类型"]
["compliance_level","varchar(255)","是","否","否","","标准化达标等级"]
["compliance_time","datetime","是","否","否","","达标时间"]
["main_products","varchar(2048)","是","否","否","","主要产品"]
["hazardous_equipment","text","是","否","否","","较大危险设备(建立字典)(多个已逗号隔开)"]
["hazardous_equipment_other","varchar(255)","是","否","否","","较大危险设备其他"]
["metal_melting_furnace","text","是","否","否","","金属熔炼炉(建立字典)(多个已逗号隔开)"]
["hazardous_operations","text","是","否","否","","较大危险作业(建立字典)(多个已逗号隔开)"]
["refrigeration_operation","text","是","否","否","","涉氮制冷作业(建立字典)(多个已逗号隔开)"]
["dust_areas_operation","text","是","否","否","","爆炸粉尘场所作业(建立字典)(多个已逗号隔开)"]
["dust_areas_operation_other","varchar(255)","是","否","否","","爆炸粉尘场所作业其他"]
["storage_method","varchar(255)","是","否","否","","储存方式(建立字典)(1仓库,2储罐)"]
["is_hazard_source","tinyint(1)","是","否","否","","是否构成重大危险源"]
["is_hazardous_processes","tinyint(1)","是","否","否","","是否构成重点危险工艺"]
["is_hazardous_chemicals","tinyint(1)","是","否","否","","是否构成重点监管危化品"]
["use_hazardous_chemicals","text","是","否","否","","使用危化品情况(建立字典)(多个已逗号隔开)"]
["hazard_less3tons_count","int(11)","是","否","否","","3吨以下(多少台)"]
["hazard_over3tons_count","int(11)","是","否","否","","3吨以上(多少台)"]
["hazard_other_count","varchar(255)","是","否","否","","使用危化品情况其它"]
["electrician_work","int(11)","是","否","否","","电工作业"]
["welding_cutting_work","int(11)","是","否","否","","焊接与切割作业"]
["heights_work","int(11)","是","否","否","","高处作业"]
["refrigeration_air_work","int(11)","是","否","否","","制冷与空调作业"]
["forklift_work","int(11)","是","否","否","","叉车作业"]
["elevator_work","int(11)","是","否","否","","电梯作业"]
["lifting_machinery_work","int(11)","是","否","否","","起重机械作业"]
["motor_vehicle_work","int(11)","是","否","否","","厂内机动车操作"]
["gas_work","int(11)","是","否","否","","煤气作业"]
["hazardous_chemicals_safe_work","int(11)","是","否","否","","危险化学品安全作业"]
["other_work","varchar(255)","是","否","否","","其他"]
["is_metal_smelting","tinyint(1)","是","否","否","","是否金属冶炼企业(涉及熔炼金属吊运起重机械)"]
["metal_smelting_tonnage","decimal(11,2)","是","否","否","","吨位"]
["metal_smelting_count","int(11)","是","否","否","","台数"]
["is_metallurgical_crane","int(4)","是","否","否","","是否冶金吊"]
["metal_smelting_remark","varchar(255)","是","否","否","","金属冶炼企业备注"]
["is_limited_space","tinyint(1)","是","否","否","","是否有限空间企业"]
["limited_space_name","varchar(255)","是","否","否","","有限空间名称"]
["harmful_factors","varchar(255)","是","否","否","","主要危险有害因素"]
["limited_space_type","int(10)","是","否","否","","有限空间类型"]
["set_warning_signs","varchar(255)","是","否","否","","警示标识设置情况"]
["limited_space_location","varchar(255)","是","否","否","","所处位置"]
["testing_instruments","varchar(255)","是","否","否","","检测仪器表配备情况"]
["responsible_department","varchar(255)","是","否","否","","责任部门"]
["emergency_equipment","varchar(255)","是","否","否","","应急器材配备情况"]
["measures_taken","varchar(255)","是","否","否","","已采取的对策措施"]
["have_sewage_treatment","varchar(255)","是","否","否","","有无污水处理系统"]
["limited_space_remark","varchar(255)","是","否","否","","备注"]
["is_liquid_nitrogen","tinyint(1)","是","否","否","","是否液氮企业"]
["liquid_nitrogen_main","varchar(255)","是","否","否","","主要内容"]
["is_explosion_proof_dust","tinyint(1)","是","否","否","","是否防爆粉尘企业"]
["dust_type","varchar(255)","是","否","否","","粉尘种类"]
["prevention_wooden_dust_type","varchar(255)","是","否","否","","木质粉尘企业防尘方式"]
["sander","int(10)","是","否","否","","砂光机"]
["paint","int(10)","是","否","否","","使用油漆"]
["employees_count2","int(11)","是","否","否","","员工总数"]
["dustproof_worker_count","int(11)","是","否","否","","防尘作业人数"]
["framework_map","text","是","否","否","","组织框架图地址"]
["four_color_map","text","是","否","否","","安全风险四色分布图"]
["company_map","text","是","否","否","","企业平面图"]
["workshop_position_map","text","是","否","否","","车间岗位布置图"]
["fire_evacuation_route_map","text","是","否","否","","消防疏散路线图"]
["production_process_flow_map","text","是","否","否","","生产工艺流程图及简介"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["safety_company_info_hazardous(安全管理模块_企业安全信息库_使用危化品情况)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["number","int(11)","是","否","否","",""]
["safety_company_info_id","varchar(128)","是","否","否","","safety_company_info表的id"]
["name","varchar(255)","是","否","否","","名称"]
["annual_usage","decimal(12,3)","是","否","否","","年使用量(kg)"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["safety_company_info_material(安全管理模块_企业安全信息库_主要原辅材料产品)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["number","int(11)","是","否","否","",""]
["safety_company_info_id","varchar(128)","是","否","否","","safety_company_info表的id"]
["name","varchar(255)","是","否","否","","名称"]
["specifications","varchar(255)","是","否","否","","规格"]
["annual_usage","decimal(12,3)","是","否","否","","年用量(kg)"]
["maximum_storage_capacity","decimal(12,3)","是","否","否","","最大存储量(kg)"]
["storage_form","varchar(255)","是","否","否","","存储形式"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["safety_knowledge(安全管理模块_安全管理知识库)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["knowledge_type","int(4)","是","否","否","","安全知识类型"]
["attributive_year","int(4)","是","否","否","","归属年度"]
["title","varchar(255)","是","否","否","","标题"]
["info","varchar(2400)","是","否","否","","简介"]
["upload_address","text","是","否","否","","附件上传"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["safety_knowledge_company(安全管理模块_安全管理知识库_关联企业)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["company_id","varchar(128)","是","否","否","","公司id"]
["is_read","varchar(4)","否","否","否","0","是否已看"]
["read_time","datetime","是","否","否","","查看时间"]
["safety_knowledge_id","varchar(128)","是","否","否","","safety_knowledge_id"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["safety_self_checking_manage(安全管理模块_安全自检管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["company_id","varchar(128)","是","否","否","","公司id"]
["company_name","varchar(128)","是","否","否","","物业公司名称"]
["type","varchar(4)","是","否","否","","安全检查类型"]
["attributive_year","int(4)","是","否","否","","归属年度"]
["check_user","varchar(128)","是","否","否","","检查人"]
["check_time","datetime","是","否","否","","检查日期"]
["upload_address_excel","text","是","否","否","","附件上传自检表"]
["check_info","text","是","否","否","","检查详情(待用户检查模板，暂不做)"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注(业务备注)"]
[]
["safety_self_checking_plan(安全管理模块_安全自检计划)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(128)","否","是","否","",""]
["company_id","varchar(128)","是","否","否","","公司id"]
["company_name","varchar(128)","是","否","否","","物业公司名称"]
["attributive_year","int(4)","是","否","否","","归属年度"]
["upload_address_plan","text","是","否","否","","附件上传年度计划"]
["upload_address_excel","text","是","否","否","","附件上传年度计划表"]
["status","int(4)","是","否","否","","状态0正常,1删除"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sale_management(项目管理表(招商租赁房间管理表))"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["project_name","varchar(255)","是","否","否","","项目名称"]
["project_type","varchar(4)","是","否","否","","项目类型(售卖类型:1租赁2挂靠)"]
["project_info","text","是","否","否","","项目简介"]
["Lease_requirements","text","是","否","否","","租赁要求"]
["company_id","varchar(100)","是","否","否","","企业信息表id(改成企业名称)"]
["project_manager","varchar(64)","是","否","否","","招商负责人"]
["manager_phone","varchar(128)","是","否","否","","联系方式"]
["manage_messenger_id","varchar(128)","是","否","否","","信息员id"]
["manage_tracking_dep_id","varchar(128)","是","否","否","","跟踪部门id"]
["relevant_dep_id","text","是","否","否","","相关部门id可多个录入，逗号隔开"]
["relevant_user_id","text","是","否","否","","相关人id可多个录入，逗号隔开"]
["project_status","int(4)","是","否","否","","项目状态(1跟进中,2已确认,3已签约,4关闭)"]
["project_remark","text","是","否","否","","项目备注"]
["success_time","datetime","是","否","否","","签约日期"]
["success_room","varchar(512)","是","否","否","","签约载体"]
["success_picture_address","text","是","否","否","","签约图片地址id"]
["contract_id","varchar(64)","是","否","否","","关联合同id"]
["warning_status","int(4)","是","否","否","","预警状态(1预约临期,2锁定临期,3合同未关联)"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间/申请时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sale_room(项目管理表(关联房间管理表))"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["sale_management_id","varchar(64)","否","否","否","","关联项目管理表id"]
["park_room_id","varchar(64)","否","否","否","","房间id"]
["reservation_status","int(4)","否","否","否","1","预约状态(1意向,2锁定,3预约4预约到期5签约6签合同7锁定到期)"]
["end_time","datetime","是","否","否","","到期时间"]
["success_status","int(4)","是","否","否","","签约状态(1已签约,null未签约)"]
["status","int(4)","是","否","否","","状态0正常,1删除,2已签约所以隐藏"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间/申请时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注(房间名称,例如:科教园131层b1)"]
[]
["settle_in"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","主键id"]
["node","varchar(255)","是","否","否","","流程节点"]
["status","varchar(255)","是","否","否","","流转状态"]
["is_check","varchar(255)","是","否","否","","是否已现场验收"]
["is_confirm","varchar(255)","是","否","否","","入驻款是否已确认"]
["enterprise_id","varchar(20)","是","否","否","","企业ID"]
["enterprise_name","varchar(255)","是","否","否","","企业名称"]
["credit_code","varchar(255)","是","否","否","","企业信用代码"]
["contract_id","varchar(255)","是","否","否","","合同id"]
["contract_no","varchar(255)","是","否","否","","合同编号"]
["no","varchar(255)","是","否","否","","入驻单号"]
["lease_address","varchar(255)","是","否","否","","租赁地点"]
["area","double(10,2)","是","否","否","","面积"]
["start_date","datetime","是","否","否","","合同开始时间"]
["end_date","datetime","是","否","否","","合同结束时间"]
["preparation_period","varchar(255)","是","否","否","","筹备期"]
["legal_person_name","varchar(255)","是","否","否","","法人姓名"]
["legal_person_phone","varchar(255)","是","否","否","","法人电话"]
["legal_person_mailbox","varchar(255)","是","否","否","","法人邮箱"]
["contacts_name","varchar(255)","是","否","否","","联系人姓名"]
["contacts_phone","varchar(255)","是","否","否","","联系人电话"]
["contacts_mailbox","varchar(255)","是","否","否","","联系人邮箱"]
["project_leader_name","varchar(255)","是","否","否","","项目负责人姓名"]
["project_leader_phone","varchar(255)","是","否","否","","项目负责人联系方式"]
["enterprise_submit_date","datetime","是","否","否","","企业上传入驻单时间"]
["main_acceptance","text","是","否","否","","主体验收"]
["electric_charge","decimal(10,2)","是","否","否","","电费"]
["water_rate","decimal(10,2)","是","否","否","","水费"]
["goods_handover","varchar(255)","是","否","否","","物品交接"]
["manage_rules","text","是","否","否","","管理规约"]
["enterprise_notice_letter","text","是","否","否","","企业社会责任告知书"]
["property_service_manual","text","是","否","否","","物业服务手册签收"]
["house_deliver_check","text","是","否","否","","房屋交付验收表"]
["electric_enterprise_information","text","是","否","否","","用电企业信息表"]
["bond","decimal(20,2)","是","否","否","","房屋保证金（合同保证金）"]
["total_rent","decimal(20,2)","是","否","否","","房屋租金（合同总租金）"]
["total_property_cost","decimal(20,2)","是","否","否","","物业管理费（合同总物业费）"]
["bond_date","datetime","是","否","否","","到账日期"]
["total_rent_date","datetime","是","否","否","","到账日期"]
["total_property_cost_date","datetime","是","否","否","","到账日期"]
["key_handover","varchar(255)","是","否","否","","钥匙交接"]
["property_management_handover","varchar(255)","是","否","否","","物业公司交接人"]
["enterprise_recipient","varchar(255)","是","否","否","","企业接收人"]
["handover_date","datetime","是","否","否","","交接日期"]
["settle_in_date","datetime","是","否","否","","入驻日期"]
["entry_form","text","是","否","否","","入驻单"]
["entry_form_template","varchar(255)","是","否","否","","入驻单模板"]
["payment_voucher","text","是","否","否","","入驻款缴款凭证"]
["submit_name","varchar(255)","是","否","否","","入驻发起人姓名"]
["submit_date","datetime","是","否","否","","入驻发起时间"]
["accepter","varchar(255)","是","否","否","","验收人"]
["acceptance_date","datetime","是","否","否","","验收时间"]
["settlement_payment_submit","varchar(255)","是","否","否","","入驻款确认人"]
["settlement_payment_date","datetime","是","否","否","","入驻款确认时间"]
["completion_date","datetime","是","否","否","","入驻办结时间"]
["completion_name","varchar(255)","是","否","否","","办结人"]
["created_id","varchar(255)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["update_id","varchar(255)","是","否","否","",""]
[]
["statistics_import_revenue(经发数据导入表(统计导入营收))"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["company_id","varchar(64)","否","否","否","","公司id"]
["yearmonth","varchar(12)","否","否","否","","任务年月份(例如:202301)"]
["taxation","decimal(12,6)","是","否","否","","税收（万元)"]
["revenue","decimal(12,6)","是","否","否","","营收（万元）"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间(导入时间)"]
["updated_by","varchar(64)","是","否","否","","修改人(操作人)id"]
["updated_at","datetime","是","否","否","","修改(更新)时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_company_yuanqu(园区和公司关系表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["company_id","varchar(64)","是","否","否","","公司id"]
["yuanqu_id","varchar(64)","是","否","否","","园区id"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["sunan_freight_entry(货运入园管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["qr_code","varchar(64)","是","否","否","","通行码为二维码，生成规则：TX年月日流水号\r\n\r\n如：TX202302020001"]
["to_companies_name","varchar(5000)","是","否","否","","收货企业名称s"]
["to_companies_is","varchar(5000)","是","否","否","","收货企业ids"]
["from_company_name","varchar(255)","是","否","否","","发货企业名称"]
["appointment_in_park_time","timestamp","是","否","否","","预约入园时间"]
["yuanqu_id","varchar(64)","是","否","否","","园区id"]
["cargo_weight","decimal(10,3)","是","否","否","","货物重量（吨）"]
["cargo_info","varchar(5000)","是","否","否","","货物信息"]
["driver_name","varchar(255)","是","否","否","","司机姓名"]
["driver_phone","varchar(64)","是","否","否","","司机电话号码"]
["car_number","varchar(32)","是","否","否","","车牌号"]
["push_type","int(4)","是","否","否","","1提交(不需要用了)"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id/预约人id"]
["created_by_company","varchar(64)","是","否","否","","预约人所属企业id"]
["created_at","datetime","是","否","否","","创建时间/提交时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_idle_resource(闲置资源管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["name","varchar(512)","是","否","否","","资源名称"]
["types","varchar(1024)","是","否","否","","资源类别(字典sunan_renting_type)数组左右用逗号隔开例如,1,2,"]
["use_type","int(3)","是","否","否","","使用方式1.租聘,2购买"]
["init_use_money","decimal(10,2)","是","否","否","","参考金额元"]
["connect_name","varchar(255)","是","否","否","","联系人名称"]
["connect_phone","varchar(255)","是","否","否","","联系电话"]
["picture_url","varchar(1024)","是","否","否","","资源图片"]
["info","varchar(5000)","是","否","否","","资源描述"]
["push_type","int(4)","是","否","否","","1上架,2下架"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
["update_by_frame_user","varchar(64)","是","否","否","","平台操作人id"]
["update_at_frame_user","datetime","是","否","否","","平台操作时的时间"]
[]
["sunan_idle_resource_type(闲置资源表的资源类别(暂时不用))"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_portal_management(门户信息管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["type","int(4)","是","否","否","","园区类型(字典[portal_type]:1,园区简介,2服务定位,3产业集群)"]
["info","text","是","否","否","","描述"]
["picture_info","varchar(2000)","是","否","否","","图片信息"]
["push_type","int(4)","是","否","否","","发布状态1已发布,2待发布"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_renting(招租管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["yuanqu_id","varchar(64)","是","否","否","","关联园区"]
["types","varchar(1024)","是","否","否","","招租类别(字典sunan_renting_type)数组左右用逗号隔开例如,1,2,"]
["info","varchar(5000)","是","否","否","","招租描述"]
["picture_url","varchar(1024)","是","否","否","","招租图片"]
["connect_name","varchar(255)","是","否","否","","联系人"]
["connect_phone","varchar(255)","是","否","否","","联系电话"]
["push_type","int(4)","是","否","否","","1上架,2下架"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
["update_by_frame_user","varchar(64)","是","否","否","","平台操作人id"]
["update_at_frame_user","datetime","是","否","否","","平台操作时的时间"]
[]
["sunan_seeking_rent(求租管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["info","varchar(5000)","是","否","否","","求租描述"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["connect_name","varchar(255)","是","否","否","","联系人"]
["connect_phone","varchar(255)","是","否","否","","联系电话"]
["push_type","int(4)","是","否","否","","1上架,2下架"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
["update_by_frame_user","varchar(64)","是","否","否","","平台操作人id"]
["update_at_frame_user","datetime","是","否","否","","平台操作时的时间"]
[]
["sunan_video(视频管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["yuanqu_id","varchar(64)","是","否","否","","关联园区"]
["give_person","varchar(255)","是","否","否","","视频提供方"]
["address","varchar(512)","是","否","否","","详细地址"]
["video_url","varchar(255)","是","否","否","","视频码流"]
["status","int(4)","是","否","否","","状态0正常,1删除,2暂存"]
["created_by","varchar(64)","是","否","否","","创建人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_yuanqu_info_management(园区信息管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["yuanqu_id","varchar(64)","是","否","否","","园区id"]
["info","varchar(5000)","是","否","否","","信息描述"]
["yuanqu_info_type_id","varchar(64)","是","否","否","","信息类型表的id"]
["push_type","int(4)","是","否","否","","1已发布,2待发布"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注"]
[]
["sunan_yuanqu_info_type(园区信息类型)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(64)","否","是","否","","主键"]
["type_info","varchar(512)","是","否","否","","类型名称"]
["status","int(4)","是","否","否","","状态0正常"]
["created_by","varchar(64)","是","否","否","","创建人id/发布人id"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","修改人id"]
["updated_at","datetime","是","否","否","","修改时间"]
["remark","varchar(255)","是","否","否","","备注(作为排序使用)"]
[]
["sys_agreement"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","id"]
["agreement_type","varchar(255)","是","否","否","","类型"]
["agreement","text","是","否","否","","协议"]
["version","varchar(50)","是","否","否","","版本"]
["status","varchar(50)","是","否","否","","状态"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_at","datetime","是","否","否","","修改时间"]
[]
["sys_announce(通知公告表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["title","varchar(255)","是","否","否","","公告标题"]
["sub_title","varchar(255)","是","否","否","","公告副标题"]
["content","text","是","否","否","","公告正文"]
["attachments","text","是","否","否","","公告附件"]
["status","varchar(1)","是","否","否","","0编辑中，1发布，2停止发布，3过期"]
["valid_at","datetime","是","否","否","","生效时间"]
["user_ids","text","是","否","否","","所选用户ID"]
["dept_ids","text","是","否","否","","所选部门ID"]
["created_at","datetime","是","否","否","",""]
["created_by","varchar(50)","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","","系统标识"]
[]
["sys_announce_to"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["announce_id","varchar(50)","否","否","否","","通知ID"]
["user_id","varchar(50)","否","否","否","","用户ID"]
["status","varchar(1)","是","否","否","","0未读，1已读"]
["created_at","datetime","是","否","否","","创建时间"]
["sys_id","varchar(50)","是","否","否","","系统标识"]
[]
["sys_dept"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["parent_id","varchar(50)","是","否","否","",""]
["group_id","varchar(512)","是","否","否","","所属集团分公司"]
["dept_name","varchar(255)","否","否","否","","部门名称"]
["dept_code","varchar(255)","是","否","否","","部门编码"]
["dept_url","varchar(255)","是","否","否","","部门logo"]
["dept_order","int(11)","是","否","否","","顺序号"]
["dept_level","int(11)","是","否","否","","部门层级"]
["dept_attr","varchar(255)","是","否","否","","部门属性，字典项，多一类相关类型"]
["changed_by","varchar(50)","是","否","否","","部门负责人"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","",""]
[]
["sys_dept_attr"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["attr_name","varchar(50)","是","否","否","",""]
["attr_code","varchar(512)","是","否","否","",""]
["seq_no","int(11)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["sys_dict"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["dict_name","varchar(100)","否","否","否","","字典名称"]
["dict_code","varchar(100)","否","否","否","","字典编码，唯一"]
["dict_value","text","是","否","否","","字典值项"]
["sys_id","varchar(50)","是","否","否","","归属系统id"]
[]
["sys_group(集团管理)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["name","varchar(255)","是","否","否","","分公司名"]
["code","varchar(20)","是","否","否","","识别码"]
["sequence_no","int(11)","是","否","否","","顺序号"]
["comments","varchar(255)","是","否","否","","备注说明"]
["created_by","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","",""]
[]
["sys_group_user"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["group_id","varchar(50)","是","否","否","",""]
["user_id","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["sys_id","varchar(50)","是","否","否","",""]
[]
["sys_home_link"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["link_name","varchar(100)","否","否","否","","接链名称"]
["link_image","varchar(255)","是","否","否","","链接图标"]
["link_url","varchar(255)","否","否","否","","链接地址"]
["link_order","varchar(10)","是","否","否","","排序"]
["sys_id","varchar(50)","是","否","否","",""]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
["link_type","varchar(255)","是","否","否","",""]
["created_by","varchar(255)","是","否","否","",""]
["updated_by","varchar(255)","是","否","否","",""]
[]
["sys_info"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["info_type","varchar(100)","是","否","否","","消息类型"]
["target_id","varchar(50)","是","否","否","","目标ID"]
["business_key","varchar(50)","是","否","否","","业务Key"]
["business_status","varchar(50)","是","否","否","","业务状态，0待处理，1已处理"]
["business_op_status","varchar(50)","是","否","否","","流程中得状态，目前特殊的是撤回，需进入其他对应页面"]
["info_summary","varchar(255)","是","否","否","","消息概括"]
["info_to","varchar(50)","是","否","否","","消息接收人"]
["info_status","varchar(10)","是","否","否","","消息状态，0未读，1已读"]
["menu_url","varchar(255)","是","否","否","","关联菜单路由"]
["read_at","datetime","是","否","否","","阅读时间"]
["created_by","varchar(50)","是","否","否","","创建来源"]
["created_at","datetime","是","否","否","","创建时间"]
["deal_at","datetime","是","否","否","","处理时间"]
[]
["sys_message_info"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["title","varchar(255)","是","否","否","","主题"]
["version_no","varchar(100)","是","否","否","","版本号"]
["push_by","varchar(255)","是","否","否","","发布人id"]
["push_name","varchar(255)","是","否","否","","发布人名称"]
["push_time","datetime","是","否","否","","发布时间"]
["update_by","varchar(255)","是","否","否","","更新人id"]
["update_name","varchar(255)","是","否","否","","更新人name"]
["update_time","datetime","是","否","否","","更新时间"]
["create_by","varchar(255)","是","否","否","","创建人id"]
["create_name","varchar(255)","是","否","否","","创建人name"]
["create_time","datetime","是","否","否","","创建时间"]
["state","varchar(255)","是","否","否","","状态(0=已发布，1=待发布，2=已撤回)"]
["annex","varchar(500)","是","否","否","","附件"]
["push_state","varchar(255)","是","否","否","","发布状态(0=发布，1=暂存)"]
["content","longtext","是","否","否","","内容"]
[]
["sys_message_read"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["msg_id","varchar(100)","是","否","否","","消息id"]
["user_id","varchar(100)","是","否","否","","阅读人id"]
["read_time","datetime","是","否","否","","阅读时间"]
[]
["sys_my_menu"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["user_id","varchar(255)","是","否","否","","用户ID"]
["menu_id","text","是","否","否","","菜单ID"]
["created_by","varchar(64)","是","否","否","","创建"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_by","varchar(64)","是","否","否","","更新人"]
["updated_at","datetime","是","否","否","","更新时间"]
[]
["sys_op_log(操作记录表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["referenceId","varchar(50)","是","否","否","","关联表ID"]
["referenceType","varchar(255)","是","否","否","","关联表EMU， 目前 ‘ENV_SENSOR’  是指向传感器表"]
["comment","text","是","否","否","","操作事件记录"]
["createdAt","datetime","是","否","否","","创建时间"]
["operByName","varchar(255)","是","否","否","",""]
["operBy","varchar(50)","是","否","否","","操作人"]
[]
["sys_param"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["param_name","varchar(255)","是","否","否","","参数名"]
["param_code","varchar(50)","否","否","否","","参数码"]
["param_value","varchar(50)","是","否","否","","参数值"]
["param_text","text","是","否","否","","参数值，大字段"]
["value_type","varchar(50)","是","否","否","","参数类型：string, date(yyyyMMdd), datetime(yyyyMMdd hh:mm:ss), number"]
["sys_id","varchar(50)","是","否","否","","系统码"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]
[]
["sys_server_card_info"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(100)","否","是","否","","主键"]
["group_code","varchar(255)","是","否","否","","客服QQ群二维码"]
["group_no","varchar(100)","是","否","否","","客服QQ群号"]
["group_heatray","varchar(255)","是","否","否","","客服QQ热线"]
["server_phone","varchar(255)","是","否","否","","客服电话"]
["product_name_fir","varchar(255)","是","否","否","","产品经理1名称"]
["product_phone_fir","varchar(255)","是","否","否","","产品经理1电话"]
["product_name_two","varchar(255)","是","否","否","","产品经理2名称"]
["product_phone_two","varchar(255)","是","否","否","","产品经理2电话"]
["user_handbook","varchar(500)","是","否","否","","用户手册"]
["create_time","datetime","是","否","否","","创建时间"]
["create_by","varchar(255)","是","否","否","","创建人"]
["create_name","varchar(255)","是","否","否","","创建人名称"]
["update_by","varchar(100)","是","否","否","","修改人"]
["update_name","varchar(100)","是","否","否","","修改人名称"]
["update_time","datetime","是","否","否","","修改时间"]
["product_name_thr","varchar(255)","是","否","否","","产品经理3名称"]
["product_phone_thr","varchar(255)","是","否","否","","产品经理3电话"]
[]
["sys_zone"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["parent_id","varchar(50)","是","否","否","",""]
["zone_name","varchar(255)","否","否","否","","区域名称"]
["zone_code","varchar(255)","是","否","否","","区域编码"]
["zone_order","int(11)","是","否","否","","排序"]
["zone_level","int(11)","是","否","否","","层次"]
["zone_lng","varchar(255)","是","否","否","","经度"]
["zone_lat","varchar(255)","是","否","否","","纬度"]
["created_at","datetime","是","否","否","","创建时间"]
["updated_at","datetime","是","否","否","","更新时间"]
[]
["user_account(用户账号表)"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","","ID"]
["account","varchar(255)","否","否","否","","账号"]
["password","varchar(255)","是","否","否","","密码"]
["avatar_url","varchar(255)","是","否","否","","头像"]
["city","varchar(100)","是","否","否","","城市"]
["country","varchar(100)","是","否","否","","国家"]
["province","varchar(100)","是","否","否","","省份"]
["gender","varchar(20)","是","否","否","","性别"]
["language","varchar(50)","是","否","否","","语言"]
["nick_name","varchar(255)","是","否","否","","昵称"]
["open_id","varchar(255)","是","否","否","","微信openID"]
["user_id","varchar(50)","是","否","否","","用户ID"]
["sys_id","varchar(50)","是","否","否","","系统ID"]
["created_at","datetime","是","否","否","","创建时间"]
[]
["user_main"]
["列名","数据类型","是否为空","主键","自增","默认值","备注"]
["id","varchar(50)","否","是","否","",""]
["avatar_url","varchar(255)","是","否","否","","头像"]
["true_name","varchar(100)","是","否","否","","真实姓名"]
["nick_name","varchar(100)","是","否","否","","昵称"]
["phone_no","varchar(50)","是","否","否","",""]
["gender","varchar(10)","是","否","否","","性别"]
["age","int(11)","是","否","否","","年龄"]
["birthday","date","是","否","否","","生日"]
["profession","varchar(255)","是","否","否","","职业"]
["industry","varchar(255)","是","否","否","","从事行业"]
["hobby","varchar(255)","是","否","否","","兴趣爱好"]
["spec","varchar(255)","是","否","否","","特长"]
["body_height","double","是","否","否","","身高（cm）"]
["body_weight","double","是","否","否","","体重（kg）"]
["identity_type","varchar(10)","是","否","否","","证件类型"]
["identity_no","varchar(255)","是","否","否","","证件号"]
["address_home","varchar(255)","是","否","否","","家庭住址"]
["address_often","varchar(255)","是","否","否","","常住地"]
["bill_amount","float","是","否","否","","消费金额累计"]
["status","char(1)","是","否","否","","状态"]
["real_name_status","varchar(255)","是","否","否","","实名状态"]
["del_flag","char(1)","是","否","否","","删除（0存在，1删除）"]
["user_tag","varchar(20)","是","否","否","","用户标签，针对业务用于各种场景"]
["image_data","text","是","否","否","","图片数据"]
["sys_id","varchar(50)","是","否","否","","系统ID"]
["created_at","datetime","是","否","否","",""]
["updated_at","datetime","是","否","否","",""]