Table webco_3.9.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
calendar_allocation_fields.location_oid calendar_allocation_fields_location_oid_fkey
dat_location.location_oid fkcdat_location_oid
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_allocation.location_oid fkcpir_allocation_location_oid
pir_person_location.location_oid fkcpir_location_location_oid
pir_request_log.location_oid fkcpir_request_log_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
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 'WILL-CALL'::character varying
return_default varchar 2147483647 'WILL-RETURN'::character varying
default_delivery_type varchar 2147483647 'NORMAL'::character varying
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  √  'wco_local'::character varying
allocation_mode varchar 2147483647  √  null
scheduler_type varchar 2147483647  √  null
pir_mode varchar 2147483647  √  'BOTH'::character varying
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
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  √  null
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
form_date_time_format varchar 2147483647 'DAYTIME'::character varying
agreement_form_sorting varchar 2147483647 'RESOURCE-TYPE'::character varying
agreement_form_grouping varchar 2147483647 'NONE'::character varying
custom_agreement_form_oid int8 19  √  null

Table contained 1 rows at Wed May 07 11:05 EDT 2014

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: