CREATE TABLE client_yar 
    ( 
     id_client_yar INTEGER  NOT NULL , 
     "nazvanie-organizacii" VARCHAR2 (255) , 
     fio_kontact VARCHAR2 (255) , 
     polnoe_naimenovanie VARCHAR2 (255) , 
     adress VARCHAR2 (255) , 
     tel NUMBER , 
     inn NUMBER , 
     kpp NUMBER , 
     rs NUMBER , 
     bank VARCHAR2 (255) , 
     corresp_schet NUMBER , 
     bik NUMBER , 
     director VARCHAR2 (255) , 
     na_osn_chego_deistv VARCHAR2 
    ) 
;

CREATE TABLE zayvka 
    ( 
     id_zayavka INTEGER  NOT NULL , 
     "date" DATE , 
     stoimost NUMBER , 
     summa NUMBER , 
     type INTEGER , 
     ustroistvo_id_ustroistvo INTEGER  NOT NULL , 
     client_fiz_id_client_fiz INTEGER  NOT NULL , 
     client_yar_id_client_yar INTEGER  NOT NULL , 
     sklad_id_sklad INTEGER  NOT NULL , 
     sotrudnik_id_sotrudnik INTEGER  NOT NULL 
    ) 
;



ALTER TABLE zayvka 
    ADD CONSTRAINT zayvka_PK PRIMARY KEY ( id_zayavka ) ;

ALTER TABLE client_yar 
    ADD CONSTRAINT client_yar_PK PRIMARY KEY ( id_client_yar ) ;

ALTER TABLE zayvka 
    ADD CONSTRAINT zayvka_client_yar_FK FOREIGN KEY 
    ( 
     client_yar_id_client_yar
    ) 
    REFERENCES client_yar 
    ( 
     id_client_yar
    ) 
    ON DELETE CASCADE