aucation

Tables (21)

ChatMessage (채팅메세지)

  • message_pk (메세지pk) — bigInt — Primary key — NOT NULL
  • chat_pk (채팅pk) — bigint — Foreign key → chat_room.chat_pk — NOT NULL
  • member_pk (멤버PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • message_content (메세지내용) — varchar(255)
  • message_time (메세지보낸시간) — timestamp

Copy Of ChatMessage (CopyOf채팅메세지)

  • message_pk (메세지pk) — bigInt — Primary key — NOT NULL
  • message_content (메세지내용) — varchar(255)
  • message_time (메세지보낸시간) — timestamp
  • chat_pk (채팅pk) — bigint — Foreign key → chat_room.chat_pk — NOT NULL

Copy Of chat_participant (CopyOf채팅참여자)

  • partici_pk (참여자pk) — bigInt — Primary key — NOT NULL
  • partici_join (입장시간) — timestamp
  • partici_exit (퇴장시간) — timestamp
  • chat_pk (채팅pk) — bigint — Foreign key → chat_room.chat_pk — NOT NULL

alram (알람)

  • alarm_pk (알람PK) — bigint — Primary key — NOT NULL
  • alarm_sender_pk (알람발신자pk) — bigInt — Foreign key → member.member_pk — NOT NULL
  • alarm_receiver_pk (알람수신자pk) — bigInt — Foreign key → member.member_pk — NOT NULL
  • alram_body (알림내용) — varchar(100)
  • alarm_type (알람타입) — varchar(6)
  • alarm_type_pk (알람타입pk) — bigint

auction (경매)

  • auction_pk (경매pk) — bigint — Primary key — NOT NULL
  • auction_owner_pk (등록자pk) — bigInt — Foreign key → member.member_pk — NOT NULL
  • auction_customer_pk (구매자 pk) — bigint
  • auction_status (경매상태) — varchar(9)
  • auction_title (경매 제목) — varchar(42)
  • auction_category (경매 카테고리) — varchar(42)
  • auction_start (경매시작) — datetime
  • auction_end (경매종료) — datetime
  • auction_created_at (경매물품등록일시) — datetime
  • auction_start_price (경매시작가격) — int
  • auction_end_price (경매낙찰가격) — int
  • auction_meeting_lat (물품수령경도) — double
  • auction_meeting_lng (물품수령위도) — double

auction_bid (경매 입찰)

  • auction_bid_pk (경매 입찰 pk) — bigint — Primary key — NOT NULL
  • auction_pk (경매품목pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
  • auction_member_pk (경매입찰자pk) — bigint — Foreign key → member.member_pk — NOT NULL
  • auction_bid_price (경매 입찰 가격) — int
  • auction_bid_datetime (경매 입찰 시간) — datetime

auction_history (경매 낙찰 내역)

  • history_pk (거래내역 pk) — bigint — Primary key — NOT NULL
  • owner_pk (판매자PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • customer_pk (구매자PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • auction_pk (경매pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
  • history_datetime (거래성사일시) — datetime
  • history_done_datetime (거래종료일시) — datetime
  • auction_status (거래상태) — tinyint

chat_participant (채팅참여자)

  • partici_pk (참여자pk) — bigInt — Primary key — NOT NULL
  • member_pk (멤버PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • chat_pk (채팅pk) — bigint — Foreign key → chat_room.chat_pk — NOT NULL
  • partici_join (입장시간) — timestamp
  • partici_exit (퇴장시간) — timestamp

chat_room (채팅)

  • chat_pk (채팅pk) — bigint — Primary key — NOT NULL
  • chat_session (채팅세션) — varchar(15)
  • chat_create (채팅방 생성시간) — timestamp
  • chat_end (채팅방 소멸시간) — timestamp

chat_room (CopyOf채팅)

  • chat_pk (채팅pk) — bigint — Primary key — NOT NULL
  • chat_session (채팅세션) — varchar(15)
  • chat_create (채팅방 생성시간) — timestamp
  • chat_end (채팅방 소멸시간) — timestamp
  • prod_pk (물품 pk) — long
  • prod_type (Field) — int

discount (할인)

  • discount_pk (할인pk) — bigint — Primary key — NOT NULL
  • discount_owner_pk (등록자pk) — bigInt — Foreign key → member.member_pk — NOT NULL
  • discount_custom_pk (구매자pk) — bigInt — Foreign key → member.member_pk — NOT NULL
  • discount_title (할인 제목) — varchar(42)
  • discount_category (할인제품 카테고리) — varchar(42)
  • discount_start (할인시작) — datetime
  • discount_end (할인종료) — datetime
  • discount_detail (할인설명) — text
  • discount_price (할인품정가) — integer
  • discount_discounted_price (할인가) — integer
  • discount_rate (할인률) — integer
  • discount_imgURL (상품이미지) — String
  • discount_created_at (할인등록일시) — datetime
  • discount_UUID (상품고유번호) — String

discountLike (할인좋아요)

  • like_pk (좋아요pk) — bigInt — Primary key — NOT NULL
  • member_pk (멤버PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • like_created_at (좋아요일시) — datetime
  • discount_pk (할인pk) — bigint — Foreign key → discount.discount_pk — NOT NULL

discount_history (할인 거래 내역)

  • history_pk (거래내역 pk) — bigint — Primary key — NOT NULL
  • owner_pk (판매자PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • customer_pk (구매자PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • discount_pk (할인pk) — bigint — Foreign key → discount.discount_pk — NOT NULL
  • history_datetime (거래일시) — datetime
  • history_done_datetime (거래 확정 일시) — datatime

discount_photo (할인사진)

  • dis_photo_pk (사진pk) — bigint — Primary key — NOT NULL
  • img_url (사진url) — varchar(255)
  • discount_pk (할인pk2) — bigint — Foreign key → discount.discount_pk — NOT NULL

like (좋아요)

  • like_pk (좋아요pk) — bigInt — Primary key — NOT NULL
  • auction_pk (경매pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
  • member_pk (멤버PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • like_created_at (좋아요일시) — datetime

member (유저)

  • member_pk (멤버PK) — bigInt — Primary key — NOT NULL
  • member_id (멤버아이디) — varchar(16)
  • member_pw (멤버비밀번호) — varchar(255)
  • member_email (멤버이메일) — varchar(40)
  • member_point (멤버 포인트) — int
  • member_address (멤버주소) — Address
  • member_role (멤버역할) — varchar(5)
  • member_nickname (멤버닉네임) — varchar(25)
  • member_banned (멤버이용가능여부) — tinyint
  • member_refresh (멤버리프레쉬) — varchar(255)
  • member_fcm (멤버 FCM) — varchar(255)
  • member_created_at (멤버 가입일자) — datetime
  • member_update_at (멤버 수정일자) — datetime

member_follow (팔로우 가게)

  • follow_pk (팔로우pk) — bigint — Primary key — NOT NULL
  • shop_pk (팔로우가게PK) — bigint — Foreign key → shop.shop_pk — NOT NULL
  • member_pk (팔로잉멤버PK) — bigInt — Foreign key → member.member_pk — NOT NULL
  • follow_date (팔로우 날짜) — datetime

photo (사진)

  • photo_pk (사진pk) — bigint — Primary key — NOT NULL
  • auction_pk (경매pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
  • img_url (사진url) — varchar(255)

re_auc_bid_photo (CopyOf사진)

  • photo_pk (사진pk) — bigint — Primary key — NOT NULL
  • re_auction_bid_pk (경매 입찰 pk) — bigint — Foreign key → re_auction_bid.re_auction_bid_pk — NOT NULL
  • img_url (사진url) — varchar(255)

re_auction_bid (역경매 입찰)

  • re_auction_bid_pk (경매 입찰 pk) — bigint — Primary key — NOT NULL
  • re_auction_pk (경매품목pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
  • re_auction_member_pk (경매입찰자pk) — bigint — Foreign key → member.member_pk — NOT NULL
  • re_auction_bid_price (경매 입찰 가격) — int
  • re_auction_bid_datetime (경매 입찰 시간) — datetime
  • re_auction_bid_detail (상품 설명) — varchar(255)

shop (가게)

  • shop_pk (가게pk) — bigint — Primary key — NOT NULL
  • shop_owner_pk (가게 사장 pk) — bigInt — Foreign key → member.member_pk — NOT NULL
  • shop_type (가게 종류) — varchar(15)
  • shop_tax_id (가게 사업자 등록번호) — varchar(10)
  • shop_info (가게 설명) — text
  • shop_created_at (가게 시작일) — date
  • shop_is_food (가게 음식여부) — tinyint