어서줍줍
테이블 (15)
article
- id — BIGINT — 기본 키 — NOT NULL
- blog_id — BIGINT — 외래 키 → blog.id — NOT NULL
- title — VARCHAR(500) — NOT NULL
- url — VARCHAR(512) — NOT NULL
- published_at — DATETIME — NOT NULL
- collected_at — DATETIME — NOT NULL
article_keyword
- article_id — BIGINT — 외래 키 → article.id — NOT NULL
- keyword_id — BIGINT — 외래 키 → keyword.id — NOT NULL
- matched_via — VARCHAR(20)
article_quickstart
- id — BIGINT — 기본 키 — NOT NULL
- article_id — BIGINT — 외래 키 → article.id — NOT NULL
- content — JSON — NOT NULL
- model — VARCHAR(50)
- generated_at — DATETIME — NOT NULL
article_summary
- id — BIGINT — 기본 키 — NOT NULL
- article_id — BIGINT — 외래 키 → article.id — NOT NULL
- summary_lines — JSON — NOT NULL
- model — VARCHAR(50)
- label — VARCHAR(20) — NOT NULL
- generated_at — DATETIME — NOT NULL
blog
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- domain — VARCHAR(255) — NOT NULL
- rss_url — VARCHAR(500) — NOT NULL
- active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
bookmark
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- article_id — BIGINT — 외래 키 → article.id — NOT NULL
- created_at — DATETIME — NOT NULL
keyword
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
keyword_alias
- id — BIGINT — 기본 키 — NOT NULL
- keyword_id — BIGINT — 외래 키 → keyword.id — NOT NULL
- alias — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
keyword_alias_candidate
- id — BIGINT — 기본 키 — NOT NULL
- alias — VARCHAR(100) — NOT NULL
- suggested_keyword_id — BIGINT — 외래 키 → keyword.id
- hit_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
keyword_subscription
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- keyword_id — BIGINT — 외래 키 → keyword.id — NOT NULL
- created_at — DATETIME — NOT NULL
member
- id — BIGINT — 기본 키 — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_uid — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- consent_at — DATETIME
- unsubscribe_token — CHAR(36) — NOT NULL
- created_at — DATETIME — NOT NULL
notification
- id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- article_id — BIGINT — 외래 키 → article.id — NOT NULL
- sent_at — DATETIME — NOT NULL
- matched_keywords — VARCHAR(255)
topic
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
topic_keyword
- topic_id — BIGINT — 외래 키 → topic.id — NOT NULL
- keyword_id — BIGINT — 외래 키 → keyword.id — NOT NULL
topic_subscription
- member_id — BIGINT — 외래 키 → member.id — NOT NULL
- topic_id — BIGINT — 외래 키 → topic.id — NOT NULL
- created_at — DATETIME — NOT NULL