-- MySQL Script generated by MySQL Workbench
-- 2020年12月05日 星期六 22时38分09秒
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Table `id_card_decode`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `id_card_decode` ;

CREATE TABLE IF NOT EXISTS `id_card_decode` (
  `id` BIGINT ZEROFILL NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(64) NULL,
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`))
COMMENT = '身份证号解码';


-- -----------------------------------------------------
-- Table `custom_process_base`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `custom_process_base` ;

CREATE TABLE IF NOT EXISTS `custom_process_base` (
  `id` BIGINT ZEROFILL NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` VARCHAR(64) NOT NULL COMMENT '名称',
  `create_time` DATETIME NULL COMMENT '创建时间',
  `update_time` DATETIME NULL COMMENT '更新时间',
  `from_url` VARCHAR(512) NULL COMMENT '来源',
  `to_url` VARCHAR(512) NULL COMMENT '去向',
  PRIMARY KEY (`id`))
COMMENT = '基础流程';


-- -----------------------------------------------------
-- Table `user`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `user` ;

CREATE TABLE IF NOT EXISTS `user` (
  `id` BIGINT NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(16) NOT NULL,
  `email` VARCHAR(255) NULL,
  `password` VARCHAR(32) NULL,
  `create_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`))
COMMENT = '人员';


-- -----------------------------------------------------
-- Table `machine`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `machine` ;

CREATE TABLE IF NOT EXISTS `machine` (
  `id` BIGINT ZEROFILL NOT NULL,
  `name` VARCHAR(64) NOT NULL,
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`))
COMMENT = '机器设备';


-- -----------------------------------------------------
-- Table `goods`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `goods` ;

CREATE TABLE IF NOT EXISTS `goods` (
  `id` BIGINT ZEROFILL NOT NULL,
  `name` VARCHAR(64) NOT NULL,
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`))
COMMENT = '物资物料';


-- -----------------------------------------------------
-- Table `environment`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `environment` ;

CREATE TABLE IF NOT EXISTS `environment` (
  `id` BIGINT ZEROFILL NOT NULL,
  `name` VARCHAR(64) NOT NULL,
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`))
COMMENT = '环境';


-- -----------------------------------------------------
-- Table `custom_process_base_user_rel`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `custom_process_base_user_rel` ;

CREATE TABLE IF NOT EXISTS `custom_process_base_user_rel` (
  `base_id` BIGINT ZEROFILL NOT NULL,
  `user_id` BIGINT NOT NULL,
  PRIMARY KEY (`base_id`, `user_id`),
  INDEX `fk_custom_process_base_has_user_user1_idx` (`user_id` ASC) VISIBLE,
  INDEX `fk_custom_process_base_has_user_custom_process_base1_idx` (`base_id` ASC) VISIBLE,
  CONSTRAINT `fk_custom_process_base_has_user_custom_process_base1`
    FOREIGN KEY (`base_id`)
    REFERENCES `custom_process_base` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_custom_process_base_has_user_user1`
    FOREIGN KEY (`user_id`)
    REFERENCES `user` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


-- -----------------------------------------------------
-- Table `custom_process_base_machine_rel`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `custom_process_base_machine_rel` ;

CREATE TABLE IF NOT EXISTS `custom_process_base_machine_rel` (
  `base_id` BIGINT ZEROFILL NOT NULL,
  `machine_id` BIGINT ZEROFILL NOT NULL,
  PRIMARY KEY (`base_id`, `machine_id`),
  INDEX `fk_custom_process_base_has_machine_machine1_idx` (`machine_id` ASC) VISIBLE,
  INDEX `fk_custom_process_base_has_machine_custom_process_base1_idx` (`base_id` ASC) VISIBLE,
  CONSTRAINT `fk_custom_process_base_has_machine_custom_process_base1`
    FOREIGN KEY (`base_id`)
    REFERENCES `custom_process_base` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_custom_process_base_has_machine_machine1`
    FOREIGN KEY (`machine_id`)
    REFERENCES `machine` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


-- -----------------------------------------------------
-- Table `custom_process_base_goods_rel`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `custom_process_base_goods_rel` ;

CREATE TABLE IF NOT EXISTS `custom_process_base_goods_rel` (
  `base_id` BIGINT ZEROFILL NOT NULL,
  `goods_id` BIGINT ZEROFILL NOT NULL,
  PRIMARY KEY (`base_id`, `goods_id`),
  INDEX `fk_custom_process_base_has_goods_goods1_idx` (`goods_id` ASC) VISIBLE,
  INDEX `fk_custom_process_base_has_goods_custom_process_base1_idx` (`base_id` ASC) VISIBLE,
  CONSTRAINT `fk_custom_process_base_has_goods_custom_process_base1`
    FOREIGN KEY (`base_id`)
    REFERENCES `custom_process_base` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_custom_process_base_has_goods_goods1`
    FOREIGN KEY (`goods_id`)
    REFERENCES `goods` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


-- -----------------------------------------------------
-- Table `custom_process_base_environment_rel`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `custom_process_base_environment_rel` ;

CREATE TABLE IF NOT EXISTS `custom_process_base_environment_rel` (
  `environment_id` BIGINT ZEROFILL NOT NULL,
  `base_id` BIGINT ZEROFILL NOT NULL,
  PRIMARY KEY (`environment_id`, `base_id`),
  INDEX `fk_environment_has_custom_process_base_custom_process_base1_idx` (`base_id` ASC) VISIBLE,
  INDEX `fk_environment_has_custom_process_base_environment1_idx` (`environment_id` ASC) VISIBLE,
  CONSTRAINT `fk_environment_has_custom_process_base_environment1`
    FOREIGN KEY (`environment_id`)
    REFERENCES `environment` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_environment_has_custom_process_base_custom_process_base1`
    FOREIGN KEY (`base_id`)
    REFERENCES `custom_process_base` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);


-- -----------------------------------------------------
-- Table `id_card`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `id_card` ;

CREATE TABLE IF NOT EXISTS `id_card` (
  `type` TINYINT(2) ZEROFILL NOT NULL COMMENT '类型',
  `id` BIGINT ZEROFILL NOT NULL COMMENT '对应表的id',
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  `id1` VARCHAR(8) NULL,
  `id2` VARCHAR(8) NULL,
  `id3` VARCHAR(8) NULL,
  `id4` VARCHAR(8) NULL,
  `id5` VARCHAR(8) NULL,
  `id6` VARCHAR(8) NULL,
  `id7` VARCHAR(8) NULL,
  `id8` VARCHAR(8) NULL,
  PRIMARY KEY (`id`, `type`))
COMMENT = '身份证号';


-- -----------------------------------------------------
-- Table `template`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `template` ;

CREATE TABLE IF NOT EXISTS `template` (
  `id` BIGINT ZEROFILL NOT NULL,
  `name` VARCHAR(64) NOT NULL,
  `create_time` DATETIME NULL,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`id`))
COMMENT = '流程图';


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;