Table webco_4.3.3.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
agreement_form_config.location_oid agreement_form_config_location_oid
allocation.location_oid fkcalloc_location_oid
allocation_reminder_interval.location_oid fkcallocation_reminder_interval_location
authset_location.location_oid fkauthset_location_location_oid
calendar_allocation_fields.location_oid calendar_allocation_fields_location_oid_fkey
freelancer_person_location.location_oid fkcfreelancer_person_location_location_oid
invoice.cc_oid fkcinvoice_cc_oid
location_auto_email.location_oid fkextlocation_oid
location_pir_pickup_option.location_oid location_pir_pickup_option_location_oid_fkey
location_schedule.location_oid fkclocation_schedule_location
person_location_signature.location_oid person_location_signature_location_oid_fkey
pir_person_location.location_oid fkcpir_location_location_oid
resource.location_oid resource_location_oid_fkey
turndown.location_oid turndown_location_oid_fkey
wco_application.default_location_oid fkapp_default_loc_oid
wco_log.loc_oid fkcwco_log_loc_oid
wco_station.location_oid fkcwco_station_location_oid
name varchar 2147483647
description varchar 2147483647  √  null
org_oid int8 19
organization.obj_oid location_org_oid_fkey
pickup_default wcof_tag 2147483647
return_default wcof_tag 2147483647
default_delivery_type wcof_tag 2147483647
default_resource_selector wcof_tag 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  √  'wco_local'::character varying
allocation_mode wcof_tag 2147483647  √  null
pir_mode wcof_tag 2147483647  √  null
repeats_in_pir bool 1  √  null
pir_requires_approval bool 1  √  null
pir_restrict_delivery_locations bool 1  √  null
pir_session_timeout int4 10 15
pir_report_problems bool 1  √  true
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
day_rollover int4 10
crestron_host varchar 2147483647  √  null
crestron_port int8 19  √  null
usage_exclude_closed bool 1  √  null
pir_media_cc_query bool 1  √  null
pir_motd varchar 2147483647  √  null
require_signature_on_file bool 1  √  false
default_allocation_times wcof_default_allocation_times 2147483647  √  null
timezone varchar 2147483647  √  null
locale varchar 2147483647  √  null
form_date_time_format wcof_tag 2147483647
agreement_form_sorting wcof_tag 2147483647
agreement_form_grouping wcof_tag 2147483647
custom_agreement_form_oid int8 19  √  null
agreement_form_config.obj_oid location_custom_agreement_form_oid_fkey

Table contained 1 rows at Fri Sep 23 14:49 CDT 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc location_pkey
name Must be unique Asc location_name_key

Close relationships  within of separation: