Table sola_cs.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 ?? ??? 16 22:00 ALMT 2015

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_uses_source.rowidentifier  service.rowversion  application_property.change_action  application.change_action  application_uses_source.change_action  application_property.change_user  application.change_time  application_uses_source.change_user  service.change_time  application_property.rowidentifier  application.change_user  service.rowidentifier  application_uses_source.rowversion  application.rowversion  application.rowidentifier  application_uses_source.change_time  application_property.rowversion  service.change_user  service.change_action  application_property.change_time