SHP
Tables (4)
Member
- member_id — BIGINT — Primary key
- LoginId — varcher(20)
- name — VARCHAR(100)
- email — VARCHAR(100)
- password — VARCHAR(100)
- phone — VARCHAR(50)
- address — VARCHAR(200)
Order
- order_id — BIGINT — Primary key
- member_id — BIGINT — Foreign key → Member.member_id
- totalPrice — INT
- pointused — INT
- cashamount — INT
- orderStatus — VARCHAR(50)
- createDate — DATETIME
OrderItem
- order_item_id — BIGINT — Primary key
- quantity — INT
- price — INT
- order_id — BIGINT — Foreign key → Order.order_id
- product_id — BIGINT — Foreign key → Product.product_id
Product
- product_id — BIGINT — Primary key
- productName — VARCHAR(100)
- productStock — INT
- description — VARCHAR(255)