Home

Tables

Schemas

Diagrams

Foreign Keys

Indexes

classification

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	classification_id	Integer			nextval('classification_classification_id_seq'::regclass)
	parent_classification_id	Integer
	name	VarChar(255)
	description	VarChar(2000)
	legacy_id	Integer
	legacy_parent_id	Integer

Indexes
Name	Table	Columns	Unique	Clustered
classification_name_idx	classification	name
classification_parent_clssfctn_idx	classification	parent_classification_id

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
classification_parent_classification_id_fkey	classification	classification	classification_id	parent_classification_id

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
classification_parent_classification_id_fkey	classification	classification	classification_id	parent_classification_id
sample_classification_id_fkey	classification	sample	classification_id	classification_id
sample_top_level_classification_id_fkey	classification	sample	classification_id	top_level_classification_id

Triggers (none)

Used in Diagrams

Diagram Name

diagramA