| SchemaSpy Analysis of sola.publicDefault schema for all PostgreSQL databases. Contains functions supporting the PostGIS and UUID-OSSP extensions as well as some common SOLA functions. For information on PostGIS functions see http://postgis.net/docs/reference.html. For information on UUID-OSSP functions see http://www.postgresql.org/docs/9.3/static/uuid-ossp.html | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue May 31 09:59 NZST 2016 | |
| Database Type: PostgreSQL - 9.4.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Comments |
|---|---|---|---|---|
| Function: clean_db | 0 | This function will delete any table or function from the database that does not belong to the standard postgis template. | ||
| Function: clean_db_foreign_constraints | 0 | Drops all foreign key constraints from the database. | ||
| Function: clean_db_triggers | 0 | Removes all triggers and their related functions from the database. | ||
| Function: compare_strings | 0 | Performs a case insensitive comparison between 2 strings. Used by SOLA search functions. | ||
| Function: fn_triggerall | 0 | This function can be used to disable all triggers in the database. To disable all triggers in all schemas in the db - select fn_triggerall(false); To enable all triggers in all schemas in the db - select fn_triggerall(true); | ||
| Function: get_geometry_with_srid | 0 | Determines the SRID for a geometry by comparing the longitude value of its centriod to values in the system.crs table. If the geometry is in a different SRID, it is transformed into the appropriate SRID and returned, otherwise it is retuned unchanged. | ||
| Function: get_translation | 0 | Splits a SOLA formatted multi-lingual string to obtain the appropriate translation based on the users selected display language. | ||
| geography_columns | 7 | |||
| geometry_columns | 7 | PostGIS view. | ||
| raster_columns | 17 | |||
| raster_overviews | 9 | |||
| spatial_ref_sys | 5 | PostGIS table. | ||
| Trigger Function: f_for_trg_track_changes | 0 | Function triggered on insert or update of any SOLA table that is subject to history recording. The function ensures the change user details are recorded along with the date and time of the change. It also checks the rowversion to ensure the record has not been inadvertently updated by 2 or more people at the same time (i.e. implements optimistic locking) and increments the rowversion as required. | ||
| Trigger Function: f_for_trg_track_history | 0 | Function triggered on insert or update of any SOLA table that is subject to history recording. The function copies the original content of a record (i.e. before it is modified) to the appropriate _historic table. This ensures a full history of all changes to a record are maintained for audit purposes. | ||
| 10 Tables | 5 | |||
| 4 Views | 40 |