Создание БД на Oracle 11XE

ROOMS (ID INTEGER NOT NULL, HOTELID INTEGER NOT NULL, FLOOR INTEGER NOT NULL, ROOMNUM INTEGER NOT NULL, ROOMTYPEID INTEGER NOT NULL, SEATSCOUNT INTEGER NOT NULL, DESCRIPTION VARCHAR2(4000 BYTE))TABLESPACE USERSRESULT_CACHE (MODE DEFAULT) PCTUSED 0PCTFREE 10INITRANS 1MAXTRANS 255STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) LOGGING NOCOMPRESS NOCACHENOPARALLELMONITORING;CREATE TABLE WORK. ROOMSEMPLOYMENT (ID INTEGER NOT NULL, ROOMID INTEGER NOT NULL, ROOMSTATEID INTEGER NOT NULL, EMPLOYEEID INTEGER NOT NULL, CLIENTID INTEGER, DATEFROM DATE NOT NULL, DATETO DATE, ENABLED INTEGER NOT NULL, DESCRIPTION VARCHAR2(4000 BYTE))TABLESPACE USERSRESULT_CACHE (MODE DEFAULT) PCTUSED 0PCTFREE 10INITRANS 1MAXTRANS 255STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) LOGGING NOCOMPRESS NOCACHENOPARALLELMONITORING;CREATE TABLE WORK. ROOMEMPSERVICE (ID INTEGER NOT NULL, ROOMEMPLOYMENTID INTEGER NOT NULL, SERVICEID INTEGER, SUMM NUMBER, DESCRIPTION VARCHAR2(4000 BYTE))TABLESPACE USERSRESULT_CACHE (MODE DEFAULT) PCTUSED 0PCTFREE 10INITRANS 1MAXTRANS 255STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) LOGGING NOCOMPRESS NOCACHENOPARALLELMONITORING;/* TRIGGERS */CREATE OR REPLACE TRIGGER WORK. CLIENTS_INCBEFORE INSERTON WORK. ClientsREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT Clients_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. EMPLOYEES_INCBEFORE INSERTON WORK. EmployeesREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT Emp_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. HOTELS_INCBEFORE INSERTON WORK. HOTELSREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT Hotels_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. ROOMSTATE_INCBEFORE INSERTON WORK. RoomStateREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT RoomState_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. ROOMTYPE_INCBEFORE INSERTON WORK. RoomTypeREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT RoomType_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. SERVICES_INCBEFORE INSERTON WORK. ServicesREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT Services_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. ROOMS_INCBEFORE INSERTON WORK. ROOMSREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT ROOMS_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. ROOMSEMP_INCBEFORE INSERTON WORK. RoomsEmploymentREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT RoomsEmp_seq.NEXTVALINTO :new.ID FROM dual;END ;CREATE OR REPLACE TRIGGER WORK. ROOMEMPSERVICE_INCBEFORE INSERTON WORK. RoomEmpServiceREFERENCING NEW AS New OLD AS OldFOR EACH ROWBEGIN SELECT RoomsEmp_Service_seq.NEXTVALINTO :new.ID FROM dual;END ;/* CONSTRAINTS */ALTER TABLE WORK. CLIENTS ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. EMPLOYEES ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. HOTELS ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. ROOMSTATE ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. ROOMTYPE ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. SERVICES ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. ROOMS ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. ROOMSEMPLOYMENT ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. ROOMEMPSERVICE ADD (PRIMARY KEY (ID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE VALIDATE);ALTER TABLE WORK. ROOMS ADD (FOREIGN KEY (HOTELID) REFERENCES WORK. HOTELS (ID) ON DELETE SET NULL ENABLE VALIDATE, FOREIGN KEY (ROOMTYPEID) REFERENCES WORK. ROOMTYPE (ID) ENABLE VALIDATE);ALTER TABLE WORK. ROOMSEMPLOYMENT ADD (FOREIGN KEY (ROOMID) REFERENCES WORK. ROOMS (ID) ENABLE VALIDATE, FOREIGN KEY (ROOMSTATEID) REFERENCES WORK. ROOMSTATE (ID) ENABLE VALIDATE, FOREIGN KEY (EMPLOYEEID) REFERENCES WORK. EMPLOYEES (ID) ENABLE VALIDATE, FOREIGN KEY (CLIENTID) REFERENCES WORK. CLIENTS (ID) ENABLE VALIDATE);ALTER TABLE WORK. ROOMEMPSERVICE ADD (FOREIGN KEY (ROOMEMPLOYMENTID) REFERENCES WORK. ROOMSEMPLOYMENT (ID) ENABLE VALIDATE, FOREIGN KEY (SERVICEID) REFERENCES WORK. SERVICES (ID) ENABLE VALIDATE);ALTER TABLE WORK. ROOMEMPSERVICE ADD (FOREIGN KEY (ROOMEMPLOYMENTID) REFERENCES WORK. ROOMSEMPLOYMENT (ID), FOREIGN KEY (SERVICEID) REFERENCES WORK. SERVICES (ID));ALTER TABLE WORK. ROOMS ADD (FOREIGN KEY (HOTELID) REFERENCES WORK. HOTELS (ID) ON DELETE SET NULL, FOREIGN KEY (ROOMTYPEID) REFERENCES WORK. ROOMTYPE (ID));ALTER TABLE WORK. ROOMSEMPLOYMENT ADD (FOREIGN KEY (ROOMID) REFERENCES WORK. ROOMS (ID), FOREIGN KEY (ROOMSTATEID) REFERENCES WORK. ROOMSTATE (ID), FOREIGN KEY (EMPLOYEEID) REFERENCES WORK. EMPLOYEES (ID), FOREIGN KEY (CLIENTID) REFERENCES WORK. CLIENTS (ID));