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