test
Tables (18)
auction_history
- history_id — INT
- status — ENUM('completed', 'canceled')
- item_id — INT
auction_item_images
- image_id — INT
- item_id — INT
- image_url — VARCHAR(255)
- created_at — DATETIME
auction_items
- item_id — INT
- seller_id — INT
- title — VARCHAR(255)
- description — TEXT
- start_price — DECIMAL(10, 2)
- current_price — DECIMAL(10, 2)
- end_time — DATETIME
- status — ENUM('active', 'inactive')
- created_at — DATETIME
- updated_at — DATETIME
bids
- bid_id — INT
- item_id — INT
- bidder_id — INT
- bid_amount — DECIMAL(10, 2)
- bid_time — DATETIME
buyer_rank
- buyer_rank_id — INT
- buyer_rank_name — VARCHAR(255)
- buy_benefits — DECIMAL(10, 2)
consignment
- consignment_id — INT
- transaction_id — INT
- buyer_id — INT
- progress_status — ENUM('in_progress', 'completed', 'canceled')
inquiries
- inquiry_id — INT
- author_id — INT
- title — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- response_status — ENUM('pending', 'answered')
- response — TEXT
market_history
- history_id — INT
- status — ENUM('completed', 'canceled')
- item_id — INT
market_item_images
- image_id — INT
- item_id — INT
- image_url — VARCHAR(255)
- created_at — DATETIME
market_items
- marketitem_id — INT
- title — VARCHAR(255)
- description — TEXT
- price — DECIMAL(10, 2)
- status — ENUM('available', 'sold_out')
- sell_type — ENUM('fixed_price', 'auction')
market_wishlists
- wishlist_id — INT
- user_id — INT
- item_id — INT
- created_at — DATETIME
mileage
- mileage_id — INT
- user_id — INT
- amount — DECIMAL(10, 2)
- created_at — DATETIME
oauth_info
- id — BIGINT
- user_id — INT
- provider — VARCHAR(255)
- created_at — TIMESTAMP
seller_rank
- seller_rank_id — INT
- seller_rank_name — VARCHAR(255)
- seller_benefits — DECIMAL(10, 2)
transaction_info
- transaction_id — INT
- buyer_id — INT
- buyer_address1 — VARCHAR(255)
- seller_address2 — VARCHAR(255)
- buyer_phone — VARCHAR(255)
- seller_phone — VARCHAR(255)
- seller_id — INT
- tracking_number1 — VARCHAR(255)
- tracking_number2 — VARCHAR(255)
- tracking_number3 — VARCHAR(255)
- tracking_number4 — VARCHAR(255)
users
- user_id — INT
- name — VARCHAR(255)
- nickname — VARCHAR(255)
- username — VARCHAR(255)
- password — VARCHAR(255)
- phone — VARCHAR(255)
- email — VARCHAR(255)
- address — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- seller_rank — INT
- buyer_rank — INT
virtual_market
- market_id — INT
- seller_id — INT
- created_at — DATETIME
- updated_at — DATETIME
- item_count — INT
- rating — DECIMAL(3, 2)
wishlists
- wishlist_id — INT
- user_id — INT
- item_id — INT
- created_at — DATETIME