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