Table petascopedb.public.ps_service_provider 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
id serial 10  √  nextval('ps_service_provider_id_seq'::regclass)
name text 2147483647
site text 2147483647  √  null
contact_individual_name text 2147483647  √  null
contact_position_name text 2147483647  √  null
contact_phone_id int4 10  √  null
ps_telephone.id ps_service_provider_contact_phone_id_fkey R
contact_delivery_points _text 2147483647  √  null
contact_city text 2147483647  √  null
contact_administrative_area text 2147483647  √  null
contact_postal_code text 2147483647  √  null
contact_country text 2147483647  √  null
contact_email_addresses _text 2147483647  √  null
contact_hours_of_service text 2147483647  √  null
contact_instructions text 2147483647  √  null
contact_role_id int4 10  √  null
ps_role_code.id ps_service_provider_contact_role_id_fkey R

Table contained 1 rows at Mon Jul 07 14:34 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc ps_service_provider_pkey

Close relationships: