post

Tables (3)

comment (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • post_id (Key2) — bigint — Foreign key → post.id — NOT NULL
  • member_id (Key3) — bigint — Foreign key → member.id — NOT NULL
  • comment_content (Field) — varchar(200)
  • comment_like (Field2) — bigint
  • create_at (Field3) — datetime

member (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(40)
  • password (Field2) — varchar(60)
  • create_at (Field3) — datetime

post (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • title (Field2) — varchar(50)
  • content (Field3) — text
  • view_count (Field4) — bigint
  • like_count (Field5) — bigint
  • bad_count (Field6) — bigint
  • created_at (Field) — datetime