Table cxgn.sgn_bt.deprecated_markers

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

marker_id

serial

√

nextval('deprecated_markers_marker_id_seq'::regclass)

deprecated_marker_locations.marker_id	marker_id_fk
marker_derived_from.marker_id	marker_derived_from_marker_id_fkey
temp_marker_correspondence.old_marker_id	temp_marker_correspondence_old_marker_id_fkey

marker.marker_id

Implied Constraint

marker_type

int8

(0)::bigint

marker_type_fk

marker_name

varchar

''::character varying

cxgn_production_visible

bool

√

false

Table contained 7,516 rows at Thu Jun 21 23:03 EDT 2007

Indexes:

Column(s)	Type	Sort	Constraint Name
marker_id	Primary key	Asc	markers_pkey
marker_type + marker_name	Performance	Asc/Asc	marker_type_idx