Table petascopedb.public.ps_services 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
serviceid serial 10  √  nextval('ps_services_serviceid_seq'::regclass)
ps_servicelayer.serviceid ps_servicelayer_serviceid_fkey R
contactperson varchar 200  √  'undefined'::character varying
contactorganization varchar 200  √  'undefined'::character varying
addresstype varchar 200  √  'undefined'::character varying
address varchar 200  √  'undefined'::character varying
city varchar 200  √  'undefined'::character varying
stateorprovince varchar 200  √  'undefined'::character varying
postcode varchar 200  √  'undefined'::character varying
country varchar 200  √  'undefined'::character varying
contactvoicetelephone varchar 200  √  'undefined'::character varying
contactfacsimiletelephone varchar 200  √  'undefined'::character varying
contactelectronicmailaddress varchar 200  √  'undefined'::character varying
updatesequence int4 10  √  0
availability int4 10
name varchar 200
title varchar 200
abstract varchar 100  √  'undefined'::character varying
keywords varchar 100  √  'undefined'::character varying
fees varchar 100  √  'undefined'::character varying
accessconstraints varchar 300  √  'undefined'::character varying
hostname varchar 200
port int4 10
path varchar 200
formats varchar 200
baselayername varchar 200
vendorcapabilities varchar 200  √  'undefined'::character varying

Table contained 0 rows at Mon Nov 19 22:04 CET 2012

Indexes:
Column(s) Type Sort Constraint Name
serviceid Primary key Asc ps_services_pkey
hostname + port + path Must be unique Asc/Asc/Asc ps_services_hostname_key
name Must be unique Asc ps_services_name_key

Close relationships  within of separation: