Table cxgn.sgn_bt.deprecated_marker_confidences

Generated by
SchemaSpy

Legend:

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

confidence_id

serial

√

nextval('deprecated_marker_confidences_confidence_id_seq'::regclass)

map_version.default_threshold	map_version_default_threshold_fkey
marker_confidence.confidence_id	Implied Constraint

confidence_name

varchar

√

null

legacy_conf_id

int8

√

null

confidence_fk

cxgn_production_visible

bool

√

false

Table contained 5 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
confidence_id	Primary key	Asc	marker_confidences_pkey
confidence_name + legacy_conf_id	Performance	Asc/Asc	confidence_name_idx
legacy_conf_id	Must be unique	Asc	legacy_conf_id_unique	This unique column is also nullable