GeoGATE affords the ability to equip database tables with editing tracking features; by enabling this feature on a certain database table, GeoGATE creates six physical columns on database tables as follows:
- created_date: timestamp for row creation time.
- create_user: the user (Database user) created the row.
- last_edited_date: timestamp for last update on row.
- last_edited_user: the last user (Database user) updated the row.
- created_web_user: the user (GeoGATE user) created the row.
- Last_edited_web_user: the last usern (GeoGATE user) updated the row.
This tool automatically creates triggers and functions required to track edits on database table.
In order to enable this feature, check the “Tracked” checkbox on data table as shown in the screenshot below.
You can see that these fields have been physically created in database; In this example, the database is PostGIS, and you can explore new fields in Parcels_Owners table from pgAdmin or QGIS Desktop. The screenshot below shows the new fields.
Now try to add a new row in order to see how tracking is working.
Now, go to database and explore the tracking fields as shown below (You can explore them in GeoGATE interface, by editing data table and adding them).