myerd

Tables (3)

cart

  • no — number — Primary key — NOT NULL
  • id — varchar(50) — Foreign key → member.id — NOT NULL
  • gcode — char(10) — Foreign key → goods.gcode — NOT NULL

goods

  • gcode — char(10) — Primary key — NOT NULL
  • gname — varchar(50) — NOT NULL

member

  • id — varchar(50) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL