dev/DCP版本更新/2021/待发布/SQL/2021-004-wh-001.sql

DROP TABLE IF EXISTS `meeting_geidco_leader`;
CREATE TABLE `meeting_geidco_leader` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `name` varchar(64) DEFAULT NULL COMMENT '中文名',
  `name_en` varchar(100) DEFAULT NULL COMMENT '英文名',
  `position_name` varchar(64) DEFAULT NULL COMMENT '中文职务',
  `position_name_en` varchar(64) DEFAULT NULL COMMENT '英文职务',
  `photo_url` varchar(200) DEFAULT NULL COMMENT '头像URL',
  `introduction` longtext COMMENT '中文简介',
  `introduction_en` longtext COMMENT '英文简介',
  `agree_num` int(10) DEFAULT NULL COMMENT '赞成数',
  `oppose_num` int(10) DEFAULT NULL COMMENT '反对数',
  `abstain_num` int(10) DEFAULT NULL COMMENT '弃权数',
  `create_by` varchar(64) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='geidco领导人表';

-- ----------------------------
-- Table structure for meeting_geidco_leader_num_detail
-- ----------------------------
DROP TABLE IF EXISTS `meeting_geidco_leader_num_detail`;
CREATE TABLE `meeting_geidco_leader_num_detail` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `leader_id` varchar(64) NOT NULL COMMENT '领导人ID',
  `name` varchar(64) DEFAULT NULL COMMENT '中文名',
  `position_name` varchar(64) DEFAULT NULL COMMENT '中文职务',
  `type` varchar(10) DEFAULT NULL COMMENT '类型(0:赞成,1:反对,2:弃权)',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Geidco领导人票数明细表';

-- ----------------------------
-- Table structure for meeting_geidco_matter
-- ----------------------------
DROP TABLE IF EXISTS `meeting_geidco_matter`;
CREATE TABLE `meeting_geidco_matter` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `title` varchar(64) DEFAULT NULL COMMENT '中文标题',
  `title_en` varchar(255) DEFAULT NULL COMMENT '英文标题',
  `introduction` longtext COMMENT '中文简介',
  `introduction_en` longtext COMMENT '英文简介',
  `agree_num` int(10) DEFAULT NULL COMMENT '赞成数',
  `oppose_num` int(10) DEFAULT NULL COMMENT '反对数',
  `abstain_num` int(10) DEFAULT NULL COMMENT '弃权数',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='geidco事项表';

-- ----------------------------
-- Table structure for meeting_geidco_matter_num_detail
-- ----------------------------
DROP TABLE IF EXISTS `meeting_geidco_matter_num_detail`;
CREATE TABLE `meeting_geidco_matter_num_detail` (
  `id` varchar(64) NOT NULL COMMENT '主键',
  `matter_id` varchar(64) NOT NULL COMMENT '事项ID',
  `title` varchar(64) DEFAULT NULL COMMENT '中文标题',
  `type` varchar(10) DEFAULT NULL COMMENT '类型(0:赞成,1:反对,2:弃权)',
  `create_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT NULL COMMENT '修改人',
  `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Geidco事项票数明细表';


--- 159 ， 160 已执行