erd
Tables (6)
address
- id — bigint — Primary key — NOT NULL
- city — varchar(255) — NOT NULL
- province — varchar(255) — NOT NULL
- village — varchar(255) — NOT NULL
- user_id — bigint — NOT NULL
order_detail
- id — bigint — Primary key — NOT NULL
- price — bigint
- product_name — varchar(255)
- quantity — bigint
- order_id — bigint — NOT NULL
orders
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- state — varchar(255)
- user_id — bigint — NOT NULL
product
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- description — varchar(255)
- name — varchar(255)
- price — bigint
- stock — bigint
- user_id — bigint — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- modified_at — datetime(6)
- photo — varchar(255)
- score — bigint
- title — varchar(255)
- product_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL