Block To Help for Developers

Blocks reserve housing space. They can be linked to a program/rental/event but not a particular person. Blocks can reserve one bed in a double room just like a registration can.

Table: block

allocated
has the space for this block been allocated? (i.e. config records created)
comment
a long reason
edate
end date
event_id
foreign key to event
house_id
foreign key to house
id
unique id
nbeds
how many beds from this room do you wish to block?
npeople
how many people will occupy this space - for the meal count
program_id
foreign key to program
reason
a brief note describing the reason for the block
rental_id
foreign key to rental
sdate
start date
the_date
when was this block created?
time
what time was this block created?
user_id
foreign key to user

Relations

eventeventbelongs_to
househousebelongs_to
programprogrambelongs_to
rentalrentalbelongs_to
useruserbelongs_to