스타 스키마
테이블 (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