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 |
|
|
|||||
type_id | int8 | 19 | √ | null |
|
|
|||||
nd_protocol_id | int8 | 19 | √ | null |
|
|
|||||
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 |