featureprop_json

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
featureprop_json_id serial 10 √ nextval('featureprop_json_featureprop_json_id_seq'::regclass)
feature_id int8 19 √ null
feature.feature_id featureprop_json_feature_id_fkey R
type_id int8 19 √ null
cvterm.cvterm_id featureprop_json_type_id_fkey R
nd_protocol_id int8 19 √ null
nd_protocol.nd_protocol_id featureprop_json_nd_protocol_id_fkey R
start_pos int8 19 √ null
end_pos int8 19 √ null
json jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
featureprop_json_pkey Primary key Asc featureprop_json_id
feaureprop_json_idx1 Performance Asc feature_id
feaureprop_json_idx2 Performance Asc type_id
feaureprop_json_idx3 Performance Asc nd_protocol_id
feaureprop_json_idx4 Performance Asc start_pos
feaureprop_json_idx5 Performance Asc end_pos

Relationships

Close relationships within degrees of separation