CREATE TABLE  hrsa_compensation_log  (

 id  bigint NOT NULL,

 payment_agency  bigint NULL COMMENT '缴纳组织',

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

 employee_id  bigint NULL COMMENT '员工id',

 welfare_type  int NULL COMMENT '调差福利类别',

 category_type  varchar(100) NULL COMMENT '调差福利类型下的福利项',

 country_total  text NULL COMMENT '国家核算金额',

 company_total  text NULL COMMENT '公司核算金额',

 adjustment_total  text NULL COMMENT '应调差额',

 adjust_to  bigint NULL COMMENT '调差到',

 bill_month  varchar(30) NULL COMMENT '账单月份',

 creator  bigint NULL COMMENT '创建人id',

 delete_type  int NULL COMMENT '是否删除',

 create_time  datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

 update_time  datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

 tenant_key  varchar(10) NULL COMMENT '租户key',

PRIMARY KEY ( id ) USING BTREE

)
COMMENT = '社保福利台账-调差历史记录表';


CREATE TABLE  hrsa_compensation_config  (

 id  bigint NOT NULL,

 payment_agency  bigint NULL COMMENT '缴纳组织',

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

 employee_id  bigint NULL COMMENT '员工id',

 welfare_type  int NULL COMMENT '调差福利类别',

 category_type  varchar(100) NULL COMMENT '调差福利类型下的福利项',

 adjust_to  bigint NULL COMMENT '调差到',

 creator  bigint NULL COMMENT '创建人id',

 delete_type  int NULL COMMENT '是否删除',

 create_time  datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

 update_time  datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

 tenant_key  varchar(10) NULL COMMENT '租户key',

PRIMARY KEY ( id ) USING BTREE

)
COMMENT = '社保福利台账-调差配置表';