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

Скачать

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

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

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

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