shop
Tables (5)
cart
- id — bigint — Primary key — NOT NULL
- purchase_date — timestamp(6)
- customer_id — bigint
cart_products
- cart_id — bigint — NOT NULL
- products_id — bigint — NOT NULL
customer
- id — bigint — Primary key — NOT NULL
- address — varchar(255)
- name — varchar(255)
- phone_number — varchar(255)
- points — integer
product
- id — bigint — Primary key — NOT NULL
- category — varchar(255)
- name — varchar(255)
- price — float(53)
- rating — float(53)
- stock — integer
review
- id — bigint — Primary key — NOT NULL
- rating — integer
- review — varchar(255)
- customer_id — bigint
- product_id — bigint