Shop
Tables (8)
Category
- category_id — BIGINT
- name — VARCHAR(255)
Delivery
- delivery_id — BIGINT
- address — VARCHAR(255)
- status — VARCHAR(255)
HairItem
- item_id — BIGINT
- category_id — BIGINT
- subCategory_id — BIGINT
Item
- item_id — BIGINT
- dtype — VARCHAR(31)
- name — VARCHAR(255)
- price — INT
- stockQuantity — INT
- brandName — VARCHAR(255)
Member
- member_id — BIGINT
- userId — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- age — BIGINT
- phone — VARCHAR(255)
- isAdmin — BOOLEAN
- status — VARCHAR(255)
Order
- order_id — BIGINT
- member_id — BIGINT
- delivery_id — BIGINT
- orderDate — TIMESTAMP
- status — VARCHAR(255)
OrderItem
- Key — Primary key — NOT NULL
- order_item_id — BIGINT
- order_id — BIGINT
- item_id — BIGINT
- count — INT
- orderPrice — INT
SubCategory
- sub_category_id — BIGINT
- name — VARCHAR(255)
- category_id — BIGINT