GivingMall System
Tables (3)
member
- userId (Key) — Varchar(50) — Primary key — NOT NULL
- userName (Field) — Varchar(50)
- phone (Field2) — INT(10)
- birth_M (Field3) — INT(10)
- birth_D (Field4) — INT(10)
- password (Field5) — Varchar(50)
- profile (Field6) — Varchar(50)
- address_Name (Field7) — Varchar(50)
- address (Field8) — Varchar(50)
product
- p_Id (Key) — Primary key — NOT NULL
- p_Name (Field) — Varchar(50)
- p_Price (Field2) — INT(10)
- p_Tag (Field3) — Varchar(50)
- p_Picture (Field4) — Varchar(50)
- p_Detail (Field5) — Varchar(50)
- option1 (Field6) — Varchar(50)
- option2 (Field7) — Varchar(50)
- option3 (Field8) — Varchar(50)
- option4 (Field9) — Varchar(50)
purchase
- p_No (Key) — INT(10) — Primary key — NOT NULL
- total_Price (Field3) — INT(10)
- amount (Field4) — INT(10)
- p_Option (Field5) — Varchar(50)
- gifter_Name (Field10) — Varchar(50)