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