Table sola.source.spatial_source_measurement
The observations and measurements as a basis of mapping, and as a basis for historical reconstruction of the location of (parts of) the spatial unit in the field. Implementation of the LADM OM_Observation class. Not used by SOLA.
Tags: LADM Reference Object, Change History, Not Used

 Generated by
SchemaSpy
Legend: SourceForge.net
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
spatial_source_id varchar 40
spatial_source.id spatial_source_measurement_spatial_source_id_fk30 C
LADM Definition: Spatial source identifier.
id varchar 40 LADM Definition: Spatial source measurement identifier.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the spatial_source_measurement_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:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
spatial_source_id + id Primary key Asc/Asc spatial_source_measurement_pkey
rowidentifier Performance Asc spatial_source_measurement_index_on_rowidentifier
spatial_source_id Performance Asc spatial_source_measurement_spatial_source_id_fk30_ind

Close relationships  within of separation:

Excluded from diagram's relationships: power_of_attorney.change_action  archive.change_time  spatial_source.change_action  source.rowidentifier  archive.rowidentifier  spatial_source.rowidentifier  source.rowversion  archive.change_action  power_of_attorney.rowidentifier  source.change_action  power_of_attorney.change_user  power_of_attorney.change_time  archive.rowversion  source.change_user  source.change_time  spatial_source.change_user  spatial_source.change_time  archive.change_user  power_of_attorney.rowversion  spatial_source.rowversion