sns

Tables (3)

follow

  • id — bigint — Primary key — NOT NULL
  • Field
  • id (id2) — bigint — Foreign key → user.id — NOT NULL
  • id (id3) — bigint — Foreign key → user.id — NOT NULL

post

  • Key (post) — bigint — Primary key — NOT NULL
  • Field (title) — String(100) — NOT NULL
  • Field (detail) — String(10000) — NOT NULL
  • Field (like) — bigint — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • (username) — String(50) — NOT NULL
  • Field (password) — String(50) — NOT NULL
  • Field (nickname) — String(50) — NOT NULL
  • Field (gender) — enum — NOT NULL
  • Field (age) — int — NOT NULL
  • Field (favourite) — String(50) — NOT NULL
  • Key (post) — bigint — Foreign key → post.Key — NOT NULL
  • Field (deleted_at) — timestamp
  • Field2 (updated_at) — timestamp
  • Field
  • Field2 (follow_count) — bigint — NOT NULL
  • Field3 (following_count) — bigint — NOT NULL