new

Tables (5)

brand_table (Untitled3)

  • brandId (Field) — smallint
  • brandName (Field2) — varchar

list (Untitled5)

  • c_Id (Key3) — varchar — Foreign key → user_table.c_Id — NOT NULL
  • p_Brand (Key) — smaillint — Foreign key → product_table.p_Brand — NOT NULL
  • c_Id (Field) — varchar
  • p_Id (Field2) — varchar
  • p_Price (Field3) — int
  • w_Quantity (Field4) — smallInt

order_history (Untitled4)

  • c_Id (Key3) — varchar — Foreign key → user_table.c_Id — NOT NULL
  • c_Id (Field) — varchar
  • o_Date (Field2) — date
  • p_Price (Field3) — int

product_table (Untitled)

  • p_Brand (Key) — smaillint — Primary key — NOT NULL
  • p_name (Field) — varchar
  • p_Id (Field2) — varchar
  • p_Category (Field3) — varchar
  • p_Color (Field4) — varchar
  • p_Size (Field5) — varchar
  • p_Stack (Field6) — int
  • p_Price (Field7) — int

user_table (Untitled2)

  • c_Id (Key3) — varchar — Primary key — NOT NULL
  • c_Password (Field2) — varchar
  • c_Name (Field3) — varchar
  • c_Birthday (Field4) — date
  • c_Address1 (Field5) — varchar
  • c_Address2 (Field6) — varchar
  • c_Phone1 (Field7) — varchar
  • c_Phone2 (Field8) — varchar