ㅁㅁ

Tables (5)

event_params

  • param_id — BIGINT — Primary key
  • event_id — BIGINT — Foreign key → events.event_id
  • user_id (user_id2) — VARCHAR(64) — Foreign key → events.user_id
  • param_key — VARCHAR(64)
  • param_value — VARCHAR(255)

events

  • event_id — BIGINT — Primary key
  • user_id — VARCHAR(64) — Foreign key → users.user_id
  • screen_id — VARCHAR(64)
  • action_type — VARCHAR(32)
  • event_time — TIMESTAMP

screens

  • screen_id — VARCHAR(64) — Primary key
  • screen_name — VARCHAR(100)
  • description — TEXT

transitions

  • transition_id — BIGINT — Primary key
  • event_id — BIGINT — Foreign key → events.event_id
  • user_id (user_id2) — VARCHAR(64) — Foreign key → events.user_id
  • transition_type — VARCHAR(16)
  • to_screen_id — VARCHAR(64)

users

  • user_id — VARCHAR(64) — Primary key
  • created_at — TIMESTAMP