뉴스야 ERD
테이블 (6)
Article (Untitled)
- id (Key) — INT — 기본 키 — NOT NULL
- category_id (Key2) — INT — 외래 키 → Category.id — NOT NULL
- title (Field) — VARCHAR(45)
- content (Field2) — VARCHAR(3000)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
- image (Field5) — VARCHAR(1000)
Category (Untitled2)
- id (Key) — INT — 기본 키 — NOT NULL
- created_at (Field) — DATETIME
- updated_at (Field2) — DATETIME
- category (Field3) — VARCHAR(45)
Comment (Untitled4)
- id (Key) — INT — 기본 키 — NOT NULL
- content (Field) — VARCHAR(256)
- news_id (Key2) — INT — 외래 키 → Article.id — NOT NULL
- user_id (Key3) — INT — 외래 키 → User.id — NOT NULL
- updated_at (Field4) — DATETIME
- created_at (Field5) — DATETIME
- nickname (Field2) — VARCHAR(150)
Dislike (Untitled6)
- id (Key) — INT — 기본 키 — NOT NULL
- news_dislike_yn (Field) — BIGINT
- comment_dislike_yn (Field2) — BIGINT
- news_id (Key2) — INT — 외래 키 → Article.id — NOT NULL
- user_id (Key3) — INT — 외래 키 → User.id — NOT NULL
- comment_id (Key4) — INT — 외래 키 → Comment.id — NOT NULL
Like (Untitled5)
- id (Key) — INT — 기본 키 — NOT NULL
- news_like_yn (Field) — BIGINT
- news_id (Key2) — INT — 외래 키 → Article.id — NOT NULL
- user_id (Key3) — INT — 외래 키 → User.id — NOT NULL
- comment_like_yn (Field2) — BIGINT
- comment_id (Key4) — INT — 외래 키 → Comment.id — NOT NULL
User (Untitled3)
- id (Key) — INT — 기본 키 — NOT NULL
- login_id (Field) — VARCHAR(45)
- password (Field2) — VARCHAR(256)
- name (Field3) — VARCHAR(45)
- email (Field4) — VARCHAR(45)
- nickname (Field5) — VARCHAR(45)
- phone_number (Field6) — VARCHAR(45)
- created_at (Field7) — DATETIME
- updated_at (Field8) — DATETIME