sinSaDevShop
Tables (6)
Order
- Oder_Sep — INT — Primary key — NOT NULL
- Prod_Sep — INT — Foreign key → Product.Prod_Sep — NOT NULL
- User_Sep — INT — Foreign key → User.User_Sep — NOT NULL
- Order_Name — VARCHAR(100)
- Order_addr — VARCHAR(100)
- Oder_Payment — INT
- Oder_Price — INT
- Oder_date — TIMESTAMP
Prod_Des
- Prod_Des_Sep — INT — Primary key — NOT NULL
- Prod_Color
- Prod_Count — INT
- Prod_Size — INT
Product
- Prod_Sep — INT — Primary key — NOT NULL
- Prod_Video_Sep — INT — Foreign key → Product_video.Prod_Video_Sep — NOT NULL
- Prod_Des_Sep — INT — Foreign key → Prod_Des.Prod_Des_Sep — NOT NULL
- Prod_Name — VARCHAR(50)
- Prod_Cat — VARCHAR(20)
- Prod_Price — INT
- Prod_IMG — VARCHAR(100)
- Prod_Date — DATE
Product_video
- Prod_Video_Sep — INT — Primary key — NOT NULL
- Prod_Video_Name — VARCHAR(30)
- Prod_Video_Domain — VARCHAR(100)
User
- User_Sep — INT — Primary key — NOT NULL
- Login_ID — VARCHAR(30)
- Password — VARCHAR(20)
- Name — VARCHAR(10)
- Extra — VARCHAR(20)
- Dated — DATE
User_Description
- User_Des_Sep — INT — Primary key — NOT NULL
- User_sep — INT — Foreign key → User.User_Sep — NOT NULL
- Birthday — DATE
- Phone — INT(11)
- Marketing — VARCHAR
- Role — INT(2)
- Addr — VARCHAR(50)
- Email — VARCHAR(20)
- Extra — VARCHAR(20)