Legend_______________________________________________________________________

+entity_table
+<relation_table>
*primary_key
data_field
(foreign_key)
[private data field]

Database Schema______________________________________________________________

+college
	*college_id
	college_name
	
+department
	*department_id
	department_name
	(college_id)
	
+building
	*building_id
	building_name
	building_code

+building_map
	*building_map_id
	building_map_name
	image_path
	floor
	(building_id)

+<occupies>
	*occupation_id
	(department_id)
	(building_id)

+room
	*room_id
	room_number
	room_name
	room_desc
	capacity
	square_area
	active
	comments
	(type_id)
	(building_id)
	[last_survey]

+type
	*type_id
	type_name
	type_code
	
+room_comment
	*room_comment_id
	room_comment_text
	(room_id)
	
+<room_geometry>
	*room_geometry_id
	geometry
	(room_id)
	(building_map_id)

+<room_image>
	*room_image_id
	(room_id)
	(image_id)

+image
	*image_id
	image_path
	image_caption

+<room_ref_org>
	*room_ref_org_id
	use_percentage
	(room_id)
	(ref_org_id)

+ref_org
	*ref_ord_id
	ref_org
	ref_org_name
	(department_id)

+<room_function>
	*room_function_id
	use_percentage
	(room_id)
	(function_id)

+function
	*function_id
	function_name
	function_code
	
+occupant
	*occupant_id
	occupant_name
	occupant_url

+<room_occupant>
	*room_occupant_id
	since
	(room_id)
	(occupant_id)

+room_info
	*room_info_id
	event
	event_message
	(room_id)

+<room_item>
	*room_item_id
	(room_id)
	(item_id)

+item
	*item_id
	item_name
	(item_type_id)

+item_type
	*item_type_id
	item_type_name
	(department_id)

+item_attribute
	*item_attribute_id
	item_attr_name
	item_attr_value
	(item_id)
	(item_attr_type_id)
	
+item_attr_type
	*item_attr_type_id
	item_attr_type_name
	(item_type_id)

+item_comment
	*item_comment_id
	item_comment_text
	(item_id)