mew
Tables (5)
cart (Cart)
- id (cart_id) — BIGINT — Primary key — NOT NULL
- count — INT
- createdDate (created_date) — DATETIME
- modifiedDate (modified_date) — DATETIME
- id (item_id) — BIGINT — Foreign key → item.id — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL
- id (orderitem_id) — BIGINT — Foreign key → orderitem.id — NOT NULL
item (Item)
- id (item_id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- category — VARCHAR
- price — VARCHAR
- img — INT
- createdDate (created_date) — DATETIME
- modifiedDate (modified_date) — DATETIME
orderitem (OrderItem)
- id (orderitem_id) — BIGINT — Primary key — NOT NULL
- address — VARCHAR
- message — VARCHAR
- amount — INT
- orderName (order_name) — VARCHAR
- orderNumber (order_number) — VARCHAR
- createdDate (created_date) — DATETIME
- modifiedDate (modified_date) — DATETIME
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL
review (Review)
- id (review_id) — BIGINT — Primary key — NOT NULL
- content — LONGTEXTT
- rate — INT
- createdDate (created_date) — DATETIME
- modifiedDate (modified_date) — DATETIME
- id (item_id) — BIGINT — Foreign key → item.id — NOT NULL
- id (user_id) — BIGINT — Foreign key → user.id — NOT NULL
user (User)
- id (user_id) — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- email — VARCHAR
- password — VARCHAR
- address — VARCHAR
- createdDate (created_date) — DATETIME
- modifiedDate (modified_date) — DATETIME