OliveYoung
Tables (9)
Cart
- cart_id — INT
- user_id — INT
- created_at — DATETIME
CartItem
- cart_item_id — INT
- cart_id — INT
- product_id — INT
- quantity — INT
Category
- category_id — INT
- name — VARCHAR(255)
OrderItem
- order_item_id — INT
- order_id — INT
- product_id — INT
- quantity — INT
- price — DECIMAL(10, 2)
OrderTable
- order_id — INT
- user_id — INT
- order_date — DATETIME
- total_price — DECIMAL(10, 2)
- status — ENUM('pending', 'shipped', 'delivered', 'cancelled')
Product
- product_id — INT
- name — VARCHAR(255)
- description — TEXT
- price — DECIMAL(10, 2)
- stock — INT
- image_url — VARCHAR(255)
- category_id — INT
QnA
- qna_id — INT
- user_id — INT
- product_id — INT
- title — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- is_answered — BOOLEAN
Review
- review_id — INT
- user_id — INT
- product_id — INT
- rating — INT
- content — TEXT
- created_at — DATETIME
User
- user_id — INT
- username — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- phone — VARCHAR(20)
- email — VARCHAR(255)
- role — ENUM('user', 'admin')
- created_at — DATETIME