ㅁㄴ
Tables (5)
event_params
- param_id — BIGINT
- event_id — BIGINT — NOT NULL
- user_id — VARCHAR(64) — NOT NULL
- param_key — VARCHAR(64) — NOT NULL
- param_value — VARCHAR(255)
- param_type — VARCHAR(32)
- created_at — TIMESTAMP
- INDEX — idx_event_id
- INDEX — idx_user_id
- INDEX — idx_param_key
- INDEX — idx_param_key_value
events
- event_id — BIGINT
- user_id — VARCHAR(64) — NOT NULL
- screen_id — VARCHAR(64) — NOT NULL
- event_category — VARCHAR(32) — NOT NULL
- action_type — VARCHAR(32) — NOT NULL
- transition_type — VARCHAR(32)
- event_time — TIMESTAMP
- session_id — VARCHAR(64)
- INDEX — idx_user_time
- INDEX — idx_screen_time
- INDEX — idx_event_category
- INDEX — idx_action_type
- INDEX — idx_session
- INDEX — idx_event_time
screens
- screen_id — VARCHAR(64)
- screen_name — VARCHAR(100) — NOT NULL
- screen_type — VARCHAR(50) — NOT NULL
- menu_number — INT
- detail_level — INT
- parent_screen_id — VARCHAR(64)
- description — TEXT
- created_at — TIMESTAMP
- INDEX — idx_screen_type
- INDEX — idx_menu_number
- INDEX — idx_parent_screen
transitions
- transition_id — BIGINT
- event_id — BIGINT — NOT NULL
- user_id — VARCHAR(64) — NOT NULL
- from_screen_id — VARCHAR(64) — NOT NULL
- to_screen_id — VARCHAR(64) — NOT NULL
- transition_type — VARCHAR(16) — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_event_id
- INDEX — idx_user_time
- INDEX — idx_from_to
- INDEX — idx_transition_type
users
- user_id — VARCHAR(64) — Primary key
- created_at — TIMESTAMP