최종프로젝트

테이블 (11)

Address (Value Type)

  • String (detailAddress)
  • String(5) (zipcode)

BasicBoard (basic_board)

  • Long (id) — 외래 키 → Board.Long — NOT NULL
  • String (imageUrl)

Board (board)

  • Long (id) — 기본 키 — NOT NULL
  • Long (userId) — 외래 키 → User.Long — NOT NULL
  • LocalDateTime (createdDate)
  • LocalDateTime (modifiedDate)
  • Category (category)
  • String (title)
  • String (content)

BoardLike (board_like)

  • Long (id) — 기본 키 — NOT NULL
  • Long (userId) — 외래 키 → User.Long — NOT NULL
  • Long (boardId) — 외래 키 → Board.Long — NOT NULL

Comment (comment)

  • Long (id) — 기본 키 — NOT NULL
  • Long (userId) — 외래 키 → User.Long — NOT NULL
  • Long (boardId) — 외래 키 → Board.Long — NOT NULL
  • LocalDateTime (createdDate)
  • LocalDateTime (modifiedDate)
  • String (content)
  • Boolean (adoptStatus)

CommentLike (comment_like)

  • Long (id) — 기본 키 — NOT NULL
  • Long (userId) — 외래 키 → User.Long — NOT NULL
  • Long (commentId) — 외래 키 → Comment.Long — NOT NULL

GiftCard (gift_card)

  • Long (id) — 기본 키 — NOT NULL
  • String (name)
  • String (details)
  • String (imageUrl)
  • Int (price)
  • String (giftCardOrderNumber)

Order (orders)

  • Long (id) — 기본 키 — NOT NULL
  • Long (userId) — 외래 키 → User.Long — NOT NULL
  • Long (giftCardId) — 외래 키 → GiftCard.Long — NOT NULL
  • int (purchasePrice)
  • String (phoneNumber)
  • String (giftCardOrderNumber) — 나중에 기프티콘 회사쪽에 주문넣을때 필요한 '기프티콘 주문번호'
  • OrderStatus (orderStatus)

QuestionBoard (question_board)

  • Long (id) — 외래 키 → Board.Long — NOT NULL
  • String (imageUrl)
  • int (prizePoint)
  • Boolean (adoptStatus)

Scrap (scrap)

  • Long (id) — 기본 키 — NOT NULL
  • Long (userId) — 외래 키 → User.Long — NOT NULL
  • Long (boardId) — 외래 키 → Board.Long — NOT NULL

User (users)

  • Long (id) — 기본 키 — NOT NULL
  • String (username)
  • String (password)
  • UserRole (userRole)
  • String (realName)
  • String (nickname)
  • String (profileImageUrl)
  • String (email)
  • String (phoneNumber)
  • Address (address)
  • LocalDateTime (createdDate)
  • LocalDateTime (withdrawnDate)
  • Boolean (withdrawal)
  • int (giftPoint)
  • int (respectPoint)