health care service

Tables (8)

Untitled

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

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
  • id — varchar — NOT NULL
  • boardNum — int
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

cart

  • cartKey — int — Primary key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • id — varchar — NOT NULL
  • productid — int — NOT NULL

comment

  • chat_num — int — Primary key — NOT NULL
  • contents — varchar — NOT NULL
  • num — int — NOT NULL
  • id — varchar — 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