ud_dma - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of spatial objects representing District Meter Area.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| dma_id | integer | Id | |
| name | character varying(30) | Name of the dma | dma1-1d |
| expl_id | integer | Id of an exploitation, defined on exploitation | 1 |
| macrodma_id | integer | Id of zone group, defined on macrodma | 1 |
| descript | text | Description | |
| undelete | boolean | If true, zone can't be deleted | TRUE |
| the_geom | geometry(MultiPolygon,SRID) | Multi polygon geometry of zone | |
| minc | double precision | Default value of minimun coefficient | |
| maxc | double precision | Default value of maximum coefficient | |
| effc | double precision | Default value of efficiency | |
| link | text | Link | |
| active | boolean | If true, zone is being used on the system | TRUE |
| tstamp | timestamp without time zone | Description | |
| insert_user | character varying(15) | Description | |
| lastupdate | timestamp without time zone | Description | |
| lastupdate_user | character varying(15) | Description | |
| stylesheet | json | Description | |
| dma_type | character varying(16) | Description | |
| graphconfig | json | Description |