yumsnap

Tables (7)

Comment_Likes (댓글 좋아요)

  • id (좋아요 ID) — bigint — Primary key — NOT NULL
  • member_id (회원 ID) — bigint
  • comment_id (댓글 ID) — bigint
  • create_date (생성 날짜) — timestamp
  • last_update_date (수정 날짜) — timestamp
  • is_delete (삭제) — boolean

Comments (댓글)

  • id (댓글 ID) — bigint — Primary key — NOT NULL
  • member_id (작성자 ID) — bigint
  • post_id (게시글 ID) — bigint
  • create_date (생성 시간) — timestamp
  • last_update_date (수정 시간) — timestamp
  • like_count (좋아요 수) — int
  • parent_comment_id (부모 댓글 ID) — bigint
  • is_delete (삭제) — boolean

Follows (팔로우)

  • id (팔로우 ID) — bigint — Primary key — NOT NULL
  • follower_id (팔로워 회원 ID) — bigint
  • following_id (팔로잉 회원 ID) — bigint
  • create_date (생성 날짜) — timestamp
  • last_update_date (수정 날짜) — timestamp
  • is_delete (삭제) — boolean

Members (회원)

  • id (회원 ID) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • nickname (이름) — varchar
  • role (권한) — enum
  • password (비밀번호) — varchar
  • phone_number (전화번호) — varchar
  • oath2_provider (oauth2 제공자) — varchar
  • oauth2_username (oauth2 회원 식별값) — varchar
  • create_date (생성 시간) — timestamp
  • last_update_date (수정 시간) — timestamp
  • is_profile_public (프로필 공개 여부) — boolean
  • is_deleted (삭제) — boolean

Post_Likes (게시글 좋아요)

  • id (좋아요 ID) — bigint — Primary key — NOT NULL
  • member_id (회원 ID) — bigint
  • post_id (게시글 ID) — bigint
  • create_date (생성 날짜) — timestamp
  • last_update_date (수정 날짜) — timestamp
  • is_delete (삭제)

Posts (게시글)

  • id (게시글 ID) — bigint — Primary key — NOT NULL
  • member_id (작성자 ID) — bigint
  • content (글) — varchar
  • view_count (조회수) — bigint
  • like_count (좋아요 수) — int
  • create_date (생성 시간) — timestamp
  • last_update_date (수정 시간) — timestamp
  • is_deletet (삭제) — boolean

RefreshToken (Untitled)

  • id (토큰 ID) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • tokenValue (토큰 값) — varchar
  • expiration (만료) — varchar
  • create_date (생성 시간) — timestamp
  • last_update_date (수정 시간) — timestamp