{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":214,"n_cols":10,"rows_kept":214,"cut":false,"hidden":false,"merged":[[2,1,54,1],[67,1,123,1],[26,3,27,3],[77,3,79,3],[89,3,91,3]]}
[]
[]
[null,"企业信息","base_company","企业信息",null,"base_company_member","企业人员"]
[null,null,"id_","编号",null,"id_","编号"]
[null,null,"name_","用户名",null,"company_id","企业ID"]
[null,null,"real_name","企业名称",null,"name_","姓名"]
[null,null,"pass_word","密码",null,"card_type","证件类型"]
[null,null,null,"余额",null,"card_no","证件编号"]
[null,null,"legal_name","法人代表",null,"sex_","性别"]
[null,null,"legal_card","法人代表身份证",null,"age_","年龄"]
[null,null,"legal_card_file","法人代表身份证附件",null,"jobs_id","行业ID"]
[null,null,"uscc_code","证件编号",null,"health_status","健康状态"]
[null,null,"uscc_files","证件附件(营业执照/企业代码)",null,"card_files","身份证件附件"]
[null,null,"type_","企业类型",null,"status_","状态"]
[null,null,"business_nature","营业性质",null,"create_by","创建人"]
[null,null,"business_scope","营业范围",null,"create_time","创建时间"]
[null,null,"industry_type","行业类型",null,"update_by","修改人"]
[null,null,"employees_number","雇员人数",null,"update_time","修改时间"]
[null,null,"insured_number","已投保人数",null,"del_flag","是否删除"]
[null,null,"person_","联系人"]
[null,null,"tel_","联系电话"]
[null,null,"mail_","邮箱"]
[null,null,"postal_","邮编",null,"base_transaction_record","企业账户流水表"]
[null,null,"address_","联系地址",null,"id_","编号"]
[null,null,"company_stamp_file","企业公章(附件)",null,"company_id","企业ID"]
[null,null,"promoter_","推广员账号",null,"transaction_number","交易号"]
[null,null,"remark_","近三年损失情况（时间、原因、损失金额）",null,"amount_","交易金额"]
[{"$nulls":5},"order_no","订单号"]
[null,null,"open_id","微信openID",null,"payment_status","支付状态"]
[null,null,"buy_id","云平台买方ID",null,"buy_type","支付类型:微信,支付宝等"]
[null,null,"status_","状态",null,"payment_time","支付时间"]
[null,null,"create_by","创建人",null,"create_by","创建人"]
[null,null,"create_time","创建时间",null,"create_time","创建时间"]
[null,null,"update_by","修改人",null,"update_by","修改人"]
[null,null,"update_time","修改时间",null,"update_time","修改时间"]
[null,null,"del_flag","是否删除",null,"del_flag","是否删除"]
[]
[]
[]
[null,null,"base_message","消息",null,"base_approval_record","企业历史投保记录"]
[null,null,"title_","标题",null,"id_","编号"]
[null,null,"content_","内容",null,"company_id","企业ID"]
[null,null,"sender_id","发件人ID",null,"application_id","投保申请ID"]
[null,null,"recipient_id","收件人ID",null,"status_","投保状态"]
[null,null,"status_","状态(未读/已读)",null,"create_by","创建人"]
[null,null,"create_by","创建人",null,"create_time","创建时间"]
[null,null,"create_time","创建时间",null,"update_by","修改人"]
[null,null,"update_by","修改人",null,"update_time","修改时间"]
[null,null,"update_time","修改时间",null,"del_flag","是否删除"]
[null,null,"del_flag","是否删除"]
{"$rows_empty":17}
[null,"投保申请\n/投保单花名册","business_insurance_application","投保单",null,"business_application_policy","投保单和每月投保单关联表",null,"service_insurance_user","投保用户"]
[null,null,"id_","编号",null,"id_","编号",null,"id_"]
[null,null,"company_id","参保企业",null,"application_id","投保申请ID",null,"application_id","投保申请ID"]
[null,null,"insurance_type","保险种类",null,"policy_id","每月投保单ID"]
[null,null,"insured_name","投保人姓名",{"$nulls":4},"user_id","企业用户ID"]
[null,null,"insured_tel","联系电话",{"$nulls":4},"status","审核状态"]
[null,null,"start_time","保障开始时间",{"$nulls":4},"is_add","是否为增补"]
[null,null,"end_time","保障结束时间",{"$nulls":4},"create_by"]
[null,null,"number_","保障数量",{"$nulls":4},"create_time"]
[null,null,"insurance_fee","保险费合计(总金额)",{"$nulls":4},"update_by"]
[null,null,"status_","状态:草稿10/待初审20/待复审30/待缴费40/待制单50/待出单60/已出单70/已过期100",{"$nulls":4},"update_time"]
[{"$nulls":8},"del_flag"]
[]
[null,null,"process_status","流程审核状态:正常/回退等"]
[null,null,"create_by","创建人",{"$nulls":4},"service_insurance_files","投保附件"]
[null,null,"create_time","创建时间",{"$nulls":4},"id_"]
[null,null,"update_by","修改人",{"$nulls":4},"application_id","投保申请ID"]
[null,null,"update_time","修改时间",{"$nulls":4},"name_","附件名称"]
[null,null,"del_flag","是否删除",{"$nulls":4},"url_","地址"]
[{"$nulls":8},"status_","状态"]
[null,null,"business_insurance_policy","每月投保单",null,"business_insurance_policy_member","花名册(每月",null,"create_by"]
[null,null,"id_","编号",null,"id_","编号",null,"create_time"]
[null,null,"status_","状态:待制单50/待出单60/已出单70",null,"policy_id","每月投保单ID",null,"update_by"]
[{"$nulls":5},"company_user_id","企业用户ID",null,"update_time"]
[{"$nulls":5},"status_","审核状态"]
[null,null,"process_status","流程审核状态:正常/回退等",null,"is_add","是否为增补"]
[null,null,"insurance_fee","保险费合计(总金额)",null,"create_by","创建人",null,"del_flag"]
[null,null,"start_time","开始时间",null,"create_time","创建时间"]
[null,null,"end_time","结束时间",null,"update_by","修改人"]
[null,null,"number_","人数",null,"update_time","修改时间"]
[null,null,"account_bank","入账银行",null,"del_flag","是否删除"]
[null,null,"issuing_bank","出账银行"]
[null,null,"singl_number","单号"]
[null,null,"transfer_time","转账时间"]
[null,null,"agent_id","限额"]
[null,null,"insurance_policy_file","投保单附件"]
[null,null,"create_by","限额"]
[null,null,"create_time","创建时间"]
[null,null,"update_by","修改人"]
[null,null,"update_time","修改时间"]
[null,null,"del_flag","是否删除"]
[null,null,"no_","当前第几份"]
[{"$nulls":8},"service_insurance_application_record","投保单审核流水"]
[{"$nulls":8},"id_"]
[null,null,"business_insurance_policy_record","每月投保单审核流水",{"$nulls":4},"application_id","投保申请ID"]
[null,null,"id_","编号",{"$nulls":4},"opinion_","意见"]
[null,null,"policy_id","每月投保单申请ID",{"$nulls":4},"process_status","流程审核状态:正常/回退等"]
[null,null,"opinion_","意见",{"$nulls":4},"create_by"]
[null,null,"process_status","流程审核状态:正常/回退等",{"$nulls":4},"create_time"]
[null,null,"create_by","创建人",{"$nulls":4},"update_by"]
[null,null,"create_time","创建时间",{"$nulls":4},"update_time"]
[null,null,"update_by","修改人",{"$nulls":4},"del_flag"]
[null,null,"update_time","修改时间"]
[null,null,"del_flag","是否删除"]
[]
[]
[]
[]
[null,null,"base_insurance_agent","保险代理人"]
[null,null,"id_","编号"]
[null,null,"name_","姓名"]
[null,null,"status","审核状态"]
[null,null,"create_by","创建人"]
[null,null,"create_time","创建时间"]
[null,null,"update_by","修改人"]
[null,null,"update_time","修改时间"]
[null,null,"del_flag","是否删除"]
[]
[null,null,"base_insurance_definition","险种信息",null,"base_insurance_definition_limit","险种限额信息"]
[null,null,"id_","编号",null,"id_","编号"]
[null,null,"name_","险种",null,"definition_id","险种信息ID"]
[null,null,"insurance_description","投保声明",null,"name_","限额名称"]
[null,null,"disclaimer_","免责说明",null,"limit_","责任限额/免赔额"]
[null,null,"quit_description","退保说明",null,"status_","状态"]
[null,null,"clause_","雇主责任险条款",null,"unit_","计算单位(次/元/人/万)"]
[null,null,"status_","状态",null,"create_by","创建人"]
[null,null,"create_by","创建人",null,"create_time","创建时间"]
[null,null,"create_time","创建时间",null,"update_by","修改人"]
[null,null,"update_by","修改人",null,"update_time","修改时间"]
[null,null,"update_time","修改时间",null,"del_flag","是否删除"]
[null,null,"del_flag","是否删除"]
[]
[]
[null,null,"base_jobs","行业/职业类型",null,"base_insurance_jobs","收费标准表"]
[null,null,"id_","编号",null,"id_","编号"]
[null,null,"definition_id","险种信息ID",null,"jobs_id","行业ID"]
[null,null,"name_","名称",null,"definition_id","险种信息ID"]
[null,null,"content_","详细信息",null,"charges_","收费标准(月)"]
[null,null,"status_","状态",null,"create_by","创建人"]
[null,null,"create_by","创建人",null,"create_time","创建时间"]
[null,null,"create_time","创建时间",null,"update_by","修改人"]
[null,null,"update_by","修改人",null,"update_time","修改时间"]
[null,null,"update_time","修改时间",null,"del_flag","是否删除"]
[null,null,"del_flag","是否删除"]
{"$rows_empty":7}
[null,null,"service_billing_records","出账记录",null,"service_collection_records","收款记录"]
[null,null,"id_",null,null,"id_"]
[null,null,"amount_","金额",null,"amount_","金额"]
[]
[]
[null,null,"create_by","操作人",null,"create_by"]
[null,null,"create_time","操作时间",null,"create_time"]
[null,null,"update_by",null,null,"update_by"]
[null,null,"update_time",null,null,"update_time"]
[null,null,"del_flag",null,null,"del_flag"]
[]
[]
[null,null,"sys_user","管理用户(PICC/人才超市)",null,"sys_user_role","用户角色"]
[null,null,"id_","编号",null,"id_","编号"]
[null,null,"name_","用户名",null,"user_id"]
[null,null,"real_name","真实名称",null,"role_id"]
[null,null,"pass_word","密码"]
[null,null,"status_","状态"]
[null,null,"create_by","创建人"]
[null,null,"create_time","创建时间"]
[null,null,"update_by","修改人"]
[null,null,"update_time","修改时间"]
[null,null,"del_flag","是否删除"]
[]
[]
[null,null,"sys_role","角色"]
[null,null,"id_"]
[null,null,"name_","角色名称"]
[null,null,"create_by","创建人"]
[null,null,"create_time","创建时间"]
[null,null,"update_by","修改人"]
[null,null,"update_time","修改时间"]
[null,null,"del_flag","是否删除"]
[]
[]
[]
[null,null,"sys_data_dictionary","字典"]
[null,null,"id_"]
[null,null,"name_","名称"]
[null,null,"value_","值"]
[null,null,"parent_id"]
[null,null,"create_by","创建人"]
[null,null,"create_time","创建时间"]
[null,null,"update_by","修改人"]
[null,null,"update_time","修改时间"]
[null,null,"del_flag","是否删除"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}