ㅂ

Tables (24)

Auction

  • auctionId — bigint — Primary key — NOT NULL
  • auctionUUID — varchar — NOT NULL
  • userId — bigint — NOT NULL — 경매를 올린 사람
  • minBidAmount — bigint — NOT NULL — 최솟값 100000
  • meetingDate — datetime — NOT NULL — 날짜 + 만남 시작 시간
  • meetingLocation — varchar — NOT NULL
  • meetingInfoText — longtext — NOT NULL — 이 만남은 이런거에요
  • meetingPromiseText — longtext — NOT NULL — 이것 만큼은 지켜주세요
  • meetingInfoImg — varchar
  • meetingPromiseImg — varchar
  • currentHighestBidAmount — bigint — NOT NULL
  • currentHighestBidderId — varchar
  • bidCount — bigint — NOT NULL — 입찰수를 경매기록에서 카운트 하는것보다 입찰이 발생했을 때 카운트 업이 괜찮을듯
  • auctionType — enum(진행중, 취소, 낙찰, 유찰) — NOT NULL — progress, cancel, success, invalidity
  • auctionCloseTime — datetime — NOT NULL
  • isExtended — boolean — NOT NULL

AuctionReport

  • auctionReportId — bigint — Primary key — NOT NULL
  • auctionReportUUID — varchar — NOT NULL
  • auctionId — bigint — Foreign key — NOT NULL
  • auctionReportNickname — varchar — NOT NULL
  • auctionReportContent — longtext — NOT NULL
  • auctionReportStatus — enum(refusal, standby, approve) — NOT NULL — 대기, 승인, 반려

Ban

  • banId — bigint — Primary key — NOT NULL
  • banUUID — varchar — NOT NULL
  • userId — bigint — Foreign key — NOT NULL
  • kakaoId — varchar — NOT NULL

Banner

  • bannerId — bigint — Primary key — NOT NULL
  • bannerUUID — varchar — NOT NULL
  • bannerImgUrl — varchar — NOT NULL
  • targetUrl — varchar

Bid

  • bidId — bigint — Primary key — NOT NULL
  • bidUUID — varchar — NOT NULL
  • auctionId — bigint — NOT NULL
  • bidderNickname — varchar — NOT NULL
  • bidAmount — bigint — NOT NULL

ChatMessage

  • chatMessageId — bigint — Primary key — NOT NULL
  • chatMessageUUID — varchar — NOT NULL
  • chatRoomId — bigint — Foreign key — NOT NULL
  • senderNickname — varchar — NOT NULL
  • chatContent — longtext — NOT NULL

ChatReport

  • chatReportId — bigint — Primary key — NOT NULL
  • chatReportUUID — varchar — NOT NULL
  • chatRoomId — bigint — Foreign key — NOT NULL
  • chatReportNickname — varchar — NOT NULL — 신고한 사람
  • chatReportTargetNickname — varchar — NOT NULL — 신고 대상자
  • chatReportContent — longtext — NOT NULL
  • chatReportStatus — enum(refusal, standby, approve) — NOT NULL — 대기, 승인, 반려

ChatRoom

  • chatRoomId — bigint — Primary key — NOT NULL
  • charRoomUUID — varchar — NOT NULL
  • ticketId — bigint — NOT NULL
  • chatRoomIsOpened — boolean — NOT NULL — 채팅방 열림 닫힘 필드

DonationLog

  • donationLogId — bigint — Primary key — NOT NULL
  • donorNickname — varchar — NOT NULL
  • donationPrice — decimal — NOT NULL
  • totalDonationPrice — decimal — NOT NULL

Exchange

  • exchangeId — bigint — Primary key — NOT NULL
  • exchangeUUID — varchar — NOT NULL
  • userId — bigint — NOT NULL
  • exchangePoint — bigint — NOT NULL
  • exchangeAccount — varchar — NOT NULL
  • exchangeBank — varchar — NOT NULL
  • exchangeAccountHolder — varchar — NOT NULL
  • exchangeStatus — enum(refusal, standby, approve) — NOT NULL — 반려, 대기중,승인

FaQ

  • faqId — bigint — Primary key — NOT NULL
  • faqUUID — varchar — NOT NULL
  • faqTitle — varchar — NOT NULL
  • faqContent — longtext — NOT NULL

Follow

  • followId — bigint — Primary key — NOT NULL
  • followUUID — varchar — NOT NULL
  • followerId — varchar — NOT NULL — 팔로우를 하는 사람, 즉 팔로우하는 주체
  • followingId — varchar — NOT NULL — 팔로우 받는 사람, 즉 팔로우의 대상이 되는 사람

PaymentsInfo

  • paymentId — bigint — Primary key — NOT NULL
  • paymentUUID — varchar — NOT NULL
  • userId — bigint — Foreign key — NOT NULL
  • paymentAmount — bigint — NOT NULL

