project

Tables (5)

Comment (comment)

  • comment_id (Key) — Long — Primary key — NOT NULL
  • post_id (Key2) — Long — Foreign key → POST.post_id — NOT NULL
  • member_id (Key22) — Foreign key → POST.member_id — NOT NULL
  • member_id (Field) — Long
  • content (Field2) — String
  • createdAt (Field4) — String
  • modifiedAt (Field5) — String
  • like_count (Field6) — Integer

Comment_like

  • comment_like_id (Key) — Long — Primary key — NOT NULL
  • comment_id (Key2) — Long — Foreign key → Comment.comment_id — NOT NULL
  • post_id (Key22) — Long — Foreign key → Comment.post_id — NOT NULL
  • member_id (Key222) — Foreign key → Comment.member_id — NOT NULL
  • comment_id (Field2) — Long
  • member_id (Field3)

Member

  • member_id (Key) — Primary key — NOT NULL
  • nickname (Field) — String
  • password (Field2) — int
  • username (Field3) — String

POST

  • post_id (Key) — Long — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL
  • member_id (Field2) — long
  • title (Field3) — String
  • imageUrl (Field4) — String
  • createdAt (Field5) — String
  • modifiedAt (Field6) — String
  • comment_id (Field7) — Long
  • like_count (Field8) — Integer

Post_like

  • post_like_id (Key) — Long — Primary key — NOT NULL
  • post_id (Key2) — Long — Foreign key → POST.post_id — NOT NULL
  • member_id (Key22) — Foreign key → POST.member_id — NOT NULL
  • post_id (Field2) — Long
  • member_id (Field3) — Long