OPERATION

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

OPERATION

��

�� , ��, � ��

��

��	��	��	��
OPERATIONID	DINTEGER	INTEGER	��
OPERATIONNAME		VARCHAR(30)	��
OPERATIONFULLNAME	DNAMEMIDDLE	VARCHAR(50)	��
OPERATIONTYPE	DINTEGER	INTEGER	-1 - �� 0 - �� 1 - �� 2 - �� 3 - �� 4 - �� 5 - �� 6 - �� 7 - ��
OPERATIONSUBTYPE	DINTEGER	INTEGER	-1 - �� 0 - �� 1 - �� 2 - �� 3 - �� 4 - �� 5 - �� 6 - �� 7 - ��

��

��	��	��	��	��
OPERATIONS_SetID	BEFORE INSERT	Yes	0

��

(�� OPERATION)

��

(�� , �� OPERATION)

��

��	��	��	��	��	��
IT	IT_FK_OPERATIONID	OPERATIONID	OPERATIONID	CASCADE	CASCADE

��

CREATE TABLE OPERATION (
    OPERATIONID        DINTEGER NOT NULL,
    OPERATIONNAME      VARCHAR(30),
    OPERATIONFULLNAME  DNAMEMIDDLE,
    OPERATIONTYPE      DINTEGER,
    OPERATIONSUBTYPE   DINTEGER NOT NULL
);


ALTER TABLE OPERATION ADD PRIMARY KEY (OPERATIONID);