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)