sparta_auction
Tables (11)
Admin
- admin_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
Auction
- auction_id — BIGINT
- seller_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- start_price — DECIMAL(10, 2) — NOT NULL
- instant_buy_price — DECIMAL(10, 2)
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- status — ENUM('ONGOING', 'ENDED', 'CLOSED')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
AuctionImage
- image_id — BIGINT
- auction_id — BIGINT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
Bid
- bid_id — BIGINT
- auction_id — BIGINT — NOT NULL
- bidder_id — BIGINT — NOT NULL
- bid_price — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
Category
- category_id — BIGINT
- name — VARCHAR(100) — NOT NULL
Notification
- notification_id — BIGINT
- user_id — BIGINT — NOT NULL
- message — TEXT — NOT NULL
- sent_at — TIMESTAMP
Order
- order_id — BIGINT
- auction_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- status — ENUM('PENDING', 'SHIPPING', 'DELIVERED')
- tracking_number — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Report
- report_id — BIGINT
- reporter_id — BIGINT — NOT NULL
- reported_user_id — BIGINT
- auction_id — BIGINT
- reason — TEXT — NOT NULL
- created_at — TIMESTAMP
Review
- review_id — BIGINT
- seller_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP
User
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- profile_image — VARCHAR(255)
- points — DECIMAL(10, 2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Wishlist
- wishlist_id — BIGINT
- user_id — BIGINT — NOT NULL
- auction_id — BIGINT — NOT NULL
- created_at — TIMESTAMP