우리집 주인님

테이블 (4)

Untitled (User)

  • Key (id) — 기본 키 — NOT NULL
  • Field (userid)
  • Field (password)
  • Field (email)
  • Field (img)
  • Field (nickname)

Untitled (Post)

  • Key (id) — 기본 키 — NOT NULL
  • Field (title)
  • Field (content)
  • Field (img)
  • Field (created_at)
  • Field (updated_at)
  • Key (userid) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (id) — 기본 키 — NOT NULL
  • Field (content)
  • Field (created_at)
  • Field (updated_at)
  • Key (userid) — 외래 키 → Untitled.Key — NOT NULL
  • Key (postid) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Like)

  • Key (id) — 기본 키 — NOT NULL
  • Field (post_id)
  • Field (user_id)
  • Field (created_at)