Schema Version: 1.3 Module: chado

Columns

Columns

Table Type Column Type Size Nulls Default Comments
featuremap_dbxref Table is_current bool 1 true
featurerange Table feature_id int8 19 null
featuremap_pub Table featuremap_id int8 19 null
featuremap Table description text 2147483647 √ null
featuremap_pub Table featuremap_pub_id bigserial 19 nextval('map.featuremap_pub_featuremap_pub_id_seq'::regclass)
featurepos Table featuremap_id int8 19 null
featuremapprop Table featuremapprop_id bigserial 19 nextval('map.featuremapprop_featuremapprop_id_seq'::regclass)
featuremapprop Table rank int4 10 0
featuremap_organism Table featuremap_organism_id bigserial 19 nextval('map.featuremap_organism_featuremap_organism_id_seq'::regclass)
featuremap Table name varchar 255 √ null
featurerange Table rightendf_id int8 19 null
featurerange Table rangestr varchar 255 √ null
featurepos Table feature_id int8 19 null
featuremap_organism Table organism_id int8 19 null
featuremap_contact Table featuremap_contact_id bigserial 19 nextval('map.featuremap_contact_featuremap_contact_id_seq'::regclass)
featurerange Table featurerange_id bigserial 19 nextval('map.featurerange_featurerange_id_seq'::regclass)
featurerange Table leftstartf_id int8 19 null
featureposprop Table featureposprop_id bigserial 19 nextval('map.featureposprop_featureposprop_id_seq'::regclass)
featuremap_dbxref Table dbxref_id int8 19 null
featurepos Table mappos float8 17 null
featuremap Table unittype_id int8 19 √ null
featuremapprop Table featuremap_id int8 19 null
featureposprop Table featurepos_id int8 19 null
featurepos Table featurepos_id bigserial 19 nextval('map.featurepos_featurepos_id_seq'::regclass)
featuremap Table featuremap_id bigserial 19 nextval('map.featuremap_featuremap_id_seq'::regclass)
featuremap_contact Table contact_id int8 19 null
featuremap_contact Table featuremap_id int8 19 null
featuremap_dbxref Table featuremap_id int8 19 null
featuremap_dbxref Table featuremap_dbxref_id bigserial 19 nextval('map.featuremap_dbxref_featuremap_dbxref_id_seq'::regclass)
featurerange Table featuremap_id int8 19 null

featuremap_id is the id of the feature being mapped.
featureposprop Table type_id int8 19 null
featuremap_organism Table featuremap_id int8 19 null
featuremap_pub Table pub_id int8 19 null
featureposprop Table rank int4 10 0
featureposprop Table value text 2147483647 √ null
featurerange Table leftendf_id int8 19 √ null
featurerange Table rightstartf_id int8 19 √ null
featuremapprop Table value text 2147483647 √ null
featuremapprop Table type_id int8 19 null
featurepos Table map_feature_id int8 19 null

map_feature_id links to the feature (map) upon which the feature is being localized.