WON

Tables (8)

c (city)

  • city_code (c_code) — Primary key — NOT NULL
  • city_name (c_name)

i (pt image)

  • i_code — Primary key — NOT NULL
  • pt_code (p_id) — Foreign key → pt.pt_code — NOT NULL
  • vill_code (v_code) — Foreign key → pt.vill_code — NOT NULL
  • city_code (c_code) — Foreign key → pt.city_code — NOT NULL
  • i_file_path (i_file)

m (member)

  • member_id (m_id) — Primary key — NOT NULL
  • member_pw (m_pw)
  • member_coin (m_coin)
  • member_birth (m_brith)
  • member_sex (m_sex)
  • member_phone (m_phone)
  • city_code (c_code) — Foreign key → c.city_code — NOT NULL

mp (m-pt(+cart with status))

  • member_id (m_id) — Foreign key → m.member_id — NOT NULL
  • pt_code (p_id) — Foreign key → pt.pt_code — NOT NULL
  • vill_code (v_code) — Foreign key → pt.vill_code — NOT NULL
  • city_code (c_code) — Foreign key → pt.city_code — NOT NULL
  • mp_date
  • mp_status (mp_stat)
  • mp_count (mp_cnt)

pt (personal training)

  • pt_code (p_id) — Primary key — NOT NULL
  • vill_code (v_code) — Foreign key → v.vill_code — NOT NULL
  • city_code (c_code) — Foreign key → v.city_code — NOT NULL
  • pt_price (p_price)
  • pt_content (p_cont)
  • pt_consulting_price (p_conp)
  • pt_views

r (review)

  • member_id (m_id) — Foreign key → mp.member_id — NOT NULL
  • pt_code (p_id) — Foreign key → mp.pt_code — NOT NULL
  • vill_code (v_code) — Foreign key → mp.vill_code — NOT NULL
  • city_code (c_code) — Foreign key → mp.city_code — NOT NULL
  • r_content (r_cont)
  • r_star

t (trainer)

  • trainer_id (t_id) — Foreign key → m.member_id — NOT NULL
  • trainer_thumbs (t_thumbs)

v (village)

  • vill_code (v_code) — Primary key — NOT NULL
  • city_code (c_code) — Foreign key → c.city_code — NOT NULL
  • vill_name (v_name)