뉴스야 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