Advertisement
VoronVU

LABORING

Mar 27th, 2015
1,156
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE EMT.LABORING (
  2.   LAB_ID      NUMBER(38, 0),
  3.   LAB_NAME    VARCHAR2(50 CHAR) NOT NULL,
  4.   LAB_BOSS_ID NUMBER(38, 0),
  5.   DEP_ID      NUMBER(38, 0),
  6.   SALARY      NUMBER(38, 0)     NOT NULL,
  7.   CONSTRAINT PK_LABORING PRIMARY KEY (LAB_ID) USING INDEX TABLESPACE USERS STORAGE (INITIAL 64 K NEXT 1 M MAXEXTENTS UNLIMITED),
  8.   CONSTRAINT FK_LABORING_BOSS_ID FOREIGN KEY (LAB_BOSS_ID) --Руководитель
  9.   REFERENCES EMT.LABORING (LAB_ID),
  10.   CONSTRAINT FK_LABORING_DEP_ID FOREIGN KEY (DEP_ID) --Отдел
  11.   REFERENCES EMT.DEPARTAMENT (DEP_ID)
Advertisement
RAW Paste Data Copied
Advertisement