ERD
Tables (9)
categories
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — text
- icon_image — varchar(255)
- created_at — timestamp
- updated_at — timestamp
contacts
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- message — longtext — NOT NULL
- status — enum('new','read','replied') — NOT NULL
- created_at — timestamp
favorites
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — NOT NULL
- product_id — bigint(20) — NOT NULL
- created_at — timestamp
order_details
- id — bigint(20) — Primary key — NOT NULL
- order_id — bigint(20) — NOT NULL
- product_id — bigint(20) — NOT NULL
- quantity — int(11) — NOT NULL
- price — decimal(10,2) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
orders
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — NOT NULL
- total_price — decimal(10,2) — NOT NULL
- status — varchar(255) — NOT NULL
- payment_method — varchar(255) — NOT NULL
- shipping_address — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- note — text
- created_at — timestamp
- updated_at — timestamp
products
- id — bigint(20) — Primary key — NOT NULL
- category_id — bigint(20) — NOT NULL
- name — varchar(255) — NOT NULL
- description — text
- price — decimal(10,2) — NOT NULL
- discounted_price — decimal(10,2)
- quantity — int(11) — NOT NULL
- has_promotion — tinyint(1) — NOT NULL
- discount_percentage — int(11)
- unit — varchar(255) — NOT NULL
- origin — varchar(255)
- image — varchar(255)
- created_at — timestamp
- updated_at — timestamp
promotions
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- type — enum('category','product') — NOT NULL
- discount_type — enum('percentage','fixed') — NOT NULL
- discount_value — decimal(10,2) — NOT NULL
- start_date — datetime — NOT NULL
- end_date — datetime — NOT NULL
- category_id — bigint(20)
- product_id — bigint(20)
- is_active — tinyint(1) — NOT NULL
- created_at — timestamp
reviews
- id — bigint(20) — Primary key — NOT NULL
- product_id — bigint(20) — NOT NULL
- user_id — bigint(20) — NOT NULL
- rating — int(11) — NOT NULL
- comment — text — ext DEFAULT NUL
- created_at — timestamp
users
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- is_admin — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp