app

Tables (7)

ADVERTISEMENTS (Untitled2)

  • ad_key (Key) — INT — Primary key — NOT NULL
  • ad_name (Field) — VARCHAR
  • is_active (Field2) — BOOLEAN
  • created_at (Field3) — TIMESTAMP

AD_VIEW_HISTORY (Untitled3)

  • view_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • ad_key (Key2) — INT — Foreign key → ADVERTISEMENTS.ad_key — NOT NULL
  • session_id (Key3) — INT — Foreign key → SESSION.session_id — NOT NULL
  • viewed_at (Field) — TIMESTAMP

SCREENS (screens)

  • screens_id — INT — Primary key — NOT NULL
  • screens_name — VARCHAR — "로그인" "메인화면"
  • screens_type — ENUM — pop, modal, main, login
  • menu (Field) — INT
  • depth (Field2) — INT

SCREENS_HISTORY (screens_history)

  • history_id (Key) — INT — Primary key — NOT NULL
  • to_screen_id (screens_id) — INT — Foreign key → SCREENS.screens_id — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • session_id (Key3) — INT — Foreign key → SESSION.session_id — NOT NULL
  • from_screen_id (Field4) — INT
  • action_type (Field) — ENUM
  • timestamp (Field2) — TIMESTAMP
  • stack_depth (Field3) — INT

SESSION (Untitled)

  • session_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • start_time (Field) — TIMESTAMP
  • end_time (Field2) — TIMESTAMP
  • device_info (Field3) — VARCHAR

USER (user)

  • user_id — INT — Primary key — NOT NULL
  • is_logged_in — BOOLEAN
  • created_at — TIMESTAMP
  • last_logged_in — TIMESTAMP

USER_ACTION (user_action)

  • action_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • session_id (Key2) — INT — Foreign key → SESSION.session_id — NOT NULL
  • screens_id — INT — Foreign key → SCREENS.screens_id — NOT NULL
  • action_type (Field) — ENUM
  • action_value (Field2) — VARCHAR
  • timestamp (Field3) — TIMESTAMP