Table cxgn.sgn_bt.deprecated_marker_locations

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_location_id

serial

√

nextval('deprecated_marker_locations_marker_location_id_seq'::regclass)

marker_id

int8

(0)::bigint

deprecated_markers.marker_id

marker_id_fk

loc_id

int8

(0)::bigint

deprecated_mapdata.loc_id

loc_id_fk

confidence

int8

(0)::bigint

deprecated_marker_confidences.legacy_conf_id

confidence_fk

order_in_loc

int8

(0)::bigint

location_subscript

bpchar

√

null

mapmaker_id

int8

(0)::bigint

cxgn_production_visible

bool

√

false

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

Indexes:

Column(s)	Type	Sort	Constraint Name
marker_location_id	Primary key	Asc	marker_locations_pkey
marker_id + loc_id	Performance	Asc/Asc	marker_id_idx4