ss

CREATE TABLE availability_details(
    num_warehouse INT NOT NULL PRIMARY KEY CHECK ( num_warehouse>0 ),
    id_detail INT NOT NULL CHECK ( id_detail>0 ),
    unit_detail VARCHAR(3) NOT NULL DEFAULT 'шт',
    quantity_in_warehouse INT NOT NULL CHECK ( quantity_in_warehouse>=0 ),
    date_last_oper DATE NOT NULL
);
CREATE TABLE details(
    id_detail INT NOT NULL UNIQUE CHECK ( id_detail>0 ),
    type_of_detail TEXT NOT NULL,
    name_of_detail TEXT NOT NULL,
    unit_detail VARCHAR(3) NOT NULL DEFAULT 'шт',
    price_unit_detail DECIMAL NOT NULL CHECK ( price_unit_detail>0 )
);
CREATE TABLE shipment_accounting(
    num_warehouse INT NOT NULL CHECK ( num_warehouse>0 ),
    num_of_ship_doc INT NOT NULL CHECK ( num_of_ship_doc>0 ),
    id_customer INT NOT NULL CHECK ( id_customer>0 ),
    id_ready_detail INT NOT NULL CHECK ( id_ready_detail>0 ),
    unit_detail VARCHAR(3) NOT NULL DEFAULT 'шт',
    quantity INT NOT NULL CHECK ( quantity>=0 ),
    date_of_ship_acc DATE NOT NULL,
    CONSTRAINT fkd_num_ware_house FOREIGN KEY(num_warehouse)
        REFERENCES availability_details(num_warehouse) ON DELETE CASCADE,
    CONSTRAINT fku_num_ware_house FOREIGN KEY(num_warehouse)
        REFERENCES availability_details(num_warehouse) ON UPDATE CASCADE
);