test

Tables (5)

Untitled (goods)

  • g_num (good_num) — number(10) — Primary key — NOT NULL
  • g_name — varchar2(50)
  • Field2

Untitled

  • Field

Untitled2 (img)

  • (img_link) — varchar2(100) — Primary key — NOT NULL
  • g_num (good_num) — number(10) — Foreign key → Untitled.g_num — 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)
  • Field
  • Field2
  • Key (deptid) — number(3) — Foreign key → dept.Key — NOT NULL