prac

테이블 (7)

article_insights

  • id — UUID
  • article_id — UUID — NOT NULL
  • cycle_feature_id — UUID
  • summary — TEXT — NOT NULL
  • easy_explanation — TEXT — NOT NULL
  • cycle_tags — TEXT — NOT NULL
  • keywords — TEXT — NOT NULL
  • created_at — timestamptz — NOT NULL

articles

  • id — UUID
  • interest_id — UUID
  • source_id — UUID
  • external_id — TEXT
  • title — TEXT — NOT NULL
  • url — TEXT — NOT NULL
  • published_at — timestamptz — NOT NULL
  • raw_content — TEXT — NOT NULL

cycle_features

  • id — UUID
  • cycle — VARCHAR(20) — NOT NULL
  • feature — TEXT — NOT NULL

sources

  • id — UUID
  • name — TEXT — NOT NULL
  • base_url — TEXT — NOT NULL

user_interests

  • id — UUID
  • user_id — UUID — NOT NULL
  • interest_id — UUID — NOT NULL
  • created_at — timestamptz — NOT NULL

사용자 (users)

  • ID (id) — UUID — 기본 키 — NOT NULL
  • clerk_id — TEXT — NOT NULL
  • display_name — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • created_at — timestamptz — NOT NULL

사용자관심사 (interests)

  • ID (id) — UUID — 기본 키 — NOT NULL
  • name — TEXT — NOT NULL