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