Auction 2

Tables (13)

Auction

  • auction_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • seller_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • starting_price — DECIMAL(10, 2) — NOT NULL
  • current_price — DECIMAL(10, 2) — NOT NULL
  • reserve_price — DECIMAL(10, 2)
  • buy_now_price — DECIMAL(10, 2)
  • is_featured — BOOLEAN
  • view_count — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

AuctionBoard

  • board_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • author_id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

AuctionHistory

  • history_id — INT — Primary key
  • auction_id (auction_id2) — INT — Foreign key → Auction.auction_id
  • user_id (user_id2) — INT — Foreign key → Auction.user_id
  • auction_id — INT — NOT NULL
  • final_bidder_id — INT
  • final_price — DECIMAL(10, 2)
  • outcome_status — VARCHAR(20) — NOT NULL
  • end_date — DATETIME — NOT NULL
  • total_bids — INT
  • starting_price — DECIMAL(10, 2) — NOT NULL
  • highest_bid — DECIMAL(10, 2)
  • lowest_bid — DECIMAL(10, 2)
  • cancellation_reason — TEXT
  • created_at — DATETIME — NOT NULL

AuctionReservation

  • reservation_id — INT — Primary key
  • user_id (user_id2) — INT — Foreign key → User.user_id
  • user_id — INT — NOT NULL
  • auction_id — INT — NOT NULL
  • planned_start_time — DATETIME — NOT NULL
  • planned_end_time — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

Bid

  • bid_id — INT — Primary key
  • auction_id (auction_id2) — INT — Foreign key → Auction.auction_id
  • user_id (user_id2) — INT — Foreign key → Auction.user_id
  • auction_id — INT — NOT NULL
  • bidder_id — INT — NOT NULL
  • bid_amount — DECIMAL(10, 2) — NOT NULL
  • bid_time — DATETIME — NOT NULL

ChatMessage (Chat)

  • chat_id — INT — Primary key
  • room_id (room_id2) — VARCHAR(255) — Foreign key → Room.room_id
  • user_id — INT — Foreign key → Room.user_id
  • auction_id — INT — NOT NULL
  • sender_id — INT — NOT NULL
  • message — TEXT — NOT NULL
  • sent_at — DATETIME — NOT NULL
  • room_id — INT

Notification

  • notification_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • recipient_id — INT — NOT NULL
  • auction_id — INT
  • message — TEXT — NOT NULL
  • notification_type — VARCHAR(50) — NOT NULL
  • is_read — BOOLEAN
  • created_at — DATETIME — NOT NULL

Product

  • product_id — INT — Primary key
  • auction_id — INT — Foreign key → Auction.auction_id
  • seller_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

ProductImage

  • image_id — INT — Primary key
  • product_id (product_id2) — INT — Foreign key → Product.product_id
  • product_id — INT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • uploaded_at — DATETIME — NOT NULL

Room

  • room_id — VARCHAR(255) — Primary key
  • user_id — INT — Foreign key → User.user_id
  • type — INT

Transaction

  • transaction_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • auction_id (auction_id2) — INT — Foreign key → Auction.auction_id
  • user_id (user_id2) — INT — Foreign key → Auction.user_id
  • auction_id — INT — NOT NULL
  • buyer_id — INT — NOT NULL
  • seller_id — INT — NOT NULL
  • transaction_amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

User

  • user_id — INT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

bidMessage

  • user_id — INT — Primary key — NOT NULL
  • room_id — VARCHAR(255) — Foreign key → Room.room_id
  • user_id (user_id2) — INT — Foreign key → Room.user_id
  • sent_at — DATETIME