codeit
Tables (9)
article_views
- id — UUID
- article_id — UUID — NOT NULL
- viewed_by — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- source — article_source — NOT NULL
- source_url — TEXT — NOT NULL
- article_title — VARCHAR(500) — NOT NULL
- article_published_date — TIMESTAMPTZ — NOT NULL
- article_summary — TEXT
- article_comment_count — BIGINT — NOT NULL
- article_view_count — BIGINT — NOT NULL
articles
- id — UUID
- source — article_source — NOT NULL
- source_url — TEXT — NOT NULL
- title — VARCHAR(500) — NOT NULL
- publish_date — TIMESTAMPTZ — NOT NULL
- summary — TEXT
- comment_count — BIGINT — NOT NULL
- view_count — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
comment_likes
- id — UUID
- comment_id — UUID — NOT NULL
- liked_by — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- comment_user_id — UUID — NOT NULL
comments
- id — UUID
- article_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- content — VARCHAR(500) — NOT NULL
- like_count — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
interest_keywords
- id — UUID
- interest_id — UUID — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
interests
- id — UUID
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ
notifications
- id — UUID
- user_id — UUID — NOT NULL
- content — TEXT — NOT NULL
- confirmed — BOOLEAN — NOT NULL
- resource_type — notification_resource_type
- resource_id — UUID
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
subscriptions
- id — UUID
- user_id — UUID — NOT NULL
- interest_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- password_hash — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMPTZ