mapper

---

– 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;