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