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