/*
Target Server Type : MySQL
Target Server Version : 50635
File Encoding : 65001
Comment ：用于存储用户在选中权限后 用案件id和团队id进行关联
Date: 03/04/2018 12:06:23
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_coa_case_label
-- ----------------------------
DROP TABLE IF EXISTS `t_coa_case_archive_auth`;
CREATE TABLE `t_coa_case_archive_auth` (
id INT ( 11 ) PRIMARY KEY auto_increment COMMENT "设置主键自增",
case_id INT ( 11 ) NOT NULL COMMENT "归档案件id",
team_id INT ( 11 ) NOT NULL COMMENT "选中后所赋予权限的团队id",
create_by INT ( 11 ) DEFAULT NULL COMMENT "创建记录的用户id",
create_time TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT "创建时间戳",
update_by INT ( 11 ) DEFAULT NULL COMMENT "更新记录的用户id",
update_time TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT "更新时间戳"
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '案件归档权限表' ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;