CRUD

Tables (3)

Untitled (Member)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (e-mail) — String
  • Field (password) — String

Untitled (Post)

  • Key (id) — Long — Primary key — NOT NULL — PK
  • Key (member_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — String
  • Field (date) — DATE
  • Field (like) — int

Untitled (Comment)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (member_id) — Member — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — Post — Foreign key → Untitled.Key — NOT NULL — PK
  • Field (contents) — String