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