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)