erd001

Tables (3)

goods (Untitled2)

  • gcode (Key) — Primary key — NOT NULL
  • gname (Field)

member

  • id (Key) — Primary key — NOT NULL
  • name (Field)

orders (Untitled3)

  • id (Key) — Foreign key → member.id — NOT NULL
  • gcode (Key2) — Foreign key → goods.gcode — NOT NULL