project 1

Tables (3)

Like (Untitled2)

  • like_id (Key3) — Primary key — NOT NULL
  • member_id (Key) — Foreign key → Member.member_id — NOT NULL
  • post_id (Key2) — Foreign key → Post.post_id — NOT NULL
  • reaction (Field) — enum
  • created_at (Field2)

Member (Untitled)

  • member_id (Key) — Primary key — NOT NULL

Post (Untitled3)

  • post_id (Key2) — Primary key — NOT NULL
  • member_id (Key) — Foreign key → Member.member_id — NOT NULL
  • like (Field)
  • like_cumulative_sum (Field3)
  • is_delete (Field2)
  • content (Field4)
  • title (Field5)
  • created_at (Field6)
  • modified_at (Field7)