ERD 그려보기
테이블 (6)
site
- site_id — INT — 기본 키 — NOT NULL
- site_name — VARCHAR(120)
- city — VARCHAR(60)
- district — VARCHAR(60)
- address — VARCHAR(200)
site_area
- site_area_id — INT — 기본 키 — NOT NULL
- site_id — INT — NOT NULL
- area_name — VARCHAR(120)
- floor — INT
- capacity — INT
- area_type — VARCHAR(40)
- site_id (site_id2) — INT — 외래 키 → site.site_id — NOT NULL
trial_access_log
- access_id — INT — 기본 키 — NOT NULL
- trial_id — INT — NOT NULL
- event_time — DATETIME
- event_type — VARCHAR(40)
- page_path — VARCHAR(200)
- device — VARCHAR(20)
- utm_source — VARCHAR(60)
- utm_medium — VARCHAR(60)
- utm_campaign — VARCHAR(80)
- referrer — VARCHAR(200)
- ip_address — VARCHAR(50)
- trial_id (trial_id2) — INT — 외래 키 → trial_register.trial_id — NOT NULL
trial_payment
- payment_id — INT — 기본 키 — NOT NULL
- trial_id — INT — NOT NULL
- user_id — INT
- paid_date — DATE
- plan_name — VARCHAR(60)
- amount — DECIMAL(12,2)
- currency — VARCHAR(10)
- pay_method — VARCHAR(20)
- pay_status — VARCHAR(20)
- coupon_code — VARCHAR(50)
- trial_id (trial_id2) — INT — 외래 키 → trial_register.trial_id — NOT NULL
trial_register
- trial_id — INT — 기본 키 — NOT NULL
- user_id — INT
- site_id — INT — NOT NULL
- user_email — VARCHAR(150)
- user_name — VARCHAR(100)
- signup_date — DATE
- signup_channel — VARCHAR(40)
- status — VARCHAR(20)
- site_id (site_id2) — INT — 외래 키 → site.site_id — NOT NULL
trial_visit_info
- visit_id — INT — 기본 키 — NOT NULL
- trial_id — INT — NOT NULL
- site_area_id — INT
- visit_date — DATE
- checkin_time — TIME
- checkout_time — TIME
- duration_min — INT
- purpose — VARCHAR(40)
- staff_notes — TEXT
- trial_id (trial_id2) — INT — 외래 키 → trial_register.trial_id — NOT NULL
- site_area_id (site_area_id2) — INT — 외래 키 → site_area.site_area_id — NOT NULL