shop2

Tables (6)

bbs

  • id — int — Primary key — NOT NULL — 회원 id
  • writer — varchar(20) — Foreign key → member.id — NOT NULL — 회원 id
  • title — varchar(20)
  • content — varchar(20)

company

  • id — varchar(20) — Primary key — NOT NULL
  • name — varchar(20)
  • addr — varchar(20)
  • tel — varchar(20)

member

  • id — varchar(20) — Primary key — NOT NULL — 회원 id
  • pw — varchar(20
  • name — varchar(20)
  • tel — varchar(20)

orange

  • id — varchar(20) — Primary key — NOT NULL
  • title — varchar(20)
  • content — varchar(20)
  • todate — varchar(20)

product

  • id — varchar(20) — Primary key — NOT NULL
  • id (id2) — varchar(20) — Foreign key → company.id — NOT NULL
  • name — varchar(20)
  • content — varchar(20)
  • price — varchar(20)
  • company — varchar(20)
  • img — varchar(20)

reply

  • id — int — Primary key — NOT NULL
  • id (id2) — int — Foreign key → bbs.id — NOT NULL — 회원 id
  • writer (writer2) — varchar(20) — Foreign key → bbs.writer — NOT NULL — 회원 id
  • id (id3) — varchar(20) — Foreign key → member.id — NOT NULL — 회원 id
  • oriid — int
  • content — varchar(20)
  • writer — varchar(20)