Автоматизация учета природных ресурсов земельных зон государственного казенного учреждения ямало-ненецкого автономного округа «недра ямала»
71

ID_section           INTEGER NOT NULL,

              Section_Category     INTEGER NULL,

              Section_Resource     VARCHAR(20) NULL,

              Section_Building     VARCHAR(20) NULL,

              Section_Permitted    VARCHAR(20) NULL

);

ALTER TABLE Section

ADD PRIMARY KEY (ID_section);

ALTER TABLE Client

ADD FOREIGN KEY R_25 (ID_rent_contract) REFERENCES Rent (ID_rent_contract);

ALTER TABLE Client

ADD FOREIGN KEY R_26 (ID_sale_contract) REFERENCES Sale (ID_sale_contract);

ALTER TABLE Individual

ADD FOREIGN KEY R_29 (ID_client) REFERENCES Client (ID_client);

ALTER TABLE Juridical

ADD FOREIGN KEY R_28 (ID_client) REFERENCES Client (ID_client);

ALTER TABLE Rent

ADD FOREIGN KEY R_23 (ID_section) REFERENCES Section (ID_section);

ALTER TABLE Sale

ADD FOREIGN KEY R_24 (ID_section) REFERENCES Section (ID_section);