Table sola.application.application_spatial_unit
Captures details of parcels (a.k.a. Cadastre Objects or Spatial Units) associated to an application.
Tags: FLOSS SOLA Extension, Change History

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
application_id varchar 40 application_spatial_unit_application_id_fk130 C
Identifier for the application the record is associated to.
spatial_unit_id varchar 40 application_spatial_unit_spatial_unit_id_fk131 C
Identifier of the parcel (a.k.a Cadastre Objects or Spatial Units) associated to the application.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the application_spatial_unit_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.

Analyzed at Tue May 31 09:57 NZST 2016

Column(s) Type Sort Constraint Name
application_id + spatial_unit_id Primary key Asc/Asc application_spatial_unit_pkey
application_id Performance Asc application_spatial_unit_application_id_fk130_ind
rowidentifier Performance Asc application_spatial_unit_index_on_rowidentifier
spatial_unit_id Performance Asc application_spatial_unit_spatial_unit_id_fk131_ind

Close relationships  within of separation:

Excluded from diagram's relationships: application_property.rowidentifier  application_property.change_user  application_uses_source.rowidentifier  service.rowidentifier  application.rowidentifier  service.change_action  application.rowversion  application.change_user  application_uses_source.change_user  service.change_user  application_property.rowversion  service.rowversion  application_property.change_action  application_property.change_time  service.change_time  application.change_action  application.change_time  application_uses_source.rowversion  application_uses_source.change_action  application_uses_source.change_time