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