Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| component_id | serial | 10 | √ | nextval('moped_components_component_id_seq'::regclass) |
|
|
||||||||
| component_name | text | 2147483647 | null |
|
|
|||||||||
| component_subtype | text | 2147483647 | √ | null |
|
|
||||||||
| line_representation | bool | 1 | false |
|
|
|||||||||
| feature_layer_id | int4 | 10 | null |
|
|
|||||||||
| is_deleted | bool | 1 | false |
|
|
Indicates soft deletion |
||||||||
| asset_feature_layer_id | int4 | 10 | √ | null |
|
|
Foreign key which indicates if the component supports storing data from a reference asset layer, and in which layer that data should be stored |
|||||||
| component_name_full | text | 2147483647 | √ | CASE WHEN (component_subtype IS NULL) THEN component_name ELSE ((component_name || ' - '::text) || component_subtype) END |
|
|
component name concatenated with component subtype, separated by - |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| moped_components_pkey | Primary key | Asc | component_id |