SchemaSpy Analysis of sola.cadastre - AnomaliesThe SOLA implementation of the LADM Spatial Unit Package. Represents parcels of land and water that can be associated to rights (a.k.a. Cadastre Objects) as well as general spatial or geographic features such as roads, hydro and place names, etc. General spatial features are also known as Spatial Units in SOLA.

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:
  Anomaly not detected

• Tables without indexes:

  Table
  Function: add_topo_points
  Function: cadastre_object_name_is_valid
  Function: generate_spatial_unit_group_name
  Function: get_map_center_label
  Function: get_new_cadastre_object_identifier_first_part
  Function: get_new_cadastre_object_identifier_last_part
  Function: snap_geometry_to_geometry
  Trigger Function: f_for_tbl_cadastre_object_trg_geommodify
  Trigger Function: f_for_tbl_cadastre_object_trg_new
  Trigger Function: f_for_tbl_cadastre_object_trg_remove

  10 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':
  Anomaly not detected

• Tables that contain a single column:
  Anomaly not detected

• Tables with incrementing column names, potentially indicating denormalization:
  Anomaly not detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected