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