management

create table

tbl_employee_role
    CREATE TABLE `tbl_employee_role` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `employee_id` int(11) NOT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `delete` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8;

tbl_permission_class
    CREATE TABLE `tbl_permission_class` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `level` int(11) NOT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `delete` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

modify table

tbl_employee
    添加 create_time updatea_time 列
        `create_time` datetime DEFAULT NULL,
        `update_time` datetime DEFAULT NULL,
    添加和 身份证 有关的三列
        `card_id` varchar(20) COLLATE DEFAULT NULL,
        `card_emblem_img` varchar(40) COLLATE DEFAULT NULL,
        `card_photo_img` varchar(40) COLLATE DEFAULT NULL,
    添加 partner_id 列。因为 departement 废弃了，所以不能通过 depart_id 来找 partner_id
        `partner_id` int(11) DEFAULT NULL,
    废弃(Allow Null) department_id 列
    废弃(Allow Null) role_id 列

tbl_role
    添加 create_time updatea_time 列
        `create_time` datetime DEFAULT NULL,
        `update_time` datetime DEFAULT NULL,
    添加 partner_id
        `partner_id` int(11) DEFAULT NULL
    废弃(Allow Null) depart_id

tbl_exception_history
    废弃(Allow Null) department_blame_id
    废弃(Allow Null) departmen_to_id
    添加 department_blame_name
        `department_blame_name` varchar(80) COLLATE NOT NULL
    添加 department_to_name
        `department_to_name` varchar(80) COLLATE NOT NULL

tbl_order_remark 异常订单备注
    废弃(Allow Null) department_id
    添加 department_name

tbl_refund_history
    废弃(Allow Null) department_blame_id
    废弃(Allow Null) departmen_to_id
    添加 department_blame_name
        `department_blame_name` varchar(80) COLLATE NOT NULL
    添加 department_to_name
        `department_to_name` varchar(80) COLLATE NOT NULL

~~ tbl_ticket_history 工单历史
    废弃(Allow Null) department_to_id
    添加 department_to_name
        `department_to_name` varchar(80) COLLATE NOT NULL ~~

tbl_partner
    添加 create_time updatea_time 列
        `create_time` datetime DEFAULT NULL,
        `update_time` datetime DEFAULT NULL,

delete table

tbl_department
    CREATE TABLE `tbl_department` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
        `desc` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
        `district_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
        `partner` int(11) DEFAULT NULL,
        `sales_depart` tinyint(1) NOT NULL,
        PRIMARY KEY (`id`),
        UNIQUE KEY `tbl_department_name_7b662728cf636fe0_uniq` (`name`,`district_code`,`partner`),
        KEY `tbl_department_c36dcfa1` (`district_code`),
        CONSTRAINT `tbl_department_district_code_18afbd7fe53563c_fk_tbl_region_code` FOREIGN KEY (`district_code`) REFERENCES `tbl_region` (`code`)
    ) ENGINE=InnoDB AUTO_INCREMENT=935 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

xnn_core_product

create table

auth_user_role
    CREATE TABLE `auth_user_role` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `delete` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8786 DEFAULT CHARSET=utf8;

tbl_permission_class
    CREATE TABLE `tbl_permission_class` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `level` int(11) NOT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `delete` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

auth_user_role
    CREATE TABLE `auth_user_role` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `delete` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8786 DEFAULT CHARSET=utf8;

tbl_station_permission
    CREATE TABLE `tbl_station_permission` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `station_id` varchar(16) NOT NULL,
    `permission_id` int(11) NOT NULL,
    `create_time` datetime NOT NULL,
    `update_time` datetime NOT NULL,
    `delete` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=191120 DEFAULT CHARSET=utf8;

modify table

auth_role
    添加 create_time updatea_time 列
        `create_time` datetime DEFAULT NULL,
        `update_time` datetime DEFAULT NULL,
    废弃(Allow Null) department_id 字段

station_user
    废弃(Allow Null) role_id 字段
    废弃(Allow Null) department_id 字段

delete table

auth_department
    CREATE TABLE `auth_department` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
    `desc` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `station_id` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=858 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;