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