Table webco_3.6.1.public.location 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
obj_oid int8 19
allocation.location_oid fkcalloc_location_oid
dat_location.location_oid fkcdat_location_oid
freelancer_person_location.location_oid fkcfreelancer_person_location_location_oid
invoice.cc_oid fkcinvoice_cc_oid
location_schedule.location_oid fkclocation_schedule_location
pir_allocation.location_oid fkcpir_allocation_location_oid
pir_person_location.location_oid fkcpir_location_location_oid
resource.location_oid resource_location_oid_fkey
wco_log.loc_oid fkcwco_log_loc_oid
wco_station.location_oid fkcwco_station_location_oid
name varchar 2147483647  √  null
description varchar 2147483647  √  null
org_oid int8 19
organization.obj_oid location_org_oid_fkey
rtype_oid int8 19  √  null
resource_type.obj_oid fkloc_rtype
pickup_default varchar 2147483647  √  null
return_default varchar 2147483647  √  null
default_delivery_type varchar 2147483647  √  null
default_resource_selector varchar 2147483647  √  null
timeline_zoom_factor int8 19  √  null
timeline_granularity int8 19  √  null
building varchar 2147483647  √  null
room varchar 2147483647  √  null
address varchar 2147483647  √  null
telephone varchar 2147483647  √  null
print_queue varchar 2147483647  √  null
allocation_mode varchar 2147483647  √  null
pir_mode varchar 2147483647  √  'BOTH'::character varying
repeats_in_pir bool 1  √  null
billing_contact_name varchar 2147483647  √  null
billing_contact_phone varchar 2147483647  √  null
billing_contact_email varchar 2147483647  √  null
email_template_set varchar 2147483647  √  null
print_template_set varchar 2147483647  √  null
holiday_list varchar 2147483647  √  null
hours_list varchar 2147483647  √  null
rules_list varchar 2147483647  √  null
day_rollover int4 10  √  null
crestron_host varchar 2147483647  √  null
crestron_port int8 19  √  null
usage_exclude_closed bool 1  √  null

Table contained 1 rows at Wed May 11 15:14 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc location_pkey

Close relationships  within of separation: