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