– Table structure for admin
DROP TABLE IF EXISTS admin
;
CREATE TABLE admin
(
id
bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
identifier
varchar(64) DEFAULT NULL COMMENT ‘统一社会信用代码’,
password
varchar(255) DEFAULT NULL COMMENT ‘密码’,
is_main
int(1) DEFAULT NULL COMMENT ‘是否是主账号:0:否;1:是’,
company_id
bigint(20) DEFAULT NULL COMMENT ‘所属公司id’,
email
varchar(64) DEFAULT NULL COMMENT ‘邮箱’,
created
bigint(20) DEFAULT NULL COMMENT ‘创建时间’,
updated
bigint(20) DEFAULT NULL COMMENT ‘修改时间’,
is_delete
int(1) DEFAULT NULL COMMENT ‘是否删除,0否;1是’,
version
bigint(20) DEFAULT NULL COMMENT ‘乐观锁’,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;