man_type_location - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of feature location. The value on field feature_type is obligatory as it defines to which type values relate, e.g. setting 'NODE' shows value on all feature that has type node. It may be narrowed by listing detailed featurecats on featurecat_id field and be available for only {CIRC_MANHOLE, VALVE}.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | serial | Id | |
| function_type | character varying(50) | Type name | Transport |
| feature_type | character varying(30) | Feature type to which value is related | 'NODE' |
| featurecat_id | character varying(300) | List of featurecats to which value is related, defined on cat_feature | {CIRC_MANHOLE, VALVE} |
| observ | character varying(150) | Description | |
| active | boolean | If true, catalog value is being used | TRUE |