This table records actions that affect a member's free nights and free program.
Table: night_hist
- action
- a number from 1 to 5 indicating the action
- Set Nights
- Take Nights
- Clear Free Program
- Take Free Program
- Set Free Program
- id
- unique id
- member_id
- foreign key to member
- num_nights
- how many nights?
- reg_id
- foreign key to registration - i.e. for which program the nights were taken.
- the_date
- date this record was created
- time
- time this record was created
- user_id
- foreign key to user
Relations