sopt_assignment

Tables (3)

Untitled (Post)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar(50) — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (board_type) — varchar(20) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field (deleted_atd) — datetime
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (User)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (nickname) — varchar(10) — NOT NULL
  • Field2 (email) — varchar(100) — NOT NULL

Untitled (Likes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL