Auction_ShoppingMall
Tables (9)
advertisements
- advertisement_id — INT
- image_url — VARCHAR(255) — NOT NULL
- redirect_url — VARCHAR(255) — NOT NULL
- active — BOOLEAN — NOT NULL
carts
- cart_id — INT
- user_id — INT — NOT NULL
- product_id — INT — NOT NULL
- quantity — INT
- added_date — TIMESTAMP
categories
- category_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- parent_id — INT
events
- event_id — INT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- start_date — DATE
- end_date — DATE
- active — BOOLEAN — NOT NULL
orders
- order_id — INT
- user_id — INT — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- order_date — TIMESTAMP
- status — ENUM('pending', 'completed', 'cancelled')
payments
- payment_id — INT
- order_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- payment_date — TIMESTAMP
- payment_method — ENUM('credit card', 'paypal', 'bank transfer') — NOT NULL
products
- product_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- category_id — INT
- created_at — TIMESTAMP
shipments
- shipment_id — INT
- order_id — INT — NOT NULL
- shipment_status — ENUM('preparing', 'shipped', 'delivered', 'returned')
- tracking_number — VARCHAR(255)
- estimated_delivery_date — DATE
- actual_delivery_date — DATE
users
- Key — Primary key — NOT NULL
- user_id — INT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- address — TEXT — NOT NULL
- created_at — TIMESTAMP