SCOTT
Tables (5)
SCOTT (EMP)
- Key (EMPNO) — NUMBER(4) — Primary key — NOT NULL
- Field (ENAME) — VARCHAR2(10 BYTE)
- Field (JOB) — VARCHAR2(9 BYTE)
- Field (MGR) — NUMBER(4)
- Field (HIREDATE) — DATE
- Field (SAL) — NUMBER(7, 2)
- Field (COMM) — NUMBER(7, 2)
- Field (DEPTNO) — NUMBER(2)
- Key (DEPTNO2) — NUMBER(2) — Foreign key → SCOTT.Key — NOT NULL
SCOTT (DEPT)
- Key (DEPTNO) — NUMBER(2) — Primary key — NOT NULL
- Field (DNAME) — VARCHAR2(14 BYTE)
- Field (LOC) — VARCHAR2(13 BYTE)
SCOTT (SALGRADE)
- Field (GRADE) — NUMBER
- Field (LOSAL) — NUMBER
- Field (HISAL) — NUMBER
SCOTT (EMP_CONST)
- (EMPNO) — NUMBER(4) — Primary key — NOT NULL
- Key (ENAME) — VARCHAR2(10 BYTE) — Primary key — NOT NULL
- Field (JOB) — VARCHAR2(9 BYTE)
- Field2 (TEL) — VARCHAR2(20 BYTE)
- Field (HIREDATE) — DATE
- Field (SAL) — NUMBER(7, 2)
- Field (COMM) — NUMBER(7, 2)
- Field (DEPTNO) — NUMBER(2)
- Key (DEPTNO2) — NUMBER(2) — Foreign key → SCOTT.Key — NOT NULL
SCOTT (DEPT_CONST)
- Key (DEPTNO) — NUMBER(2) — Primary key — NOT NULL
- Field (DNAME) — VARCHAR2(14 BYTE)
- Field (LOC) — VARCHAR2(13 BYTE)