Table sola.application.application_uses_source
Links the application to the sources (a.k.a. documents) submitted with the application.
Tags: FLOSS SOLA Extension, Change History

 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
application_id varchar 40
application.id application_uses_source_application_id_fk126 C
Identifier for the application the record is associated to.
source_id varchar 40
source.id application_uses_source_source_id_fk127 C
Identifier of the source 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

Indexes:
Column(s) Type Sort Constraint Name
application_id + source_id Primary key Asc/Asc application_uses_source_pkey
application_id Performance Asc application_uses_source_application_id_fk126_ind
rowidentifier Performance Asc application_uses_source_index_on_rowidentifier
source_id Performance Asc application_uses_source_source_id_fk127_ind

Close relationships  within of separation:

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