test
Tables (11)
Admin
- admin_id — BIGINT
- employee_id — BIGINT — NOT NULL
- password — VARCHAR(255) — NOT NULL
Auction_Products
- product_id — BIGINT
- auction_start_time — DATETIME — NOT NULL
- auction_end_time — DATETIME — NOT NULL
- starting_bid — DECIMAL(10, 2) — NOT NULL
- final_bid — DECIMAL(10, 2)
Category
- category_id — INT
- category_name — VARCHAR(255) — NOT NULL
General_Products
- product_id — BIGINT
- quantity — INT — NOT NULL
- saved_count — INT
Order
- order_id — BIGINT
- status — BOOLEAN — NOT NULL
- user_id — BIGINT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- purchase_type — BOOLEAN
- product_id — BIGINT — NOT NULL
Product
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- brand — VARCHAR(255)
- price — DECIMAL(10, 2) — NOT NULL
- category_id — INT — NOT NULL
- auction_type — BOOLEAN
Sale
- sale_id — BIGINT
- user_id — BIGINT — NOT NULL
- sale_status — ENUM('Pending', 'Completed', 'Cancelled') — NOT NULL
Sale_Products
- sp_id — BIGINT
- sale_id — BIGINT — NOT NULL
- sale_price — DECIMAL(10, 2) — NOT NULL
- first_status — INT
- product_name — VARCHAR(255)
- auction_type — BOOLEAN
- brand — VARCHAR(255)
- category — VARCHAR(255)
User_Coupons
- coupon_id — BIGINT
- discount_rate — DECIMAL(5, 2) — NOT NULL
- coupon_registration_date — DATE — NOT NULL
- coupon_expiration_date — DATE — NOT NULL
- user_id — BIGINT — NOT NULL
User_Saved
- saved_id — BIGINT
- product_id — BIGINT — NOT NULL
- style_feed_id — INT
- user_id — BIGINT — NOT NULL
Users
- user_id — BIGINT
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- seller_grade — VARCHAR(50)