"localhost:/firebird/data/ILICHEVSK2.FDB". Таблицы

QUALITY

Описание

Качетво (базовое)

Поля

Триггеры

Индексы

Ссылается на

Ссылающиеся

(Нет таблиц, использующих таблицу QUALITY)

Определение

CREATE TABLE QUALITY (
    QUALITYID                DINTEGER NOT NULL,
    PARTYID                  DINTEGER,
    CROPID                   DINTEGER,
    CLASSID                  DINTEGER,
    SORTID                   DINTEGER,
    ANALYSISDATE             DDATE,
    SAMPLINGDATE             DDATE,
    CREATETIME               DTIMESTAMP,
    USERID                   DINTEGER,
    QUALITYHUMIDITYID        DINTEGER,
    GMONUMBER                DVARCHAR30 COLLATE WIN1251_UA,
    GMODATE                  DDATE,
    SNNUMBER                 DVARCHAR30 COLLATE WIN1251_UA,
    SNDATE                   DDATE,
    GMOID                    DINTEGER,
    SNID                     DINTEGER,
    QUALITYACIDNUMBERID      DINTEGER,
    QUALITYPEROXIDENUMBERID  DINTEGER
);


ALTER TABLE QUALITY ADD CONSTRAINT QUALITY_CHK_SORT check ((quality.sortid is null) or ((select cropsort.cropid from cropsort where quality.sortid = cropsort.sortid) = quality.cropid));
ALTER TABLE QUALITY ADD CONSTRAINT QUALITY_CHK_CLASS check ((quality.classid is null) or ((select class.cropid from class where quality.classid = class.classid) = quality.cropid));
ALTER TABLE QUALITY ADD PRIMARY KEY (QUALITYID);
ALTER TABLE QUALITY ADD CONSTRAINT FK_QUALITY_1 FOREIGN KEY (GMOID) REFERENCES SERTIFICATES (SERTIFICATEID);
ALTER TABLE QUALITY ADD CONSTRAINT FK_QUALITY_2 FOREIGN KEY (SNID) REFERENCES SERTIFICATES (SERTIFICATEID);