test
Tables (3)
Untitled (history)
- deptno — TINYINT — Foreign key → dept.deptno — NOT NULL
- Key (empno) — SMALLINT — Foreign key → empno.Key — NOT NULL
dept
- deptno — TINYINT — Primary key — NOT NULL
- dname — VARCHAR(14)
- loc — VARCHAR(13)
empno (emp)
- Key (empno) — SMALLINT — Primary key — NOT NULL
- Field (ename) — VARCHAR(10)
- Field (job) — VARCHAR(9)
- Field (mgr) — SMALLINT
- Field (hiredate) — DATE
- Field (sal) — FLOAT
- Field (comm) — FLOAT
- Field (deptno) — TINYINT