Gift Cards - for lodging for PRs and other programs either transaction_id or reg_id will be non-zero
Table: gift_cards
- id
- Primary key
- person_id
- foreign key to Person who gifted the card
- code
- the 5 character code of the card
- amount
- the initial dollar value of the card OR the amount used
- rec_fname
- first name of the recipient
- rec_lname
- last name of the recipient
- rec_email
- email of the recipient
- reg_id
- foreign key to Registration (optional)
- the_date
- date purchase was made
- the_time
- time purchase was made
- transaction_id
- transaction id for online payments (optional)
Relations