scott
Tables (4)
bobus
- Field (ename) — varchar(10)
- Field (job) — vachar(10)
- Field (sal) — number
- Field (comm) — number
dept
- deptno — number(2) — Primary key — NOT NULL
- dname — varchar2(10)
- loc — varchar2(10)
emp
- Key (empno) — number(2) — Primary key — NOT NULL
- Field (ename) — varchar2(10)
- Field (job) — varchar2(10)
- Field (hiredate) — date
- Field (mgr) — number(2)
- deptno — number(2) — Foreign key → dept.deptno — NOT NULL
- Field (sal) — number
- Field (com) — number
- deptno (deptno2) — number(2) — Foreign key → dept.deptno — NOT NULL