CREATE TABLE oplata (
	kod_hostya int NOT NULL,
	kod_nomera int NOT NULL,
	nomer_kvutanstii int NOT NULL,
	kod_administratora int NOT NULL,
	data_pruizdy DATE,
	data_vidizdy DATE,
	CONSTRAINT oplata_pk PRIMARY KEY (nomer_kvutanstii)
) WITH (
  OIDS=FALSE
);
 
 
 
ALTER TABLE oplata ADD CONSTRAINT oplata_fk0 FOREIGN KEY (kod_hostya) REFERENCES hosti(kod_hostya)
ALTER TABLE oplata ADD CONSTRAINT oplata_fk1 FOREIGN KEY (kod_nomera) REFERENCES nomer(kod_nomera)
ALTER TABLE oplata ADD CONSTRAINT oplata_fk2 FOREIGN KEY (kod_administratora) REFERENCES administrator(kod_administratora)