auction_test

Tables (13)

auction_categories

  • category_id — INT
  • category_name — VARCHAR(255) — NOT NULL

auction_participants

  • auction_id — INT
  • user_id — INT
  • created_at — TIMESTAMP

auction_post (auctions)

  • auction_post_id — BIGINT
  • seller_id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • product_id — BIGINT
  • starting_price — DECIMAL(10, 2) — NOT NULL
  • min_bid_increament — DECIMAL(10, 2)
  • start_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

auction_results

  • result_id — INT
  • auction_id — INT
  • winner_id — INT
  • final_price — DECIMAL(10, 2)
  • created_at — TIMESTAMP

auction_stream (auction_streams)

  • stream_id — BIGINT
  • auction_id — BIGINT
  • stream_url — VARCHAR(255)
  • created_at — TIMESTAMP

bids

  • bid_id — INT
  • auction_id — INT
  • user_id — INT
  • bid_amount — DECIMAL(10, 2)
  • bid_time — TIMESTAMP

chat_messages

  • message_id — INT
  • stream_id — INT
  • user_id — INT
  • message — TEXT
  • timestamp — TIMESTAMP

payments

  • payment_id — INT
  • auction_result_id — INT
  • payer_id — INT
  • amount — DECIMAL(10, 2)
  • status — ENUM('pending', 'completed', 'cancelled')
  • payment_time — TIMESTAMP

product

  • product_id — INT
  • name — INT
  • description — TEXT
  • category — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

product_categories

  • category_id — INT
  • category_name — VARCHAR(255) — NOT NULL

user_notifications

  • notification_id — INT
  • user_id — INT
  • message — TEXT
  • read_status — BOOLEAN
  • created_at — TIMESTAMP

user_verifications

  • verification_id — INT
  • user_id — INT
  • verification_code — VARCHAR(255) — NOT NULL
  • verified — BOOLEAN
  • created_at — TIMESTAMP

users

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • contact — VARCHAR(15)
  • status — ENUM('active', 'inactive', 'suspended')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_admin — BOOLEAN