S/W Engineering

Tables (4)

External Campaign (3)

  • external_campaign_id (Auto generated id) — INT(10) — Primary key
  • campaign_img_source (Image about the external campaign) — VARCHAR(255)
  • external_url (The webpage URL of an external campaign) — VARCHAR(255)

Internal Campaign (2)

  • internal_campaign_id (Auto generated id) — INT(10) — Primary key — NOT NULL
  • campaign_name (The name of internal campaign) — VARCHAR(255)
  • donation_item (The item to be donated) — VARCHAR(255)
  • target_amount (The target amount of donation) — VARCHAR(255)
  • place (The target place to donate) — VARCHAR(255)
  • details (The detailed description of donation) — VARCHAR(255)
  • deadline (The deadline for donation) — datetime
  • replay_url (The URL of replay video) — VARCHAR(255) — NOT NULL
  • receipt_img_source (Receipt image about past internal campagin) — VARCHAR(255) — NOT NULL
  • expiration (Whether the deadline expired or not) — boolean

Payment (4)

  • payment_id (Auto generated id of payment) — INT(10) — Primary key — NOT NULL
  • internal_campaign_id (Auto generated id of internal campaign) — INT(10) — Foreign key → Internal Campaign.internal_campaign_id — NOT NULL
  • user_id (Id for Login) — VARCHAR(255) — Foreign key → User Account.user_id — NOT NULL
  • donation_amount (The amount of payment for donation) — VARCHAR(255)

User Account (1)

  • user_id (Id for Login) — VARCHAR(255) — Primary key — NOT NULL
  • password (Password for Login) — VARCHAR(255)
  • address (The address of user) — VARCHAR(255)
  • name (The name of user) — VARCHAR(255)
  • phone_num (The phone number of user) — VARCHAR(255)
  • resident_registration_num (The resident registration number of user) — VARCHAR(255)
  • cardInfo (The information about credit card of user) — VARCHAR(255)