clusterign_news_service

Tables (13)

article

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • link — VARCHAR(255) — NOT NULL
  • summary — TEXT
  • published — DATETIME(6) — NOT NULL

cluster

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • label — INT
  • 기사수 (num_articles) — INT

cluster_article

  • id — BIGINT — Primary key — NOT NULL
  • article_id — BIGINT — Foreign key → article.id — NOT NULL
  • cluster_id — BIGINT — Foreign key → cluster.id — NOT NULL

cluster_keyword

  • id — BIGINT — Primary key — NOT NULL
  • cluster_id — BIGINT — Foreign key → cluster.id — NOT NULL
  • keyword — BIGINT — Foreign key → keyword.id — NOT NULL

keyword

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(31)

knowledge_map (지식맵)

  • id — BIGINT — Primary key — NOT NULL
  • created_at (생성시간) — DATETIME(6)
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

note

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • text — TEXT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • state — BOOLEAN

note_article

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • state — BOOLEAN
  • note_id — BIGINT — Foreign key → note.id — NOT NULL
  • article_id — BIGINT — Foreign key → article.id — NOT NULL

p_cluster (personal_cluster)

  • id — Primary key — NOT NULL
  • created_at
  • label — INT
  • knowledge_map_id (id2) — BIGINT — Foreign key → knowledge_map.id — NOT NULL

pcluster_article (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • p_cluster — BIGINT — Foreign key → p_cluster.id — NOT NULL
  • article_id — BIGINT — Foreign key → article.id — NOT NULL

pcluster_keyword (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • pcluster_id (id2) — BIGINT — Foreign key → p_cluster.id — NOT NULL
  • keyword_id (id3) — BIGINT — Foreign key → keyword.id — NOT NULL

scrap

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • state — BOOLEAN — NOT NULL
  • article_id — BIGINT — Foreign key → article.id — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

user

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_name — VARCHAR(63) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL