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)