Table cxgn.public.analysis

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
analysis_id serial 10  √  nextval('analysis_analysis_id_seq'::regclass)
analysisfeature.analysis_id analysisfeature_analysis_id_fkey
analysisprop.analysis_id analysisprop_analysis_id_fkey
name varchar 255  √  null
description text 2147483647  √  null
program varchar 255
programversion varchar 255
algorithm varchar 255  √  null
sourcename varchar 255  √  null
sourceversion varchar 255  √  null
sourceuri text 2147483647  √  null
timeexecuted timestamp 29,6 ('now'::text)::timestamp(6) with time zone

Table contained 10 rows at Mon Oct 06 01:31 EDT 2008

Indexes:
Column(s) Type Sort Constraint Name
analysis_id Primary key Asc analysis_pkey
program + programversion + sourcename Must be unique Asc/Asc/Asc analysis_c1

Close relationships  within one two degrees of separation :