Дипломная работа: Автоматизация учета предоставленных услуг в комплексном центре социального обслуживания населения и анализа данных на примере СПБ ГБУСОН "КЦСОН Адмиралтейского района Санкт-Петербурга"

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
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`
-- -----------------------------------------------------
Источник: https://baza.diplomsite.ru/previewfile/2412

Смотрите также:

_1966(~1
_Антонян Ю.М., Сексуальные преступления. Чикатило и другие
_РГР № 1 (2)
- Габариты и масса 27
'Образ–Я' и его развитие средствами диалога
"Логистическая технология JIT"
"Особенности правовой системы Российской Федерации" по дисциплине "Теория государства и права"
«Анализ ликвидности и платежеспособности предприятия» (на материалах ОАО Московская кондитерская фабрика «Красный Октябрь»)