Table petascopedb.public.ps_styles 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
styleid serial 10  √  nextval('ps_styles_styleid_seq'::regclass)
layerid int4 10
ps_layers.layerid ps_styles_layerid_fkey R
name varchar 200
title varchar 200
abstract varchar 4096  √  null
legendwidth int4 10  √  null
legendheight int4 10  √  null
legendurl varchar 300  √  null
sheeturl varchar 300  √  null
rasqlop text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
styleid + layerid Primary key Asc/Asc ps_styles_pkey
layerid + name Must be unique Asc/Asc ps_styles_layerid_key

Close relationships  within of separation: