test

Tables (4)

Untitled (goods)

  • Key (good_num) — number(10) — Primary key — NOT NULL
  • Field (good_name) — varchar2(50)
  • Field2

Untitled2 (img)

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

dept

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

emp

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