ㅅ

Tables (8)

board

  • freeboard — int — Primary key — NOT NULL
  • qaboard — int — Primary key — NOT NULL
  • reviewboard — int — Primary key — NOT NULL

board_list

  • num — int — Primary key — NOT NULL
  • title — varchar — NOT NULL
  • contents — varchar — NOT NULL
  • like — int — NOT NULL
  • boardnum — int — Foreign key → board.freeboard — NOT NULL
  • id — varchar — Foreign key → member.id — NOT NULL

cart

  • cartKey — int — Primary key — NOT NULL
  • Field
  • Field2
  • id — varchar — Foreign key → member.id — NOT NULL
  • productid — int — Foreign key → product.productid — NOT NULL

comment

  • chat_num — int — Primary key — NOT NULL
  • contents — varchar — NOT NULL
  • id — varchar — Foreign key → member.id — NOT NULL
  • num (num2) — int — Foreign key → board_list.num — NOT NULL

member

  • id — varchar — Primary key — NOT NULL
  • password — varchar — NOT NULL
  • gender — VARCHAR(20) — NOT NULL
  • age — int — NOT NULL
  • goals — VARCHAR(200) — NOT NULL

member_info

  • id — varchar — Foreign key → member.id — NOT NULL
  • height — int — NOT NULL
  • Weight — int — NOT NULL

product

  • productid — int — Primary key — NOT NULL
  • img — varchar(300) — NOT NULL
  • comment — varchar(600) — NOT NULL
  • price — int — NOT NULL

ㅇ (Untitled)

  • num — int — Primary key — NOT NULL
  • Sports — equipment`
  • Home — training`
  • Nutritional — varchar
  • price — int