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