Link
Tables (11)
Untitled (shared_page)
- Key (page_id) — Long — Primary key — NOT NULL
- Key (pieceId) — Long — Foreign key → piece.Key — NOT NULL
- Key (user_id) — Long — Foreign key → piece.Key — NOT NULL
- url — String
- 생성일 (created_at) — LocalDateTime
alert (Alert)
- Key (alert_id) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → user.Key — NOT NULL
- Field (alert_status) — Boolean
alertInfo (Alert_info)
- Key (alertInfo_id) — Long — Primary key — NOT NULL
- Key (alert_id) — Long — Foreign key → alert.Key — NOT NULL
- Key (user_id) — Long — Foreign key → alert.Key — NOT NULL
- 내용 (content) — String
- action — String
- 생성일 (created_at) — LocalDateTime
- 수정일 (modified_at) — LocalDateTime
category (Category)
- Key (cate_id) — Long — Primary key — NOT NULL
- Key (pieceId) — Long — Foreign key → piece.Key — NOT NULL
- Key (user_id) — Long — Foreign key → piece.Key — NOT NULL
- 카테고리명 (name) — String
- 생성일 (created_at) — LocalDateTime
- 수정일 (modified_at) — LocalDateTime
comment (Comment)
- Key (comment_id) — Long — Primary key — NOT NULL
- Key (list_id) — Long — Foreign key → list.Key — NOT NULL
- Key (cate_id) — Long — Foreign key → list.Key — NOT NULL
- Key (pieceId) — Long — Foreign key → list.Key — NOT NULL
- Key (user_id) — Long — Foreign key → list.Key — NOT NULL
- 내용 (content) — String
- 생성일 (created_at) — LocalDateTime
- 수정일 (modified_at) — LocalDateTime
like (Like)
- Key (like_id) — Long — Primary key — NOT NULL
- Key (list_id) — Long — Foreign key → list.Key — NOT NULL
- Key (cate_id) — Long — Foreign key → list.Key — NOT NULL
- Key (pieceId) — Long — Foreign key → list.Key — NOT NULL
- Key (user_id) — Long — Foreign key → list.Key — NOT NULL
- 좋아요상태 (like_status) — Boolean
- 생성일 (created_at) — LocalDateTime
- 수정일 (modified_at) — LocalDateTime
list (List)
- Key (list_id) — Long — Primary key — NOT NULL
- Key (cate_id) — Long — Foreign key → category.Key — NOT NULL
- Key (pieceId) — Long — Foreign key → category.Key — NOT NULL
- Key (user_id) — Long — Foreign key → category.Key — NOT NULL
- url — String
- 이름 (name) — String
- 시작시간 (start_time) — Integer
- 끝시간 (end_time) — Integer
- 설명 (description) — String
- 좋아요수 (like_count) — Integer
- 사진및 파일 (img) — File
- 댓글 수 (comment_count) — Integer
- 생성일 (created_at) — LocalDateTime
- 수정일 (modified_at) — LocalDateTime
oauth_user (OauthUser)
- Key (oauth_userId) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → user.Key — NOT NULL
- 구글이메일 (email) — String
- 구글닉네임 (nickname) — String
- 생성일 (created_at) — LocalDateTime
piece (Piece)
- Key (pieceId) — Long — Primary key — NOT NULL
- Key (user_id) — Long — Foreign key → user.Key — NOT NULL
- 제목 (title) — String
- 멤버이름 (member) — List
- 색깔 (color) — String
- 출발년도 (start_year) — Integer
- 출발월 (start_month) — Integer
- 출발일 (start_day) — Integer
- 도착년도 (end_year) — Integer
- 도착월 (end_month) — Integer
- 도착일 (end_day) — Integer
- 생성일 (created_at) — LocalDateTime
- 수정일 (modified_at) — LocalDateTime
user (User)
- Key (user_id) — Long — Primary key — NOT NULL
- 이름 (user_name) — String
- 프로필 (profile_img) — File
- 수정일 (modified_at) — LocalDateTime
userPiece (UserPiece)
- Key — Primary key — NOT NULL
- 수정일 (created_at) — LocalDateTime
- pieceId — Long
- userId — Long