111
`till` DATETIME NULL DEFAULT "2050-01-01",
INDEX `fk_dep_has_worker_dep1_idx` (`dep_id` ASC) VISIBLE,
UNIQUE INDEX `wid_UNIQUE` (`id` ASC) VISIBLE,
INDEX `fk_dep_has_worker_job1_idx` (`job_id` ASC) VISIBLE,
PRIMARY KEY (`id`),
CONSTRAINT `fk_dep_has_worker_worker1`
FOREIGN KEY (`worker_id`)
REFERENCES `kcson`.`worker` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_dep_has_worker_dep1`
FOREIGN KEY (`dep_id`)
REFERENCES `kcson`.`dep` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_dep_has_worker_job1`
FOREIGN KEY (`job_id`)
REFERENCES `kcson`.`job` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`permiss`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`permiss` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`permiss` (
`id` INT(10) UNSIGNED NOT NULL,
`perm` VARCHAR(50) NOT NULL,
`prim` VARCHAR(255) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`contracts_has_serv`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`contracts_has_serv` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`contracts_has_serv` (
`serv_id` INT UNSIGNED NOT NULL,
`contracts_id` INT UNSIGNED NOT NULL,
`planned` INT NULL,
`filled` INT NULL,
`prim` VARCHAR(255) NULL,
`archive` TINYINT NULL DEFAULT 0,
PRIMARY KEY (`serv_id`, `contracts_id`),
INDEX `fk_contracts_has_serv_contracts1_idx` (`contracts_id` ASC) VISIBLE,
CONSTRAINT `fk_contracts_has_serv_serv1`
FOREIGN KEY (`serv_id`)
REFERENCES `kcson`.`serv` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_contracts_has_serv_contracts1`
FOREIGN KEY (`contracts_id`)
REFERENCES `kcson`.`contracts` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`audit`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`audit` ;
112
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`audit` (
`id` INT NOT NULL,
`date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`action` VARCHAR(45) NULL,
`user` VARCHAR(32) NULL,
`host` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`data_log`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`data_log` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`data_log` (
`id` INT NOT NULL,
`message` VARCHAR(255) NULL,
`date` DATETIME NOT NULL,
`prim` VARCHAR(255) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`setting`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`setting` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`setting` (
`id` INT NOT NULL AUTO_INCREMENT,
`archive` TINYINT NULL DEFAULT 0,
`setting` VARCHAR(45) NULL,
`value` VARCHAR(255) NULL,
`prim` VARCHAR(255) NULL,
`sdate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`notifies`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`notifies` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`notifies` (
`id` INT NOT NULL AUTO_INCREMENT,
`active` TINYINT NULL DEFAULT 1,
`date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`msg` VARCHAR(255) NOT NULL,
`onlyFor` TINYINT NULL,
`worker_id` INT UNSIGNED NULL,
PRIMARY KEY (`id`),
INDEX `fk_notifies_worker1_idx` (`worker_id` ASC) VISIBLE,
CONSTRAINT `fk_notifies_worker1`
FOREIGN KEY (`worker_id`)
REFERENCES `kcson`.`worker` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`Rperiod`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`Rperiod` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`Rperiod` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
113
`Rperiod` VARCHAR(45) NOT NULL,
`st_mnth` INT NOT NULL,
`end_mnth` INT NOT NULL,
`st_day` INT NULL DEFAULT 0,
`end_day` INT NULL DEFAULT 0,
`prim` VARCHAR(255) NULL,
`archive` TINYINT NULL DEFAULT 0,
PRIMARY KEY (`id`),
UNIQUE INDEX `period_UNIQUE` (`Rperiod` ASC) VISIBLE)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`Rdata`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`Rdata` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`Rdata` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`saved` TINYINT NULL DEFAULT 0,
`ts` DATETIME NULL DEFAULT current_timestamp,
`year` YEAR NULL,
`uslnum` INT NULL,
`money` INT NULL,
`2ndmoney` INT NULL,
`ufio_id` INT UNSIGNED NOT NULL,
`dep_id` INT UNSIGNED NOT NULL,
`serv_id` INT UNSIGNED NOT NULL,
`worker_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
INDEX `fk_Rdata_ufio1_idx` (`ufio_id` ASC) VISIBLE,
INDEX `fk_Rdata_dep1_idx` (`dep_id` ASC) VISIBLE,
INDEX `fk_Rdata_serv1_idx` (`serv_id` ASC) VISIBLE,
INDEX `fk_Rdata_worker1_idx` (`worker_id` ASC) VISIBLE,
CONSTRAINT `fk_Rdata_ufio1`
FOREIGN KEY (`ufio_id`)
REFERENCES `kcson`.`ufio` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Rdata_dep1`
FOREIGN KEY (`dep_id`)
REFERENCES `kcson`.`dep` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Rdata_serv1`
FOREIGN KEY (`serv_id`)
REFERENCES `kcson`.`serv` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Rdata_worker1`
FOREIGN KEY (`worker_id`)
REFERENCES `kcson`.`worker` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`Rdep`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`Rdep` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`Rdep` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`saved` TINYINT NULL DEFAULT 0,
`ts` DATETIME NULL DEFAULT current_timestamp,
`year` YEAR NULL,
`uslnum` INT NULL,
114
`money` INT NULL,
`2ndmoney` INT NULL,
`peoples` INT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`Rname`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`Rname` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`Rname` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`Rname` VARCHAR(45) NULL,
`prim` VARCHAR(255) NULL,
`ts` TIMESTAMP NULL DEFAULT current_TIMESTAMP,
`cr_ts` TIMESTAMP NULL DEFAULT current_TIMESTAMP,
`scheduled` TINYINT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`RperiodsOFRname`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`RperiodsOFRname` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`RperiodsOFRname` (
`Rname_id` INT UNSIGNED NOT NULL,
`Rperiod_id` INT UNSIGNED NOT NULL,
INDEX `fk_RperiodsOFRname_Rname1_idx` (`Rname_id` ASC) VISIBLE,
PRIMARY KEY (`Rperiod_id`, `Rname_id`),
CONSTRAINT `fk_RperiodsOFRname_Rname1`
FOREIGN KEY (`Rname_id`)
REFERENCES `kcson`.`Rname` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_RperiodsOFRname_Rperiod1`
FOREIGN KEY (`Rperiod_id`)
REFERENCES `kcson`.`Rperiod` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`jobGroup`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`jobGroup` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`jobGroup` (
`id` INT NOT NULL,
`jobGroup` VARCHAR(25) NULL,
`prim` VARCHAR(45) NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`add_info`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`add_info` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`add_info` (
`pddate` DATE NOT NULL,
`contracts_id` INT UNSIGNED NOT NULL,
`predv_money` DECIMAL(10,2) NULL,
`curFIO` VARCHAR(255) NULL,
`psp` VARCHAR(255) NULL,
115
`address` VARCHAR(255) NULL,
`sdd` DECIMAL(10,2) NULL,
`perc` DOUBLE NULL,
`not_standart_contract` TINYINT NULL,
`not_standart_act` TINYINT NULL,
`prim` VARCHAR(255) NULL,
`create` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
`ts` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`cr_by` INT NULL,
`upd_by` INT NULL,
`repr_FIO` VARCHAR(255) NULL,
`repr_addr` VARCHAR(255) NULL,
`repr_psp` VARCHAR(255) NULL,
`work_livemin` TINYINT NULL DEFAULT 0,
PRIMARY KEY (`pddate`, `contracts_id`),
INDEX `fk_add_info_contracts1_idx` (`contracts_id` ASC) VISIBLE,
CONSTRAINT `fk_add_info_contracts1`
FOREIGN KEY (`contracts_id`)
REFERENCES `kcson`.`contracts` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`log_edit_archive`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`log_edit_archive` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`log_edit_archive` (
`id` INT NOT NULL AUTO_INCREMENT,
`worker_id` INT UNSIGNED NOT NULL,
`table` VARCHAR(45) NULL,
`table_id` VARCHAR(45) NULL,
`column` INT NULL,
`old_val` VARCHAR(255) NULL,
`new_val` VARCHAR(255) NULL,
`ts` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
`note` VARCHAR(255) NULL,
PRIMARY KEY (`id`),
INDEX `fk_log_edit_archive_worker1_idx` (`worker_id` ASC) VISIBLE,
CONSTRAINT `fk_log_edit_archive_worker1`
FOREIGN KEY (`worker_id`)
REFERENCES `kcson`.`worker` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`ripso_has_serv`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`ripso_has_serv` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`ripso_has_serv` (
`planned` INT NULL,
`serv_id` INT UNSIGNED NOT NULL,
`ripso_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`serv_id`, `ripso_id`),
INDEX `fk_ripso_has_serv_ripso1_idx` (`ripso_id` ASC) VISIBLE,
CONSTRAINT `fk_ripso_has_serv_serv1`
FOREIGN KEY (`serv_id`)
REFERENCES `kcson`.`serv` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ripso_has_serv_ripso1`
116
FOREIGN KEY (`ripso_id`)
REFERENCES `kcson`.`ripso` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`dep_has_ripso`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`dep_has_ripso` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`dep_has_ripso` (
`dep_id` INT UNSIGNED NOT NULL,
`ripso_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`dep_id`, `ripso_id`),
INDEX `fk_dep_has_ripso_ripso1_idx` (`ripso_id` ASC) VISIBLE,
INDEX `fk_dep_has_ripso_dep1_idx` (`dep_id` ASC) VISIBLE,
CONSTRAINT `fk_dep_has_ripso_dep1`
FOREIGN KEY (`dep_id`)
REFERENCES `kcson`.`dep` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_dep_has_ripso_ripso1`
FOREIGN KEY (`ripso_id`)
REFERENCES `kcson`.`ripso` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`job_has_jobGroup`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`job_has_jobGroup` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`job_has_jobGroup` (
`job_id` INT UNSIGNED NOT NULL,
`jobGroup_id` INT NOT NULL,
PRIMARY KEY (`job_id`, `jobGroup_id`),
INDEX `fk_job_has_jobGroup_jobGroup1_idx` (`jobGroup_id` ASC) VISIBLE,
INDEX `fk_job_has_jobGroup_job1_idx` (`job_id` ASC) VISIBLE,
CONSTRAINT `fk_job_has_jobGroup_job1`
FOREIGN KEY (`job_id`)
REFERENCES `kcson`.`job` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_job_has_jobGroup_jobGroup1`
FOREIGN KEY (`jobGroup_id`)
REFERENCES `kcson`.`jobGroup` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`roles_has_permiss`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`roles_has_permiss` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`roles_has_permiss` (
`roles_id` INT UNSIGNED NOT NULL,
`permiss_id` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`roles_id`, `permiss_id`),
INDEX `fk_roles_has_permiss_permiss1_idx` (`permiss_id` ASC) VISIBLE,
117
INDEX `fk_roles_has_permiss_roles1_idx` (`roles_id` ASC) VISIBLE,
CONSTRAINT `fk_roles_has_permiss_roles1`
FOREIGN KEY (`roles_id`)
REFERENCES `kcson`.`roles` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_roles_has_permiss_permiss1`
FOREIGN KEY (`permiss_id`)
REFERENCES `kcson`.`permiss` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`payment`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`payment` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`payment` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`ufio_id` INT UNSIGNED NOT NULL,
`paydate` DATE NULL,
`sum` DECIMAL(10,2) NULL,
`prim` VARCHAR(255) NULL,
`ts` VARCHAR(45) NULL,
PRIMARY KEY (`id`),
INDEX `fk_payment_ufio1_idx` (`ufio_id` ASC) VISIBLE,
CONSTRAINT `fk_payment_ufio1`
FOREIGN KEY (`ufio_id`)
REFERENCES `kcson`.`ufio` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`invoice`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`invoice` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`invoice` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`ufio_id` INT UNSIGNED NOT NULL,
`give_date` DATE NULL,
`money` DECIMAL(10,2) NULL,
`filled` DECIMAL(10,2) NULL,
`prim` VARCHAR(255) NULL,
`dep_id` INT UNSIGNED NOT NULL,
`create` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
`ts` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`cr_by` INT NULL,
`upd_by` INT NULL,
`dismissed` TINYINT NULL DEFAULT 0,
`pay_period_end` DATE NULL,
PRIMARY KEY (`id`),
INDEX `fk_invoice_ufio1_idx` (`ufio_id` ASC) VISIBLE,
INDEX `fk_invoice_dep1_idx` (`dep_id` ASC) VISIBLE,
CONSTRAINT `fk_invoice_ufio1`
FOREIGN KEY (`ufio_id`)
REFERENCES `kcson`.`ufio` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_invoice_dep1`
FOREIGN KEY (`dep_id`)
REFERENCES `kcson`.`dep` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
118
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`invoice_has_payment`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`invoice_has_payment` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`invoice_has_payment` (
`invoice_id` INT UNSIGNED NOT NULL,
`payment_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`invoice_id`, `payment_id`),
INDEX `fk_invoice_has_payment_payment1_idx` (`payment_id` ASC) VISIBLE,
INDEX `fk_invoice_has_payment_invoice1_idx` (`invoice_id` ASC) VISIBLE,
CONSTRAINT `fk_invoice_has_payment_invoice1`
FOREIGN KEY (`invoice_id`)
REFERENCES `kcson`.`invoice` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_invoice_has_payment_payment1`
FOREIGN KEY (`payment_id`)
REFERENCES `kcson`.`payment` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`ufio_has_category`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`ufio_has_category` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`ufio_has_category` (
`ufio_id` INT UNSIGNED NOT NULL,
`category_id` INT UNSIGNED NOT NULL,
`get_date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`archive` TINYINT NULL DEFAULT 0,
`prim` VARCHAR(255) NULL,
`create` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
`ts` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`cr_by` INT NULL,
`upd_by` INT NULL,
PRIMARY KEY (`ufio_id`, `category_id`),
INDEX `fk_ufio_has_category_category1_idx` (`category_id` ASC) VISIBLE,
INDEX `fk_ufio_has_category_ufio1_idx` (`ufio_id` ASC) VISIBLE,
CONSTRAINT `fk_ufio_has_category_ufio1`
FOREIGN KEY (`ufio_id`)
REFERENCES `kcson`.`ufio` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ufio_has_category_category1`
FOREIGN KEY (`category_id`)
REFERENCES `kcson`.`category` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`live_min`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`live_min` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`live_min` (
`id` INT NOT NULL,
`lmdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ' ',
`live_min_p` DECIMAL(10,2) NOT NULL,
`live_min_w` DECIMAL(10,2) NOT NULL,
`live_min_c` DECIMAL(10,2) NOT NULL,
119
`post` VARCHAR(45) NULL,
`post_date` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`ugroup`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`ugroup` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`ugroup` (
`id` INT NOT NULL,
`ugroup` VARCHAR(45) NOT NULL,
`dep_id` INT UNSIGNED NULL DEFAULT 0,
`worker_id` INT UNSIGNED NULL DEFAULT 0,
`prim` VARCHAR(255) NULL,
`ugroupcol` VARCHAR(45) NULL,
PRIMARY KEY (`id`),
INDEX `fk_ugroup_dep1_idx` (`dep_id` ASC) VISIBLE,
INDEX `fk_ugroup_worker1_idx` (`worker_id` ASC) VISIBLE,
CONSTRAINT `fk_ugroup_dep1`
FOREIGN KEY (`dep_id`)
REFERENCES `kcson`.`dep` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ugroup_worker1`
FOREIGN KEY (`worker_id`)
REFERENCES `kcson`.`worker` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`ugroup_has_ufio`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`ugroup_has_ufio` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`ugroup_has_ufio` (
`ugroup_id` INT NOT NULL,
`ufio_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`ugroup_id`, `ufio_id`),
INDEX `fk_ugroup_has_ufio_ufio1_idx` (`ufio_id` ASC) VISIBLE,
INDEX `fk_ugroup_has_ufio_ugroup1_idx` (`ugroup_id` ASC) VISIBLE,
CONSTRAINT `fk_ugroup_has_ufio_ugroup1`
FOREIGN KEY (`ugroup_id`)
REFERENCES `kcson`.`ugroup` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ugroup_has_ufio_ufio1`
FOREIGN KEY (`ufio_id`)
REFERENCES `kcson`.`ufio` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`main_has_ugroup`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`main_has_ugroup` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`main_has_ugroup` (
`main_id` BIGINT UNSIGNED NOT NULL,
`ugroup_id` INT NOT NULL,
PRIMARY KEY (`main_id`, `ugroup_id`),
INDEX `fk_main_has_ugroup_ugroup1_idx` (`ugroup_id` ASC) VISIBLE,
INDEX `fk_main_has_ugroup_main1_idx` (`main_id` ASC) VISIBLE,
120
CONSTRAINT `fk_main_has_ugroup_main1`
FOREIGN KEY (`main_id`)
REFERENCES `kcson`.`main` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_main_has_ugroup_ugroup1`
FOREIGN KEY (`ugroup_id`)
REFERENCES `kcson`.`ugroup` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`job_has_serv`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`job_has_serv` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`job_has_serv` (
`job_id` INT UNSIGNED NOT NULL,
`serv_id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`job_id`, `serv_id`),
INDEX `fk_job_has_serv_serv1_idx` (`serv_id` ASC) VISIBLE,
INDEX `fk_job_has_serv_job1_idx` (`job_id` ASC) VISIBLE,
CONSTRAINT `fk_job_has_serv_job1`
FOREIGN KEY (`job_id`)
REFERENCES `kcson`.`job` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_job_has_serv_serv1`
FOREIGN KEY (`serv_id`)
REFERENCES `kcson`.`serv` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
SHOW WARNINGS;
-- -----------------------------------------------------
-- Table `kcson`.`street_home`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `kcson`.`street_home` ;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `kcson`.`street_home` (
`id` INT NOT NULL,
`street_home` VARCHAR(255) NULL,
`prim` VARCHAR(255) NULL,
`create` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
`ts` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`cr_by` INT NULL,
`upd_by` INT NULL,
`coordinate` POINT NULL,
PRIMARY KEY (`id`))
ENGINE = InnoDB;
SHOW WARNINGS;
USE `kcson` ;
-- -----------------------------------------------------
-- Placeholder table for view `kcson`.`user_has_serv`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `kcson`.`user_has_serv` (`id` INT, `contracts_id` INT, `dep_id` INT, `ufio_id` INT, `serv_id` INT,
`worker_id` INT, `vdate` INT, `uslnum` INT, `note` INT, `create` INT, `ts` INT, `cr_by` INT, `upd_by` INT, `reported` INT,
`wdate` INT, `overdid` INT);
SHOW WARNINGS;
-- -----------------------------------------------------
-- Placeholder table for view `kcson`.`dep_has_main`
-- -----------------------------------------------------