shop22

Tables (3)

member

  • id — varchar(20) — Primary key — NOT NULL
  • pw — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • tel — VARCHAR(30)

product

  • id — no — Primary key — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • content — VARCHAR(120)
  • price — int

test

  • id — int — Primary key — NOT NULL — 아이디
  • Field
  • Field2
  • id (writer) — varchar(20) — Foreign key → member.id — NOT NULL