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