-- -----------------------------------------------------
-- Table `CLASS_TREE`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CLASS_TREE` (
`CLASS_CODE` VARCHAR(10) NOT NULL COMMENT '分类内部码' ,
`EN_NAME` VARCHAR(80) NOT NULL COMMENT '分类英文名' ,
`CN_NAME` VARCHAR(240) NULL DEFAULT NULL COMMENT '分类中文名' ,
`DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL COMMENT '分类描述' ,
`PARENT_CLASS_CODE` VARCHAR(10) NULL DEFAULT NULL COMMENT '上级分类' ,
`TREE_PATH` VARCHAR(3000) NOT NULL COMMENT '完整类路径' ,
`USE_FLG` TINYINT(2) NOT NULL DEFAULT '1' COMMENT '启用标志' ,
`CREATE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间' ,
`CHANGE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '最近修改时间' ,
PRIMARY KEY (`CLASS_CODE`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = '分类树形表';
-- -----------------------------------------------------
-- Table `CONFIG_ITEM`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CONFIG_ITEM` (
`CI_ID` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'CI唯一ID' ,
`CI_CODE` VARCHAR(60) NOT NULL COMMENT 'CI标识码' ,
`CLASS_CODE` VARCHAR(10) NOT NULL COMMENT '分类内部码' ,
`EN_NAME` VARCHAR(80) NOT NULL COMMENT 'CI英文名' ,
`CN_NAME` VARCHAR(240) NULL DEFAULT NULL COMMENT 'CI中文名' ,
`DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL COMMENT 'CI描述' ,
`ICON_URL` VARCHAR(1200) NULL DEFAULT NULL COMMENT '图标地址' ,
`STATE` VARCHAR(255) NOT NULL DEFAULT 'UNKNOWN' COMMENT '当前状态' ,
`CREATE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间' ,
`CHANGE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '最近修改时间' ,
PRIMARY KEY (`CI_ID`) ,
UNIQUE INDEX `UNI_CONFIG_ITEM` (`CI_CODE` ASC, `CLASS_CODE` ASC) ,
INDEX `FK_CONFIG_ITEM_idx` (`CLASS_CODE` ASC) ,
CONSTRAINT `FK_CONFIG_ITEM`
FOREIGN KEY (`CLASS_CODE` )
REFERENCES `CLASS_TREE` (`CLASS_CODE` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = '配置项表';
-- -----------------------------------------------------
-- Table `CI_BASELINE_SNAPSHOT`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CI_BASELINE_SNAPSHOT` (
`CI_ID` INT(10) NOT NULL COMMENT 'CI唯一ID' ,
`CREATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间' ,
`SNAPSHOT` TEXT NULL DEFAULT NULL COMMENT '原版快照' ,
PRIMARY KEY (`CI_ID`, `CREATE_TIME`) ,
INDEX `FK_CI_BASELINE_SNAPSHOT_idx` (`CI_ID` ASC) ,
CONSTRAINT `FK_CI_BASELINE_SNAPSHOT`
FOREIGN KEY (`CI_ID` )
REFERENCES `CONFIG_ITEM` (`CI_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'CI基线快照表';
-- -----------------------------------------------------
-- Table `CONSTRAINT_TYPE`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CONSTRAINT_TYPE` (
`ID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '约束自增ID' ,
`CONSTRAINT_NAME` VARCHAR(240) NOT NULL COMMENT '约束名' ,
`DATA_TYPE` VARCHAR(10) NOT NULL DEFAULT 'STRING' COMMENT '数据类型' ,
`DATA_MAX_LENGTH` INT(8) NULL DEFAULT NULL COMMENT '数据最大长度' ,
`DATA_NUM_UNIT` VARCHAR(255) NULL DEFAULT NULL COMMENT '数值型数据单位' ,
`INPUT_TYPE` VARCHAR(10) NOT NULL DEFAULT 'TEXT' COMMENT '输入方式' ,
`INPUT_SELECT_WORDBOOK` VARCHAR(255) NULL DEFAULT NULL COMMENT '选择型输入关联字典' ,
`DEMO` VARCHAR(1200) NULL DEFAULT NULL COMMENT '填写示例' ,
PRIMARY KEY (`ID`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = '约束类型表';
-- -----------------------------------------------------
-- Table `PROPERTY_POOL`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `PROPERTY_POOL` (
`ID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '属性自增ID' ,
`EN_NAME` VARCHAR(80) NOT NULL COMMENT '属性英文名' ,
`CN_NAME` VARCHAR(240) NULL DEFAULT NULL COMMENT '属性中文名' ,
`DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL COMMENT '属性描述' ,
`CONSTRAINT_ID` INT(10) NULL DEFAULT NULL COMMENT '约束ID' ,
`USE_FLG` TINYINT(2) NOT NULL DEFAULT '1' COMMENT '启用标志' ,
`PUBLIC_FLG` TINYINT(2) NOT NULL DEFAULT '-1' COMMENT '公用标志' ,
`CREATE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间' ,
`CHANGE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '最近修改时间' ,
PRIMARY KEY (`ID`) ,
INDEX `FK_CONSTRAINT_TYPE_idx` (`CONSTRAINT_ID` ASC) ,
CONSTRAINT `FK_CONSTRAINT_TYPE`
FOREIGN KEY (`CONSTRAINT_ID` )
REFERENCES `CONSTRAINT_TYPE` (`ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = '属性池定义表';
-- -----------------------------------------------------
-- Table `CI_PROPERTY_VALUE`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CI_PROPERTY_VALUE` (
`CI_ID` INT(10) NOT NULL COMMENT 'CI唯一ID' ,
`PROPERTY_ID` INT(10) NOT NULL COMMENT '属性ID' ,
`VALUE` VARCHAR(3000) NULL DEFAULT NULL COMMENT '对应值' ,
PRIMARY KEY (`CI_ID`, `PROPERTY_ID`) ,
INDEX `FK_CI_PROPERTY_VALUE_idx` (`CI_ID` ASC) ,
INDEX `FK_CI_PROPERTY_VALUE2_idx` (`PROPERTY_ID` ASC) ,
CONSTRAINT `FK_CI_PROPERTY_VALUE`
FOREIGN KEY (`CI_ID` )
REFERENCES `CONFIG_ITEM` (`CI_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FK_CI_PROPERTY_VALUE2`
FOREIGN KEY (`PROPERTY_ID` )
REFERENCES `PROPERTY_POOL` (`ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'CI属性对应值表';
-- -----------------------------------------------------
-- Table `CI_RELATIONSHIP`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CI_RELATIONSHIP` (
`ID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '关系自增ID' ,
`CI_FROM_ID` INT(10) NOT NULL COMMENT '来源CI唯一ID' ,
`CI_TO_ID` INT(10) NOT NULL COMMENT '目标CI唯一ID' ,
`RL_TYPE` VARCHAR(255) NOT NULL COMMENT '关系类型' ,
`DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL COMMENT '关系描述' ,
`CREATE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '创建时间' ,
`CHANGE_TIME` TIMESTAMP NULL DEFAULT NULL COMMENT '最近修改时间' ,
PRIMARY KEY (`ID`) ,
UNIQUE INDEX `UNI_CI_RELATIONSHIP` (`CI_FROM_ID` ASC, `CI_TO_ID` ASC) ,
INDEX `FK_CI_RELATIONSHIP_idx` (`CI_FROM_ID` ASC) ,
INDEX `FK_CI_RELATIONSHIP2_idx` (`CI_TO_ID` ASC) ,
CONSTRAINT `FK_CI_RELATIONSHIP`
FOREIGN KEY (`CI_FROM_ID` )
REFERENCES `CONFIG_ITEM` (`CI_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FK_CI_RELATIONSHIP2`
FOREIGN KEY (`CI_TO_ID` )
REFERENCES `CONFIG_ITEM` (`CI_ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = 'CI关系结构表';
-- -----------------------------------------------------
-- Table `CLASS_PROPERTY_REL`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CLASS_PROPERTY_REL` (
`CLASS_CODE` VARCHAR(10) NOT NULL COMMENT '分类内部码' ,
`PROPERTY_ID` INT(10) NOT NULL COMMENT '属性ID' ,
PRIMARY KEY (`CLASS_CODE`, `PROPERTY_ID`) ,
INDEX `FK_CLASS_PROPERTY_REL_idx` (`CLASS_CODE` ASC) ,
INDEX `FK_CLASS_PROPERTY_REL2_idx` (`PROPERTY_ID` ASC) ,
CONSTRAINT `FK_CLASS_PROPERTY_REL`
FOREIGN KEY (`CLASS_CODE` )
REFERENCES `CLASS_TREE` (`CLASS_CODE` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `FK_CLASS_PROPERTY_REL2`
FOREIGN KEY (`PROPERTY_ID` )
REFERENCES `PROPERTY_POOL` (`ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = '分类属性关联表';
-- -----------------------------------------------------
-- Table `SYS_WORDBOOK`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `SYS_WORDBOOK` (
`TYPE` VARCHAR(255) NOT NULL COMMENT '类型编码' ,
`TYPE_NAME` VARCHAR(255) NULL DEFAULT NULL COMMENT '类型名称' ,
`CODE` VARCHAR(255) NOT NULL COMMENT '条目编码' ,
`CODE_VALUE` VARCHAR(255) NULL DEFAULT NULL COMMENT '条目编码对应值' ,
`PARENT_CODE` VARCHAR(255) NULL DEFAULT NULL COMMENT '关联父条目' ,
`EDIT_FLG` TINYINT(2) NULL DEFAULT '-1' COMMENT '允许编辑标志' ,
`REMARK` VARCHAR(1200) NULL DEFAULT NULL COMMENT '备注' ,
PRIMARY KEY (`TYPE`, `CODE`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COMMENT = '系统数据字典';