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)