test
Tables (4)
A (Untitled)
- DEPTNO (Key) — Foreign key → DEPT.DEPTNO — NOT NULL
- JOB (Field)
- TOT_SAL (Field2)
B (Untitled4)
- EMPNO (Key) — Foreign key → EMP.EMPNO — NOT NULL
- DNAME (Field)
- TOT_SAL (Field2)
- RUNNING_SUM (Field3)
- RANK (Field4)
DEPT (Untitled3)
- DEPTNO (Key) — Primary key — NOT NULL
- DNAME (Field)
- LOC (Field2)
EMP (Untitled2)
- EMPNO (Key) — Primary key — NOT NULL
- ENAME (Field)
- JOB (Field2)
- MGR (Field3)
- HIRDATE (Field4)
- SAL (Field5)
- COMM (Field6)
- DEPTNO (Key2) — Foreign key → DEPT.DEPTNO — NOT NULL