I am trying to create a system to check-in customers into our facility based on the number of admissions they have purchased.
For example, I have a customer who purchases 10 admissions, and each time they enter the facility and check in at the desk an admission would be deducted from their "account". What would be the best way to set this up? Would I make this something in the Registration table, or would I create a new table that houses all check-ins? I'd like to look up the individual's account and see the history of their admission as well in a portal.
Any thoughts on table structure/fields would be great!