42 lines
1.4 KiB
MySQL
42 lines
1.4 KiB
MySQL
|
create table hrsa_report_push
|
|||
|
|
(
|
|||
|
|
id bigint primary key comment 'ID' ,
|
|||
|
|
create_time datetime default now() comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
update_time datetime default now() comment '<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
creator bigint comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ,
|
|||
|
|
delete_type int default 0 comment '<EFBFBD>Ƿ<EFBFBD>ɾ<EFBFBD><EFBFBD>' ,
|
|||
|
|
tenant_key varchar(10) comment '<EFBFBD>⻧KEY' ,
|
|||
|
|
msg_id bigint comment '<EFBFBD><EFBFBD>Ϣid' ,
|
|||
|
|
report_ids varchar(500) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ,
|
|||
|
|
start_time varchar(30) comment '<EFBFBD><EFBFBD>Ч<EFBFBD><EFBFBD>ʼʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
end_time varchar(30) comment '<EFBFBD><EFBFBD>Ч<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
push_channel varchar(30) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,
|
|||
|
|
email_account varchar(30) comment '<EFBFBD>ʼ<EFBFBD><EFBFBD>˺<EFBFBD>' ,
|
|||
|
|
mark varchar(100) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><EFBFBD>' ,
|
|||
|
|
push_title varchar(30) comment '<EFBFBD><EFBFBD><EFBFBD>ͱ<EFBFBD><EFBFBD><EFBFBD>' ,
|
|||
|
|
email_account_id bigint,
|
|||
|
|
remind int
|
|||
|
|
)
|
|||
|
|
;
|
|||
|
|
|
|||
|
|
|
|||
|
|
create table hrsa_report_push_detail
|
|||
|
|
(
|
|||
|
|
id bigint primary key comment 'ID' ,
|
|||
|
|
create_time datetime default now() comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
update_time datetime default now() comment '<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
creator bigint comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>id' ,
|
|||
|
|
delete_type int default 0 comment '<EFBFBD>Ƿ<EFBFBD>ɾ<EFBFBD><EFBFBD>' ,
|
|||
|
|
tenant_key varchar(10) comment '<EFBFBD>⻧KEY' ,
|
|||
|
|
msg_id bigint comment '<EFBFBD><EFBFBD>Ϣid' ,
|
|||
|
|
employee_id bigint comment 'Ա<EFBFBD><EFBFBD>id' ,
|
|||
|
|
push_time varchar(30) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
push_status varchar(5) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬' ,
|
|||
|
|
reback_time varchar(30) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' ,
|
|||
|
|
reback_status varchar(5) comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>״̬' ,
|
|||
|
|
batch_id bigint comment '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>id',
|
|||
|
|
view_status varchar(10)
|
|||
|
|
)
|
|||
|
|
;
|
|||
|
|
|