A Grid record represents a person assigned to a room and bed for the duration of a rental. They may not be present for every night.
Table: grid
- bed_num
- bed number
- cost
- total cost for the duration of the rental
- house_id
- foreign key to house
- name
- the person's name
- notes
- email address, other notes
- occupancy
- a series of 0s and 1s representing presence each night
- rental_id
- foreign key to rental
Relations