Bibid Copy

Tables (19)

Chat

  • chat_index — bigint — Primary key — NOT NULL
  • member_index — BigInt — Foreign key → member.member_index — NOT NULL — 채팅보낸사람
  • chatroom_id — bigint — NOT NULL
  • chat_message — varchar — NOT NULL
  • send_time — LocalDateTime — NOT NULL

ChatRoom

  • chatroom_id — bigint — Primary key — NOT NULL
  • auction_id — bigint — NOT NULL
  • room_name — varchar
  • strat_time — localDateTime
  • end_time — localDateTime

ChatRoom_management

  • chatroom_magagement_id — bigint — Primary key — NOT NULL
  • chatroom_id — bigint — NOT NULL
  • participant_id — bigint — NOT NULL
  • join_time — LocalDateTime
  • leave_time — LocalDateTime

QnA

  • qna_id — VARCHAR(255) — Primary key — NOT NULL
  • user_idx — BigInt — Foreign key → member.member_index — NOT NULL
  • qna_title — varchar — NOT NULL
  • qna_content — varchar — NOT NULL

QnA_file

  • file_name — VARCHAR(255) — Primary key — NOT NULL
  • qna_id — VARCHAR(255) — Foreign key → QnA.qna_id — NOT NULL
  • user_idx — BigInt — Foreign key → QnA.user_idx — NOT NULL
  • file_origin_name — VARCHAR(255)
  • Field2 — VARCHAR(255)

account

  • user_index — BigInt — Foreign key → member.member_index — NOT NULL
  • user_money — BigInt — NOT NULL

account_use_history

  • user_index — BigInt — Foreign key → account.user_index — NOT NULL
  • history_index — BigInt — NOT NULL
  • use_type — enum — NOT NULL
  • auction_id — bigint — NOT NULL
  • change_account — VARCHAR(255) — NOT NULL

address

  • user_address — varchar — NOT NULL
  • type_address — varchar — NOT NULL
  • base_address — varchar — NOT NULL
  • detail_address — varchar — NOT NULL
  • receiver_name — varchar — NOT NULL
  • receiver_pnum — int — NOT NULL
  • is_default — boolean — NOT NULL

auction

  • auction_id — bigint — Primary key — NOT NULL
  • member_index — bigint — NOT NULL
  • auction_type — varchar — NOT NULL — '실시간 경매', '블라인드 경매
  • 일반 — 경매'', — NOT NULL — 아이템 카테고리 ex) 도서
  • subcategory — varchar — NOT NULL
  • product_name — varchar — NOT NULL
  • product_description — varchar — NOT NULL
  • starting_price — bigint — NOT NULL
  • starting_LocalDateTime — LocalDateTime — NOT NULL
  • ending_LocalDateTime — LocalDateTime — NOT NULL
  • bid_increment — bigint — NOT NULL
  • instant_purchase_enabled — boolean
  • instant_purchase_price — long
  • auto_reauction_enabled — boolean — 일반경매 에서 낙찰안될 때 자동 경매 재등록
  • reauction_starting_price — bigint
  • auction_status — varchar — '준비중', '진행중
  • 완료, — `view_cnt`

auction_detail

  • auction_id — bigint — Foreign key → auction.auction_id — NOT NULL
  • shipping_method — varchar — '택배', '우편
  • 직거래, — `cost_responsibility` — '선불
  • 착불, — `winner_id`

auction_image

  • id — bigint — Primary key — NOT NULL
  • auction_id — bigint — Foreign key → auction.auction_id — NOT NULL
  • filename — varchar — NOT NULL
  • filepath — varchar — NOT NULL
  • fileoriginname — varchar — NOT NULL
  • filetype — varchar — NOT NULL
  • filestatus — varchar — NOT NULL
  • newfilename — varchar — NOT NULL
  • filesize — bigint
  • isthumbnail — boolean — NOT NULL

auction_info

  • auction_info_id — bigint — Primary key — NOT NULL
  • auction_id — bigint — NOT NULL
  • bidder_id — bigint
  • bid_time — LocalDateTime — NOT NULL
  • bid_amount — BigInt — NOT NULL

evaluation

  • evaluation_index — bigint — Primary key — NOT NULL
  • member_index — BigInt — Foreign key → member.member_index — NOT NULL
  • evaluation_item — varchar — NOT NULL
  • evaluation_rate — int — NOT NULL

liked_auction

  • member_index — BigInt — Foreign key → member.member_index — NOT NULL
  • auction_id — bigint — Foreign key → auction.auction_id — NOT NULL

member

  • member_index — BigInt — Primary key — NOT NULL
  • member_id — varchar — NOT NULL
  • member_pw — varchar — NOT NULL
  • name — varchar — NOT NULL
  • nickname — varchar — NOT NULL
  • member_address — varchar — NOT NULL
  • address_detail — varchar
  • member_pnum — varchar — NOT NULL
  • email — varchar — NOT NULL
  • role — Enum — NOT NULL — user/admin
  • profile_url — varchar — 삭제예정 컬럼

member_detail

  • member_index — BigInt — Foreign key → member.member_index — NOT NULL
  • business_name — varchar
  • Business_classification — varchar
  • sales_declaration — varchar
  • business_registration_num — varchar
  • exponent — varchar
  • business_location — varchar
  • sales_cnt — bigint

notification

  • alert_idx — bigint — Primary key — NOT NULL
  • alert_title — varchar — NOT NULL
  • alert_content — varchar — NOT NULL
  • alert_date — LocalDate
  • view_ed — boolean — NOT NULL — N/Y
  • alert_cat — varchar — NOT NULL — 아마주로 경매알림

profile_image

  • member_index — BigInt — Foreign key → member.member_index — NOT NULL
  • p_filename — varchar — NOT NULL
  • p_filepath — varchar — NOT NULL
  • p_filetype — varchar — NOT NULL
  • p_filesize — bigint — NOT NULL
  • p_originalname — varchar — NOT NULL
  • p_filestatus — varchar — NOT NULL
  • p_newfilename — varchar — NOT NULL

streaming

  • streaming_index — bigint — Primary key — NOT NULL
  • auction_id — bigint — NOT NULL
  • stream_url — varchar — NOT NULL
  • channel_id — varchar
  • channel_name — varchar
  • channel_status — varchar
  • cdn_instance_no — varchar
  • cdn_status — varchar
  • publish_url — varchar
  • stream_key — varchar
  • start_time — LocalDateTime
  • end_time — LocalDateTime