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