Each room and tent site has a House record. The name is a misnomer because there are usually more than one room in a house.
Table: house
- bath
- does the room have a bathroom?
- cabin
- is it a test cabin structure?
- cat_abode
- are cats allowed?
- center
- center tent?
- cluster_id
- foreign key to cluster
- cluster_order
- where should this house be displayed in the ClusterView?
- comment
- a longer description of the space
- cottage
- is this one of the RAM Cottage rooms? This is either 0, 1, 2, or 3: 0 - not a RAM cottage, 1 - Ram 1 rooms, 2 - Ram 2 rooms, 3 - all of Ram 1
- disp_code
- A above, B below, L left, or R right with an optional t to truncate the name, OR X which means this house will not be displayed on the DailyPic.
- id
- unique id
- inactive
- no longer habitable?
- key_card
- does the door require an electronic key card?
- max
- how many beds?
- name
- short name of the space
- priority
- a number from 1 to 10 indicating how desirable the space is (1 is the most desirable).
- resident
- is this Resident housing?
- sq_foot
- room square footage - for resident housing
- tent
- is it a tent?
- x
- X coordinate for the DailyPic image
- y
- Y coordinate for the DailyPic image
Relations