ㅂ
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