INSK_DB_ERD
Tables (4)
article_analyses
- analysis_id — BIGINT — Primary key — NOT NULL
- article_id — BIGINT — Foreign key → articles.article_id — NOT NULL
- summary — TEXT — NOT NULL
- insight — TEXT
- category — VARCHAR(50)
- tags — VARCHAR(255)
- created_at — DATETIME — NOT NULL
articles
- article_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- original_url — VARCHAR(512) — NOT NULL
- published_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
keywords
- keyword_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- keyword — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL