Table odyssey_test._quest.uw_location
A location in which events may be held, as of the most recent update to that location in uw_location_history

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
location_code text 2147483647
off_instruct_section.location_code off_instruct_section_location_code_fkey R
off_instruct_section_meet_plus.location_code Implied Constraint R
uw_campus.location_code uw_campus_location_code_fkey R
uw_campus_history.location_code uw_campus_history_location_code_fkey R
uw_room.location_code Implied Constraint R
uw_location_history.location_code uw_location_location_code_fkey R
location_as_of date 13
uw_location_history.location_as_of uw_location_location_code_fkey R
location_active bool 1
location_quest_description text 2147483647
country_code text 2147483647
uw_country.country_code uw_location_country_code_fkey R

Table contained 131 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
location_code Primary key Asc uw_location_pkey

Close relationships  within of separation: