shopping
Tables (7)
cart_list
- cart_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → customers.customer_id — NOT NULL
- product_id — INT — Foreign key → product.product_id — NOT NULL
- cart_qt — INT
customers
- customer_id — INT — Primary key — NOT NULL
- customer_pw — VARCHAR(45)
- customer_name — VARCHAR(45)
- customer_email — VARCHAR(45)
- customer_address — VARCHAR(45)
- customer_phonenum — VARCHAR(45)
item_order
- order_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → customers.customer_id — NOT NULL
- order_date — DATE
order_detail
- order_id — INT — Foreign key → item_order.order_id — NOT NULL
- product_id — INT — Foreign key → product.product_id — NOT NULL
- order_qt — INT
- order_status — VARCHAR(100)
product
- product_id — INT — Primary key — NOT NULL
- product_name — VARCHAR(45) — NOT NULL
- product_price — INT
- product_dealer — VARCHAR(45)
product_review
- review_id — INT — Primary key — NOT NULL
- product_id — INT — Foreign key → product.product_id — NOT NULL
- order_id — INT — Foreign key → item_order.order_id — NOT NULL
- product_rating — INT
- product_review — VARCHAR(1000)
stock (Untitled)
- product_id — INT — Foreign key → product.product_id — NOT NULL
- stock_qt — INT
- stock_supply — VARCHAR(45)