SHOW:
|
|
- or go back to the newest paste.
| 1 | - | CREATE TABLE EMT.DEPARTAMENT ( |
| 1 | + | CREATE TABLE EMT.LABORING ( |
| 2 | - | DEP_ID NUMBER(38, 0), |
| 2 | + | LAB_ID NUMBER(38, 0), |
| 3 | - | DEP_NAME VARCHAR2(50 CHAR) NOT NULL, |
| 3 | + | LAB_NAME VARCHAR2(50 CHAR) NOT NULL, |
| 4 | - | CONSTRAINT PK_DEPARTAMENT PRIMARY KEY (DEP_ID) USING INDEX TABLESPACE USERS STORAGE (INITIAL 64 K NEXT 1 M MAXEXTENTS UNLIMITED)) |
| 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) |
