어서줍줍

테이블 (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