CHARACTER SET WIN1251, _FABR_NUM VARCHAR (700 ) CHARACTER SET WIN1251, _GOD_VYPUSKA DATE, _DATA_VVODA DATE, _STATE VARCHAR (15) CHARACTER SET WIN1251 DEFAULT «НІ» COLLATE WIN1251, _MESTO INTEGER, _PRICE DECIMAL (7,2), _MOL INTEGER, _SCHET VARCHAR (100) CHARACTER SET WIN1251 NOT NULL COLLATE WIN1251); TABLE ORD_POSTIONS (_NAME VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _TYPE INTEGER, _PRICE NUMERIC (7,2), _COUNT INTEGER, _ORDNUM INTEGER); TABLE ORDERS (_ID INTEGER NOT NULL, _DATE DATE, _SUMMA DECIMAL (7,2), _MOL INTEGER, _STATUS INTEGER); TABLE PROPERTIES (_ID INTEGER NOT NULL, _PROPS VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _VALUE VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _OBJ INTEGER); TABLE SCH_POSITION ( _NAME VARCHAR (50) CHARACTER SET WIN1251 NOT NULL COLLATE WIN1251, _EDIZ VARCHAR (10) CHARACTER SET WIN1251 COLLATE WIN1251, _COUNT INTEGER, _PRICE DECIMAL (7,2), _SCHID BIGINT); TABLE SCHETA (_ID BIGINT NOT NULL,
S_NUMBER VARCHAR (200) CHARACTER SET WIN1251 COLLATE WIN1251,
S_DATE DATE, _SUMMA DECIMAL (7,2), _IDSELLER INTEGER, _IDORDER INTEGER, _O_ID INTEGER NOT NULL); TABLE SELLERS (_ID INTEGER NOT NULL, _NAME VARCHAR (100) CHARACTER SET WIN1251 COLLATE WIN1251, _ADDRESS VARCHAR (512) CHARACTER SET WIN1251 COLLATE WIN1251, _TELEFON VARCHAR (112) CHARACTER SET WIN1251 COLLATE WIN1251, _FAX VARCHAR (112) CHARACTER SET WIN1251 COLLATE WIN1251, _EMAIL VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _REKVIZITS BLOB SUB_TYPE 1 SEGMENT SIZE 512 CHARACTER SET WIN1251 COLLATE WIN1251); TABLE SPISANIE (_ID BIGINT NOT NULL, _DATE DATE, _PRICHINA VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _OBJID INTEGER); TABLE «TYPE» (_ID INTEGER NOT NULL, _NAME VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _YEAR_EKSPL SMALLINT, _MONTH_EKSPL SMALLINT); TABLE ZAPCHASTI (_ID BIGINT NOT NULL, _NAME VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _OPISANIE BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET WIN1251 COLLATE WIN1251, _STATUS VARCHAR (50) CHARACTER SET WIN1251 COLLATE WIN1251, _SCHID BIGINT); TABLE ZIP_OBJ (_ID BIGINT, _ID INTEGER);
ALTER TABLE KABINETS ADD CONSTRAINT PK_KABINETS PRIMARY KEY (K_ID); TABLE MOL ADD CONSTRAINT PK_MOL PRIMARY KEY (M_ID); TABLE OBJECTS ADD CONSTRAINT PK_OBJECTS PRIMARY KEY (O_ID); TABLE ORDERS ADD CONSTRAINT PK_ORDERS PRIMARY KEY ( OR_ID); TABLE PROPERTIES ADD CONSTRAINT PK_PROPERTIES PRIMARY KEY (P_ID); TABLE SCHETA ADD CONSTRAINT PK_SCHETA PRIMARY KEY (S_ID); TABLE SELLERS ADD CONSTRAINT PK_SELLERS PRIMARY KEY (SL_ID); TABLE SPISANIE ADD CONSTRAINT PK_SPISANIE PRIMARY KEY (SP_ID); TABLE « TYPE » ADD CONSTRAINT PK_TYPE PRIMARY KEY (T_ID); TABLE ZAPCHASTI ADD CONSTRAINT PK_ZAPCHASTI PRIMARY KEY (Z_ID); TABLE MOL ADD CONSTRAINT FK_MOL_1 FOREIGN KEY (M_KABINET) REFERENCES KABINETS (K_ID) ON UPDATE CASCADE; TABLE MOVE ADD CONSTRAINT FK_MOVE_1 FOREIGN KEY (MO_ID_OBJ) REFERENCES OBJECTS (O_ID) ON UPDATE CASCADE; TABLE MOVE ADD CONSTRAINT FK_MOVE_2 FOREIGN KEY (MO_FROM) REFERENCES KABINETS (K_ID) ON UPDATE CASCADE; TABLE MOVE ADD CONSTRAINT FK_MOVE_3 FOREIGN KEY (MO_TO) REFERENCES KABINETS (K_ID) ON UPDATE CASCADE; TABLE OBJECTS ADD CONSTRAINT FK_OBJECTS_1 FOREIGN KEY (O_TYPE) REFERENCES «TYPE» (T_ID) ON UPDATE CASCADE;
ALTER TABLE OBJECTS ADD CONSTRAINT FK_OBJECTS_2 FOREIGN KEY (O_MESTO) REFERENCES KABINETS (K_ID);
ALTER TABLE OBJECTS A...
