day6 mission
Tables (5)
ads
- id — BIGINT
- title — VARCHAR(100) — NOT NULL
event_logs
- id — BIGINT
- user_id — BIGINT — NOT NULL
- event_type_id — TINYINT — NOT NULL
- screen_id — BIGINT
- screen_from_id — BIGINT
- screen_to_id — BIGINT
- ad_id — BIGINT
- meta — JSON
- occurred_at — DATETIME — NOT NULL
- INDEX — idx_event_user_time
- INDEX — idx_event_type_time
- INDEX — idx_screen_time
event_types
- id — TINYINT
- name — VARCHAR(50) — NOT NULL
screens
- id — BIGINT
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- parent_id — BIGINT
- depth — INT — NOT NULL
users
- id — BIGINT
- username — VARCHAR(100) — NOT NULL
- password_hash — VARBINARY(255) — NOT NULL
- created_at — DATETIME — NOT NULL