LABORING

CREATE TABLE EMT.LABORING (
  LAB_ID      NUMBER(38, 0),
  LAB_NAME    VARCHAR2(50 CHAR) NOT NULL,
  LAB_BOSS_ID NUMBER(38, 0),
  DEP_ID      NUMBER(38, 0),
  SALARY      NUMBER(38, 0)     NOT NULL,
  CONSTRAINT PK_LABORING PRIMARY KEY (LAB_ID) USING INDEX TABLESPACE USERS STORAGE (INITIAL 64 K NEXT 1 M MAXEXTENTS UNLIMITED),
  CONSTRAINT FK_LABORING_BOSS_ID FOREIGN KEY (LAB_BOSS_ID) --Руководитель
  REFERENCES EMT.LABORING (LAB_ID),
  CONSTRAINT FK_LABORING_DEP_ID FOREIGN KEY (DEP_ID) --Отдел
  REFERENCES EMT.DEPARTAMENT (DEP_ID)