스타 스키마

테이블 (6)

Dim_Event_Type (Untitled3)

  • event_type_id — long — 기본 키 — NOT NULL
  • event_name — string
  • event_category — enum
  • event_description (event_discription) — enum

Dim_Member (Untitled2)

  • member_id — long — 기본 키 — NOT NULL
  • age_group — int
  • gender — enum
  • signup_date — date
  • location — location
  • tech_stack — String
  • avg_paln_time (avg_plan_time)
  • avg_progress_time

Dim_date (Untitled4)

  • date_id — long — 기본 키 — NOT NULL
  • full_date — date
  • year — int
  • quarter — int
  • month — int
  • day_of_week — boolean
  • Field

Dim_time (Untitled5)

  • time_id — long — 기본 키 — NOT NULL
  • hour — long
  • minute — long
  • time_period — enum

Fact_Table (Untitled)

  • event_id — long — 기본 키 — NOT NULL
  • member_id — long — 외래 키 → Dim_Member.member_id — NOT NULL
  • event_type_id — long — 외래 키 → Dim_Event_Type.event_type_id — NOT NULL
  • date_id — long — 외래 키 → Dim_date.date_id — NOT NULL
  • time_id — long — 외래 키 → Dim_time.time_id — NOT NULL
  • study_id — long — 외래 키 → dim_study.study_id — NOT NULL
  • event_timestamp — long
  • ip_address — string
  • duration — long

dim_study (Untitled6)

  • study_id — long — 기본 키 — NOT NULL
  • name — string
  • category — category
  • participant1 — long
  • participant2 — long
  • study_status — enum
  • created_date (create_date) — date