callbus

Tables (4)

comment (댓글)

  • comment_id (댓글아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • post_id (게시물아이디) — bigint — Foreign key → post.post_id — NOT NULL
  • comment_content (댓글내용) — varchar

member (회원)

  • member_id (회원아이디) — bigint — Primary key — NOT NULL
  • nickname (닉네임) — varchar
  • account_type (계정타입) — varchar
  • account_id (계정ID) — varchar
  • quit (탈퇴여부) — boolean

post (게시물)

  • post_id (게시물아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • post_content (게시물 내용) — varchar

thumb (좋아요)

  • thumb_id (좋아요 아이디) — bigint — Primary key — NOT NULL
  • member_id (회원아이디) — bigint — Foreign key → member.member_id — NOT NULL
  • post_id (게시물아이디) — bigint — Foreign key → post.post_id — NOT NULL
  • is_thumb (좋아요여부) — boolean