test

Tables (4)

dept

  • Key (deptid) — number(3) — Primary key — NOT NULL
  • Field (deptname) — varchar2(50)

emp

  • empnum (emonum) — char(10) — Primary key — NOT NULL
  • Field (empname) — varchar2(50)
  • Field3
  • Field4
  • Key (deptid) — number(3) — Foreign key → dept.Key — NOT NULL

goods

  • Key (g_num) — number(10) — Primary key — NOT NULL
  • Field (g_name) — varchar2(50)
  • Field

img

  • Key (img_link) — varchar2(100) — Primary key — NOT NULL
  • Key (g_num) — number(10) — Foreign key → goods.Key — NOT NULL