CREATE TABLE  hrsa_insurance_base_info  (

 id  bigint NOT NULL,

 employee_id  bigint NOT NULL COMMENT '人员id',

 payment_organization  int NULL COMMENT '个税扣缴义务人id',

 social_archives_id  bigint NULL COMMENT '社保档案id',

 fund_archives_id  bigint NULL COMMENT '公积金档案id',

 other_archives_id  bigint NULL COMMENT '其他福利档案id',

 tenant_key  varchar(10) NOT NULL,

 creator  int NOT NULL,

 delete_type  int NOT NULL,

 create_time  datetime NOT NULL,

 update_time  datetime NOT NULL,

 run_status  varchar(20) NOT NULL COMMENT '福利执行状态',

PRIMARY KEY ( id ) 

);