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