create table if not exists dependent_card_apply_status_log (
|
id bigint unsigned not null auto_increment comment '主键',
|
apply_id bigint unsigned not null comment '家属卡申请ID',
|
apply_no varchar(64) not null comment '申请编号',
|
from_status tinyint default null comment '变更前状态',
|
to_status tinyint not null comment '变更后状态',
|
operator_type varchar(32) not null comment '操作方：ADMIN后台 TALENT小程序',
|
operator_id bigint unsigned default null comment '操作人ID',
|
remark varchar(500) default null comment '状态变更备注',
|
created_at datetime not null default current_timestamp comment '创建时间',
|
primary key (id),
|
key idx_dependent_status_log_apply_id (apply_id),
|
key idx_dependent_status_log_apply_no (apply_no),
|
key idx_dependent_status_log_created_at (created_at)
|
) engine=InnoDB default charset=utf8mb4 collate=utf8mb4_general_ci comment='家属附属卡申请状态变更记录';
|
