forum.clarionlife.net

Код: Выделить всё

CREATE TABLE s11.Schedule_Item (
  id int(11) NOT NULL AUTO_INCREMENT,
  createDatetime datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Дата создания записи',
  createPerson_id int(11) DEFAULT NULL COMMENT 'Автор записи {Person}',
  modifyDatetime datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Дата изменения записи',
  modifyPerson_id int(11) DEFAULT NULL COMMENT 'Автор изменения записи {Person}',
  deleted tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Отметка удаления записи',
  master_id int(11) NOT NULL COMMENT 'Элемент расписания врача {Schedule}',
  idx int(11) NOT NULL DEFAULT 0 COMMENT 'Порядковый номер',
  time datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'дата и время талона',
  overtime tinyint(1) NOT NULL DEFAULT 0 COMMENT 'дополнительный приём, поставлено в очередь сверх времени',
  endOfReserve datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'дата и время окончания резерва талона',
  client_id int(11) DEFAULT NULL COMMENT 'Клиент {Client}',
  srcOrg_id int(11) DEFAULT NULL COMMENT 'Организация-направитель {Organisation}',
  srcPerson varchar(64) DEFAULT NULL COMMENT 'Врач-направитель',
  srcSpeciality_id int(11) DEFAULT NULL COMMENT 'Специальность врача {rbSpeciality}',
  srcDate date DEFAULT NULL COMMENT 'Номер направления',
  srcNumber varchar(64) DEFAULT NULL COMMENT 'Номер направления',
  recordDatetime datetime DEFAULT NULL COMMENT 'Дата и время осуществления записи пациента',
  recordPerson_id int(11) DEFAULT NULL COMMENT 'Кем осуществлена запись {Person}',
  recordClass int(11) NOT NULL DEFAULT 0 COMMENT 'Классификатор внешней записи (0-samson, 1-инфомат, 2-call-центр, 3-интернет)',
  complaint varchar(128) NOT NULL DEFAULT '' COMMENT 'Жалобы',
  note varchar(128) NOT NULL DEFAULT '' COMMENT 'Примечание',
  checked tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Есть отметка (в интерфейсе)',
  homeCallStatus int(11) NOT NULL DEFAULT 0 COMMENT 'Статус в приложении врача на дому: 0 - Ожидание, 1 - Принял, 2 - Отменен, 3 - Выполнен, 4 - Нет на месте',
  PRIMARY KEY (id),
  INDEX client_id (client_id),
  INDEX createPerson_id (createPerson_id),
  INDEX master_id (master_id, deleted),
  INDEX modifyPerson_id (modifyPerson_id),
  INDEX recordPerson_id (recordPerson_id),
  INDEX srcOrg_id (srcOrg_id),
  INDEX srcSpeciality_id (srcSpeciality_id),
  CONSTRAINT Schedule_Item_client FOREIGN KEY (client_id)
  REFERENCES s11.Client (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT Schedule_Item_createPerson FOREIGN KEY (createPerson_id)
  REFERENCES s11.Person (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT Schedule_Item_master FOREIGN KEY (master_id)
  REFERENCES s11.Schedule (id) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT Schedule_Item_modifyPerson FOREIGN KEY (modifyPerson_id)
  REFERENCES s11.Person (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT Schedule_Item_recordPerson FOREIGN KEY (recordPerson_id)
  REFERENCES s11.Person (id) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT Schedule_Item_srcOrg FOREIGN KEY (srcOrg_id)
  REFERENCES s11.Organisation (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT Schedule_Item_srcSpeciality FOREIGN KEY (srcSpeciality_id)
  REFERENCES s11.rbSpeciality (id) ON DELETE SET NULL ON UPDATE RESTRICT,
  CONSTRAINT Shedule_Item_client FOREIGN KEY (client_id)
  REFERENCES s11.Client (id) ON DELETE SET NULL ON UPDATE RESTRICT
)
ENGINE = INNODB
AUTO_INCREMENT = 1446556
AVG_ROW_LENGTH = 129
CHARACTER SET utf8
COLLATE utf8_general_ci

Код: Выделить всё

Schedule_Item   FILE,DRIVER('ODBC'),OWNER('Samson32'),NAME('Schedule_Item'),PRE(Sch2)
PRIMARY           KEY(Sch2:id),PRIMARY
Schedule_Item_createPerson KEY(Sch2:createPerson_id),DUP
Schedule_Item_modifyPerson KEY(Sch2:modifyPerson_id),DUP
Shedule_Item_client KEY(Sch2:client_id),DUP
Schedule_Item_recordPerson KEY(Sch2:recordPerson_id),DUP
KEY_master_id     KEY(Sch2:master_id,Sch2:deleted),DUP,NAME('master_id')
Schedule_Item_srcOrg KEY(Sch2:srcOrg_id),DUP
Schedule_Item_srcSpeciality KEY(Sch2:srcSpeciality_id),DUP
Schedule_Item_client KEY(Sch2:client_id),DUP
Schedule_Item_master KEY(Sch2:master_id),DUP
record            RECORD
id                  LONG
createDatetime      STRING(8)
createDatetime_GROUP  GROUP,OVER(createDatetime)
createDatetime_DATE     DATE
createDatetime_TIME     TIME
                      END
createPerson_id     LONG,NAME('`createPerson_id`')
modifyDatetime      STRING(8)
modifyDatetime_GROUP  GROUP,OVER(modifyDatetime)
modifyDatetime_DATE     DATE
modifyDatetime_TIME     TIME
                      END
modifyPerson_id     LONG,NAME('`modifyPerson_id`')
deleted             BYTE
master_id           LONG,NAME('`master_id`')
idx                 LONG
time                STRING(8)
time_GROUP          GROUP,OVER(time)
time_DATE             DATE
time_TIME             TIME
                    END
overtime            BYTE
endOfReserve        STRING(8)
endOfReserve_GROUP  GROUP,OVER(endOfReserve)
endOfReserve_DATE     DATE
endOfReserve_TIME     TIME
                    END
client_id           LONG,NAME('`client_id`')
srcOrg_id           LONG,NAME('`srcOrg_id`')
srcPerson           CSTRING(65)
srcSpeciality_id    LONG,NAME('`srcSpeciality_id`')
srcDate             DATE
srcNumber           CSTRING(65)
recordDatetime      STRING(8)
recordDatetime_GROUP  GROUP,OVER(recordDatetime)
recordDatetime_DATE     DATE
recordDatetime_TIME     TIME
                      END
recordPerson_id     LONG,NAME('`recordPerson_id`')
recordClass         LONG
complaint           CSTRING(129)
note                CSTRING(129)
checked             BYTE
homeCallStatus      LONG
                  END
                END