26 lines
1.6 KiB
MySQL
26 lines
1.6 KiB
MySQL
|
CREATE TABLE IF NOT EXISTS `sys_user_electronic_signature` (
|
|||
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|||
|
|
`tenant_id` varchar(20) NOT NULL DEFAULT '000000' COMMENT '租户编号',
|
|||
|
|
`person_key` varchar(128) NOT NULL COMMENT '人员唯一标识，规则：loginPort:companyId:businessUserId，业务ID为空时回退为 userId',
|
|||
|
|
`user_id` bigint NOT NULL COMMENT '系统用户ID',
|
|||
|
|
`business_user_id` varchar(64) DEFAULT NULL COMMENT '业务人员ID',
|
|||
|
|
`company_id` bigint DEFAULT NULL COMMENT '企业ID',
|
|||
|
|
`login_port` varchar(64) NOT NULL COMMENT '登录端口',
|
|||
|
|
`sign_oss_id` bigint DEFAULT NULL COMMENT '电子签名图片OSS ID',
|
|||
|
|
`sign_name` varchar(64) DEFAULT NULL COMMENT '签署人名称快照',
|
|||
|
|
`status` char(1) NOT NULL DEFAULT '1' COMMENT '状态：1=已设置 0=未设置',
|
|||
|
|
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
|
|||
|
|
`create_dept` bigint DEFAULT NULL COMMENT '创建部门',
|
|||
|
|
`create_by` bigint DEFAULT NULL COMMENT '创建人',
|
|||
|
|
`create_by_name` varchar(64) DEFAULT NULL COMMENT '创建人名称',
|
|||
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|||
|
|
`update_by` bigint DEFAULT NULL COMMENT '更新人',
|
|||
|
|
`update_by_name` varchar(64) DEFAULT NULL COMMENT '更新人名称',
|
|||
|
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|||
|
|
PRIMARY KEY (`id`),
|
|||
|
|
UNIQUE KEY `uk_tenant_person_key` (`tenant_id`, `person_key`),
|
|||
|
|
KEY `idx_user_id` (`user_id`),
|
|||
|
|
KEY `idx_business_user_id` (`business_user_id`),
|
|||
|
|
KEY `idx_company_id` (`company_id`)
|
|||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户电子签名配置表';
|