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