cat_material - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of materials. Here is the list of all materials used in the Giswater project.
Although it is not strictly mandatory to fill out this catalog, having information about the materials in our network is crucial, so it is hardly recommended to set the materials on this table.
It its related to matcat_id columns on WS tables cat_arc, cat_node, cat_connec, cat_element and cat_link.
It its related to matcat_id columns on UD tables cat_arc, cat_node, cat_connec, cat_element, cat_gully and cat_link.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | character varying(30) | Id | PVC |
| descript | character varying(512) | Description | |
| feature_type | _text | Array of object types that can have this material | {NODE,ARC,CONNEC} |
| featurecat_id | _text | Array of features that can have this material (existing ones on cat_feature) |
{HYDRANT,SHUTOFF_VALVE} |
| n | numeric(12,4) | N | |
| link | character varying(512) | Link | c:\\users\users\catalog.pdf |
| active | boolean | If true, catalog value is being used | TRUE |