asd
Tables (10)
cart
- id — BIGINT
- user_id — BIGINT
- cart_status — ENUM('unordered', 'ordered')
cart_detail
- id — BIGINT
- cart_id — BIGINT
- item_id — BIGINT
- amount — INT
item
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- item_details — TEXT — NOT NULL
- item_type — INT
item_image
- id — INT
- image_path — TEXT — NOT NULL
- image_type — INT
- item_id — BIGINT
item_type
- id — INT
- type_name — VARCHAR(255) — NOT NULL
order_detail
- id — BIGINT
- item_id — BIGINT
- amount — INT — NOT NULL
- order_id — BIGINT
user
- id — BIGINT
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — VARCHAR(255) — NOT NULL
user_addr
- id — BIGINT
- addr — VARCHAR(500) — NOT NULL
- user_id — BIGINT
user_order
- id — BIGINT
- user_id — BIGINT
- order_status — ENUM('prepared', 'cancelled', 'in_delivery', 'delivered', 'return_requested', 'in_return', 'return_completed')
- order_addr_id — BIGINT
wishlist
- id — INT
- user_id — BIGINT
- item_id — BIGINT