NotNow
Tables (5)
notification
- notification_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → user.user_id
- keyword_id (keyword_id2) — BIGINT — Foreign key → trend_keyword.keyword_id
- type — ENUM('email','push') — NOT NULL
- status — ENUM('pending','sent')
- scheduled_at — DATETIME — NOT NULL
trend_event_log
- event_id — BIGINT — Primary key
- keyword_id (keyword_id2) — BIGINT — Foreign key → trend_keyword.keyword_id
- source_type — ENUM('sns','community','news') — NOT NULL
- mention_count — INT
- event_time — DATETIME
trend_keyword
- keyword_id — BIGINT — Primary key
- name — VARCHAR(255) — NOT NULL
- category — ENUM('restaurant','date','exhibition','activity','travel') — NOT NULL
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- source_type — ENUM('sns','community','news') — NOT NULL
- score — DOUBLE
- created_at — DATETIME
- updated_at — DATETIME
user
- user_id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- profile_image_url — TEXT
- location — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
user_bookmark
- bookmark_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key → user.user_id
- keyword_id (keyword_id2) — BIGINT — Foreign key → trend_keyword.keyword_id
- created_at — DATETIME