community

Tables (4)

Untitled (member)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (nickname) — varchar — NOT NULL
  • Field (email) — varchar(320) — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

Untitled (post)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (content) — varchar — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

Untitled (comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varchar — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

Untitled (post_image)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (url) — varchar — NOT NULL
  • Field (display_order) — int — NOT NULL