board

Tables (3)

comment (Untitled3)

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

member (Untitled)

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

post (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(50)
  • content — TEXT
  • viewcount — bigint
  • like_count — bigint
  • bad_count — bigint
  • create_at (created_at) — datetime