ex
Tables (7)
CATEGORY
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
COMMENT
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT
- created_at — DATETIME
ORDER
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- order_number — VARCHAR(100)
- order_date — DATETIME
- status — VARCHAR(50)
- total_amount — DECIMAL(10,2)
ORDER_ITEM
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT
- price_at_purchase — DECIMAL(10,2)
PRODUCT
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → CATEGORY.id — NOT NULL
- name — VARCHAR(255)
- price — DECIMAL(10,2)
- description — TEXT
- stock_quantity — INT
- rating_avg — FLOAT
REVIEW
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- rating — INT
- content — TEXT
- created_at — DATETIME
USER
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100)
- email — VARCHAR(255)
- password — VARCHAR(255)
- profile_image — VARCHAR(500)