B104

Tables (10)

ChatMessage (채팅메세지)

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

ChatParticipant (채팅참여자)

  • 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 → ChatRoom.chat_pk — NOT NULL
  • partici_join (입장시간) — timestamp
  • partici_exit (퇴장시간) — timestamp

ChatRoom (채팅)

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

Member (유저)

  • member_pk (멤버PK) — bigInt — Primary key — NOT NULL
  • member_id (멤버아이디) — varchar(16)
  • member_pw (멤버비밀번호) — varchar(255)
  • member_email (멤버이메일) — varchar(40)
  • member_address (멤버주소) — varchar(50)
  • 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

Shop (가게)

  • shop_pk (멤버PK) — bigint — Primary key — NOT NULL
  • shop_owner_pk (가게 사장 pk) — bigInt — Foreign key → Member.member_pk — NOT NULL
  • shop_name (가게 이름) — varchar(30)
  • shop_type (가게 종류) — varchar(15)
  • shop_tax_id (가게 사업자 등록번호) — varchar(10)
  • shop_created_at (가게 시작일) — date
  • shop_info (가게 설명) — text

auction (경매)

  • auction_pk (경매pk) — bigint — Primary key — NOT NULL
  • auction_owner_pk (등록자pk) — bigInt — Foreign key → Member.member_pk — NOT NULL
  • auction_custom_pk (구매자pk) — bigInt — Foreign key → Member.member_pk — NOT NULL
  • auction_status (경매상태) — varchar(9)
  • auction_title (경매 제목) — varchar(42)
  • auction_object_name (경매 품목) — varchar(42)
  • auction_start (경매시작) — datetime
  • auction_end (경매종료) — datetime
  • auction_type (경태종류) — varchar(9)

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
  • member_pk (판매자PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
  • member_pk (구매자PK) — bigInt — Foreign key → Member.member_pk — NOT NULL
  • auction_pk (경매pk) — bigint — Foreign key → auction.auction_pk — NOT NULL
  • history_datetime (거래일시) — datetime

discount (할인)

  • discount_pk (할인pk) — bigint — Primary key — NOT NULL
  • discount_object (할인품목) — varchar(15)
  • Field