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

ITTRANSPORT

Описание

(Нет описания для таблицы ITTRANSPORT)

Поля

Триггеры

Индексы

Ссылается на

(Нет таблиц, используемых таблицей ITTRANSPORT)

Ссылающиеся

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

Определение

CREATE TABLE ITTRANSPORT (
    INVENTORYID        DINVENTORYID NOT NULL,
    BARCODE            DSHORTNAME COLLATE WIN1251_UA,
    CAPACITYWEIGHT     DWEIGHT,
    CAPACITYVOLUME     DINTEGER,
    SAMPLERINDATE      DDATE,
    SAMPLERINTIME      DTIME,
    SAMPLEROUTDATE     DDATE,
    SAMPLEROUTTIME     DTIME,
    TAREBYHAND         DSMALLINT,
    GROSSBYHAND        DSMALLINT,
    LOADTIME           DTIMESTAMP,
    TRANSPORTTYPEID    DTRANSPORTTYPEID,
    TRANSPORTNUMBER    DSHORTNAME COLLATE WIN1251_UA,
    CHECKPOINTINTIME   DTIMESTAMP,
    CHECKPOINTOUTTIME  DTIMESTAMP,
    WEIGHTSESSION      DINTEGER,
    INVOICEGROSS       DWEIGHT,
    INVOICETARE        DWEIGHT,
    INVOICENET         DWEIGHT,
    SENDERQUALITYID    DQUALITYID,
    OWNERFIELDID       DINTEGER,
    OWNERSTORAGEID     DINTEGER,
    BUNKERS            DECIMAL(2,1),
    GRAINFIELDOUTTIME  DTIMESTAMP,
    CHECKPOINTSESSION  DINTEGER,
    SAMPLERSESSION     DINTEGER,
    HUMWEIGHT          DWEIGHT,
    DIRTWEIGHT         DWEIGHT,
    SCREENWEIGHT       DWEIGHT,
    SAMPLERWEIGHT      INTEGER,
    PREANALYSISTIME    TIMESTAMP,
    DISPATCHINGTIME    TIMESTAMP
);


ALTER TABLE ITTRANSPORT ADD CONSTRAINT PK_ITTRANSPORT PRIMARY KEY (INVENTORYID);
CREATE INDEX ITTRANSPORT_CHECKPOINTINTIME ON ITTRANSPORT (CHECKPOINTINTIME);
CREATE INDEX ITTRANSPORT_DISPATCHINGTIME ON ITTRANSPORT (DISPATCHINGTIME);
CREATE INDEX ITTRANSPORT_SAMPLERINDATE ON ITTRANSPORT (SAMPLERINDATE);
CREATE INDEX ITTRANSPORT_SAMPLERINDATE_IDX ON ITTRANSPORT (SAMPLERINDATE);
CREATE INDEX ITTRANSPORT_SAMPLEROUTDATE ON ITTRANSPORT (SAMPLEROUTDATE);
CREATE INDEX ITTRANSPORT_TRANSPORTTYPEID ON ITTRANSPORT (TRANSPORTTYPEID);
CREATE INDEX ITTRANSPORT_WEIGHTSESSION ON ITTRANSPORT (WEIGHTSESSION);