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