Element tables - Giswater/giswater_dbmodel GitHub Wiki
Description:
Element tables consist of a table element_type with definition of possible element types, table element, where all the necessary data about elements is stored and relation tables, that saves the id of an element and id of a feature, work or visit with which it is related.
Element table fields:
| Column name | Data type | Description |
|---|---|---|
| element_id | character varying (16) | Id |
| code | character varying (30) | Internal code of an element |
| elementcat_id | character varying (30) | Element catalog, related to the catalog value, defined on cat_element |
| serial_number | character varying (30) | Serial number of an element |
| num_elements | integer | Number of elements |
| state | smallint | Main state of element, defined on value_state |
| state_type | smallint | Substate of element, defined on value_state_type |
| observ | character varying (254) | Description |
| function_type | character varying(50) | Function of the element, defined on man_type_function |
| category_type | character varying(50) | Function of the element, defined on man_type_category |
| fluid_type | character varying(50) | Function of the element, defined on man_type_fluid |
| location_type | character varying(50) | Function of the element, defined on man_type_location |
| workcat_id | character varying(255) | Work code related to construction of the element, defined on cat_work |
| workcat_id_end | character varying(255) | Work code related to disassemble of the element, defined on cat_work |
| buildercat_id | character varying(30) | Constructor of element, defined on cat_builder |
| builtdate | date | Data of construction |
| enddate | date | Data of disassemble |
| ownercat_id | character varying(30) | Owner of the element, defined on cat_owner |
| rotation | numeric (6, 3) | Rotation of element's symbol |
| link | character varying (512) | Link |
| verified | character varying (20) | Level of data verification, define edit_typevalue (value_verified) |
| the_geom | geometry(Point,SRID) | Point geometry of element |
| label_x | character varying(30) | Coordinate x of label location |
| label_y | character varying(30) | Coordinate y of label location |
| label_rotation | numeric(6,3) | Rotation of element's label |
| undelete | boolean | If true, element can't be deleted |
| publish | boolean | If true, element is being published |
| inventory | boolean | If true, element is a part of company's inventory |
| expl_id | integer | Id of an exploitation, defined on exploitation |
| feature_type | character varying (16) | Type of feature (automatically assigned on insert) |
| tstamp | timestamp without time zone | Date and time of data insert |
| lastupdate | timestamp without time zone | Date and time of last data update |
| lastupdate_user | character varying(50) | User that executed last update |
| insert_user | character varying(50) | User that inserted data |
| pol_id | character varying (16) | Id of polygon with which element is related (second geometry) |
Relation tables:
- element_x_arc
- element_x_connec
- element_x_node