PointLog

  • pointLogId — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key — NOT NULL
  • pointLogUUID — varchar — NOT NULL
  • transactionType — enum(deposit, withdrawal) — NOT NULL — 입금, 출금
  • pointOriginType — enum(auction_registration_deposit, bid, vip_auction_cancel, admin_auction_cancel, winner_ticket_cancel, organizer_ticket_cancel, ticket_complete, charge, exchange) — NOT NULL — 경매등록보증금, 응찰, 경매 취소(vip), 경매 취소(admin), 식사권취소(낙찰자), 식사권취소(주최자), 식사완료, 충전, 환전
  • point — decimal — NOT NULL — 사용자에게 적용되는 포인트 값 (수수료, 기부 제외)
  • totalUserPoint — decimal — NOT NULL — 해당 거래 이후 총 사용자 포인트

Review

  • reviewId — bigint — Primary key — NOT NULL
  • reviewUUID — varchar — NOT NULL
  • writerId — bigint — NOT NULL — 내가 쓴 리뷰 조회 시 지정할 조건
  • receiverId — bigint — NOT NULL — 내가 받은 리뷰 조회 시 지정할 조건
  • ticketId — bigint — NOT NULL — 경매 날짜 및 장소 접근
  • reviewContent — longtext — NOT NULL
  • reviewRating — int — NOT NULL — 1 ~ 5 사이의 자연수
  • isShowed — boolean — NOT NULL

ReviewReport

  • reviewReportId — bigint — Primary key — NOT NULL
  • reviewReportUUID — varchar — NOT NULL
  • reviewId — bigint — Foreign key — NOT NULL
  • reviewReportContent — longtext — NOT NULL
  • reviewReportStatus — enum(refusal, standby, approve) — NOT NULL — 대기, 승인, 반려

ScheduledTask

  • scheduledTaskId — bigint — Primary key — NOT NULL
  • auctionId — bigint — NOT NULL
  • userId — bigint — NOT NULL
  • scheduledTime — datetime — NOT NULL
  • taskType — enum(진행 전, 완료, 취소) — NOT NULL — standby, complete, cancel

Ticket

  • ticketId — bigint — Primary key — NOT NULL
  • ticketUUID — varchar — NOT NULL
  • auctionId — bigint — NOT NULL
  • winnerId — bigint — NOT NULL — 낙찰자
  • organizerId — bigint — NOT NULL — 경매 주최자
  • ticketIsOpened — boolean — NOT NULL
  • winnerIsPushed — boolean — NOT NULL
  • organizerIsPushed — boolean — NOT NULL

TicketMeetingTime

  • ticketMeetingTimeId — bigint — Primary key — NOT NULL
  • ticketMeetingTimeUUID — varchar — NOT NULL
  • ticketId — bigint — Foreign key — NOT NULL
  • userNickname — varchar — NOT NULL
  • startMeetingTime — datetime — NOT NULL

TicketReport

  • ticketReportId — bigint — Primary key — NOT NULL
  • ticketReportUUID — varchar — NOT NULL
  • ticketId — bigint — NOT NULL
  • ticketReportNickname — varchar — NOT NULL
  • ticketReportContent — longtext — NOT NULL
  • ticketReportEvidenceUrl — varchar — NOT NULL
  • ticketReportStatus — enum(refusal, standby, approve) — NOT NULL — 대기, 승인, 반려

User

  • userId — bigint — Primary key — NOT NULL
  • kakaoId — varchar — NOT NULL — 카카오톡의 사용자 고유번호를 그대로 사용할 예정
  • name — varchar — NOT NULL
  • nickname — varchar — NOT NULL
  • phone — varchar — NOT NULL
  • email — varchar — NOT NULL
  • userType — enum(admin, vip, basic) — NOT NULL
  • point — decimal — NOT NULL
  • profileImgUrl — varchar — NOT NULL — 카카오톡 로그인시 전달받는 프로파일 이미지 사용
  • donationPrice — bigint — NOT NULL
  • rating — double
  • subscribeExpiration — datetime — null 혹은 구독 기간이 끝났을 경우 구독 유도
  • warningCount — int — NOT NULL — 3이면 영구정지

VipInfo

  • vipInfoId — bigint — Primary key — NOT NULL
  • vipInfoUUID — varchar — NOT NULL
  • userId — bigint — NOT NULL
  • vipName — varchar — NOT NULL
  • vipJob — varchar — NOT NULL
  • vipCareer — longtext — NOT NULL
  • vipIntroduce — longtext — NOT NULL
  • vipApproval — enum(refusal, standby, approve) — NOT NULL — 반려, 대기중,승인
  • vipEvidenceUrl — varchar — NOT NULL — pdf 파일 하나로 한정

Wallet

  • walletId — bigint — Primary key — NOT NULL
  • walletUUID — varchar — NOT NULL
  • totalDonationPrice — bigint — NOT NULL
  • currentCash — bigint — NOT NULL — 관리자가 보유한 현금을 나타냄 사용자가 포인트 충전 혹은 출금을 했을 경우에만 변동

Warning

  • warningId — bigint — Primary key — NOT NULL
  • warningUUID — varchar — NOT NULL
  • userId — bigint — Foreign key — NOT NULL
  • warningContent — longtext — NOT NULL