SILAGE

"localhost:/firebird/data/ILICHEVSK2.FDB". ��

SILAGE

��

(�� SILAGE)

��

��	��	��	��
SILAGEID	DINTEGER	INTEGER
SILAGEPACKID	DINTEGER	INTEGER
NAME		VARCHAR(30)
INCOMEPRIORIRY	DINTEGER	INTEGER
OUTCOMEPRIORITY	DINTEGER	INTEGER
X	DINTEGER	INTEGER
Y	DINTEGER	INTEGER
IMAGE	DINTEGER	INTEGER
FULLWEIGHT	DWEIGHT	INTEGER
MAXWEIGHT	DWEIGHT	INTEGER
INVENTORYID	DINTEGER	INTEGER
WEIGHT	DINTEGER	INTEGER
BRUSHCOLOR	DVARCHAR20	VARCHAR(20)	��

��

��	��	��	��
SILAGE_CalcSilagePacksWeight	AFTER UPDATE	Yes	2
SILAGE_SETINVENTORYID	BEFORE UPDATE	Yes	0
SILAGE_SetID	BEFORE INSERT	Yes	0
SILAGE_UpdateSilageGroupWeight	AFTER UPDATE	Yes	1

��

��	��	��	��	��
FK_SILAGE_SILAGEPACKID	SILAGEPACKID			ASC

��

��	��	��	��	��	��
SILAGEPACKS	FK_SILAGE_SILAGEPACKID	SILAGEPACKID	SILAGEPACKID	CASCADE	NO ACTION

��

(�� , �� SILAGE)

��

CREATE TABLE SILAGE (
    SILAGEID         DINTEGER NOT NULL,
    SILAGEPACKID     DINTEGER,
    NAME             VARCHAR(30),
    INCOMEPRIORIRY   DINTEGER,
    OUTCOMEPRIORITY  DINTEGER,
    X                DINTEGER,
    Y                DINTEGER,
    IMAGE            DINTEGER,
    FULLWEIGHT       DWEIGHT,
    MAXWEIGHT        DWEIGHT,
    INVENTORYID      DINTEGER,
    WEIGHT           DINTEGER,
    BRUSHCOLOR       DVARCHAR20 COLLATE WIN1251_UA
);


ALTER TABLE SILAGE ADD PRIMARY KEY (SILAGEID);
ALTER TABLE SILAGE ADD CONSTRAINT FK_SILAGE_SILAGEPACKID FOREIGN KEY (SILAGEPACKID) REFERENCES SILAGEPACKS (SILAGEPACKID) ON DELETE CASCADE;