MoNew

Tables (12)

article_backup_jobs

  • id — UUID
  • backup_date — DATE — NOT NULL
  • job_type — backup_job_types — NOT NULL
  • status — backup_job_statuses — NOT NULL
  • s3_bucket — VARCHAR(255)
  • s3_key — VARCHAR(500)
  • article_count — INT — NOT NULL
  • started_at — TIMESTAMP
  • finished_at — TIMESTAMP
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

article_interests

  • id — UUID
  • article_id — UUID — Foreign key → news_articles.id — NOT NULL
  • interest_id — UUID — Foreign key → interests.id — NOT NULL
  • matched_keyword — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL

article_views

  • id — UUID
  • article_id — UUID — Foreign key → news_articles.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • first_viewed_at — TIMESTAMP — NOT NULL
  • last_viewed_at — TIMESTAMP — NOT NULL

comment_likes

  • id — UUID
  • comment_id — UUID — Foreign key → comments.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

comments

  • id — UUID
  • article_id — UUID — Foreign key → news_articles.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • like_count — INT — NOT NULL
  • delete_status — delete_statuses — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

interest_keywords

  • id — UUID
  • interest_id — UUID — Foreign key → interests.id — NOT NULL
  • keyword — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

interests

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • subscriber_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

news_articles

  • id — UUID
  • source_id — UUID — Foreign key → news_sources.id — NOT NULL
  • original_link — VARCHAR(1000) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • published_at — TIMESTAMP — NOT NULL
  • summary — TEXT
  • comment_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • delete_status — delete_statuses — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

news_sources

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • source_type — news_source_types — NOT NULL
  • base_url — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

notifications

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • notification_type — notification_types — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • resource_type — notification_resource_types — NOT NULL
  • resource_id — UUID — NOT NULL
  • actor_user_id — UUID — Foreign key → users.id
  • is_confirmed — BOOLEAN — NOT NULL
  • confirmed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

subscriptions

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • interest_id — UUID — Foreign key → interests.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • delete_status — delete_statuses — NOT NULL
  • deleted_at — TIMESTAMP
  • purge_scheduled_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL