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