Q8
Tables (8)
Account
- Key (account_id) — int — Primary key — NOT NULL
- Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
Address
- Key (address_id) — int — Primary key — NOT NULL
- Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
- Field (address) — varchar(10)
Customer
- Key (customer_id) — int — Primary key — NOT NULL
- Field (name) — varchar(10) — NOT NULL
- Field2 (email) — varchar(10) — NOT NULL
- Field3 (phone) — varchar(10) — NOT NULL
Order
- Key (order_id) — int — Primary key — NOT NULL
- Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
- Field (order_date) — datetime — NOT NULL
- Field2 (status) — varchar(10) — NOT NULL
OrderItem
- Key (order_id) — int — Foreign key → Order.Key — NOT NULL
- Key (product_id) — int — Foreign key → Product.Key — NOT NULL
- Field (quantity) — int — NOT NULL
Payment
- Key (payment_id) — int — Primary key — NOT NULL
- Key (order_id) — int — Foreign key → Order.Key — NOT NULL
- Field (amount) — int
- Field2 (method) — varchar(10)
- Field3 (status) — varchar(10)
Product
- Key (product_id) — int — Primary key — NOT NULL
- Field (product_code) — varchar(10) — NOT NULL
- Field2 (name) — varchar(10) — NOT NULL
- Field3 (category) — varchar(10) — NOT NULL
- Field4 (price) — int — NOT NULL
- Field5 (stock) — int — NOT NULL
- Field6 (status) — varchar(10) — NOT NULL
Review
- Key (review_id) — int — Primary key — NOT NULL
- Key (customer_id) — int — Foreign key → Customer.Key — NOT NULL
- Key (product_id) — int — Foreign key → Product.Key — NOT NULL
- Field (content) — varchar(10)
- Field2 (rating) — int
- Field3 (date_written) — datetime