post_no ASC, inv_numb ASC); TABLE InstrymentuCONSTRAINT XPKІнструменти PRIMARY KEY (nom_post, post_no, inv_numb); TABLE Klientu
(CHAR (18) NULL, _gor VARCHAR2 (20) NULL, _zak INTEGER NOT NULL, INTEGER NULL, _pay INTEGER NOT NULL
); UNIQUE INDEX XPKКліенти ON Klientu
(pay_zak ASC, date_pay ASC); TABLE KlientuCONSTRAINT XPKКліенти PRIMARY KEY (pay_zak, date_pay); TABLE Kyrjeru
(_svob INTEGER NULL, _pole INTEGER NULL, INTEGER NULL, _post INTEGER NOT NULL, _no INTEGER NOT NULL, _numb INTEGER NOT NULL
); UNIQUE INDEX XPKКурьери ON Kyrjeru
(nom_post ASC, post_no ASC, inv_numb ASC); TABLE KyrjeruCONSTRAINT XPKКурьери PRIMARY KEY (nom_post, post_no, inv_numb); TABLE Postavka
(_gr INTEGER NULL, _post INTEGER NULL, _post INTEGER NOT NULL, _no INTEGER NOT NULL
); UNIQUE INDEX XPKПоставка ON Postavka
(nom_post ASC, post_no ASC); TABLE PostavkaCONSTRAINT XPKПоставка PRIMARY KEY (nom_post, post_no); TABLE Postavshiki
(_no INTEGER NOT NULL, VARCHAR2 (20) NULL, _firm_post VARCHAR2 (20) NULL, _dov INTEGER NULL
); UNIQUE INDEX XPKПоставщікі ON Postavshiki
(post_no ASC); TABLE PostavshikiCONSTRAINT XPKПоставщікі PRIMARY KEY (post_no); TABLE Sklad
(_skl INTEGER NULL, _skl_dyx INTEGER NULL, _zap_bara INTEGER NULL, _skl_str INTEGER NULL, _post INTEGER NOT NULL, _no INTEGER NOT NULL, _numb INTEGER NOT NULL
); UNIQUE INDEX XPKСклад ON Sklad
(nom_post ASC, post_no ASC, inv_numb ASC); TABLE SkladCONSTRAINT XPKСклад PRIMARY KEY (nom_post, post_no, inv_numb); TABLE Strynnue
(_str INTEGER NULL, VARCHAR2 (20) NULL, _str VARCHAR2 (20) NULL, _post INTEGER NOT NULL, _no INTEGER NOT NULL, _numb INTEGER NOT NULL
); UNIQUE INDEX XPKСтрунние ON Strynnue
(nom_post ASC, post_no ASC, inv_numb ASC); TABLE StrynnueCONSTRAINT XPKСтрунние PRIMARY KEY (nom_post, post_no, inv_numb); TABLE Ydarnue
(_dere VARCHAR2 (20) NULL, _kyx INTEGER NULL, _ram INTEGER NULL, _yp VARCHAR2 (20) NULL, _bara VARCHAR2 (20) NULL, _post INTEGER NOT NULL, _no INTEGER NOT NULL, _numb INTEGER NOT NULL
); UNIQUE INDEX XPKУдарние ON Ydarnue
(nom_post ASC, post_no ASC, inv_numb ASC); TABLE YdarnueCONSTRAINT XPKУдарние PRIMARY KEY (nom_post, post_no, inv_numb); TABLE Dyhovue (FOREIGN KEY (nom_post, post_no, inv_numb) REFERENCES Instrymentu (nom_post, post_no , inv_numb) ON DELETE CASCADE); TABLE Instrymentu (CONSTRAINT R_28 FOREIGN KEY (nom_post, post_no, inv_numb) REFERENCES Sklad (nom_post, post_no, inv_numb)); TABLE Klientu (CONSTRAINT R_25 FOREIGN KEY (pay_zak, date_pay) REFERENCES Chek (pay_zak, date_pay...
