OliveYoung
Tables (9)
Cart
- cart_id — INT — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL
- created_at — DATETIME
CartItem
- cartitem_id — INT — Primary key — NOT NULL
- cart_id — INT — Foreign key → Cart.cart_id — NOT NULL
- user_id — Foreign key → Cart.user_id — NOT NULL
- quantity — INT
Category
- category_id — INT
- name — VARCHAR(50) — NOT NULL
Order
- order_id — INT — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL
- order_date — DATETIME
- total_price — DECIMAL(10,2)
- status — ENUM('PENDING', 'PAID', 'SHIPPED', 'CANCELLED')
OrderItem
- order_item_id — INT — Primary key — NOT NULL
- order_id (order_id2) — INT — Foreign key → Order.order_id — NOT NULL
- user_id — Foreign key → Order.user_id — NOT NULL
- product_id — INT
- quantity — INT
- price — DECIMAL(10,2)
Product
- product_id — INT — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2) — NOT NULL
- stock — INT — NOT NULL
- image_url — VARCHAR(255)
- category_id — INT
QnA
- qna_id — INT — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL
- title — VARCHAR(100)
- content — TEXT
- created_at — DATETIME
- is_answered — BOOLEAN
Review
- review_id — INT — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL
- rating — INT
- content — TEXT
- created_at — DATETIME
User
- user_id — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- role — ENUM('USER', 'ADMIN')
- created_at — DATETIME