Table petascopedb.public.ps_layers 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
layerid serial 10  √  nextval('ps_layers_layerid_seq'::regclass)
ps_pyramidlevels.layerid ps_pyramidlevels_layerid_fkey R
ps_servicelayer.layerid ps_servicelayer_layerid_fkey R
ps_styles.layerid ps_styles_layerid_fkey R
name varchar 200  √  null
title varchar 200
srs varchar 200
authority varchar 200  √  null
latlonboxxmin float8 17,17  √  null
latlonboxxmax float8 17,17  √  null
latlonboxymin float8 17,17  √  null
latlonboxymax float8 17,17  √  null
bboxxmin float8 17,17  √  null
bboxxmax float8 17,17  √  null
bboxymin float8 17,17  √  null
bboxymax float8 17,17  √  null
attributionurl varchar 300  √  null
attributiontitle varchar 200  √  null
logowidth int4 10  √  null
logoheight int4 10  √  null
logoformat varchar 200  √  null
logourl varchar 300  √  null
featureurl varchar 300  √  null
resolution float8 17,17  √  null
maptype varchar 200  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
layerid Primary key Asc ps_layers_pkey  
name Must be unique Asc ps_layers_name_key This unique column is also nullable

Close relationships  within of separation: