SchemaSpy Analysis of sola_cs.sourceThe SOLA implementation of the LADM LA_Source class. Represents metadata about documents provided to support land related dealings. Generated by
SchemaSpy
Generated by SchemaSpy on ?? ??? 16 22:01 ALMT 2015
Database Type: PostgreSQL - 9.1.4 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Comments
administrative_source_type 3 5 Code list of administrative source types. Used by SOLA to identify document types.
Implementation of the LADM LA_AdministrativeSourceType class.
Tags: Reference Table, LADM Reference Object
archive 1 7 Represents an archive where collections of physical documents may be kept such as a filing cabinet, library or storage unit. May also refer to digital archives if applicable.
Tags: FLOSS SOLA Extension, Change History
availability_status_type 1 4 Code list of availability status types. Indicates if a document is available, archived, destroyed or incomplete. Implementation of the LADM LA_AvailabilityStatusType class.
Tags: Reference Table, LADM Reference Object
power_of_attorney 1 8 An extension of the soure.source table that captures details for power of attorney documents.
Tags: FLOSS SOLA Extension, Change History
presentation_form_type 1 4 Code list of presentation form types. Indicates the original format of the document when presented to the land office (e.g. Hardcopy, digital, image, video, etc). Implementation of the LADM CI_PresentationFormCode class.
Tags: Reference Table, LADM Reference Object
Sequence: source_la_nr_seq 0 Sequence number used as the basis for the Source nr field. This sequence is used by the generate-source-nr business rule.
source 7 6 26 Represents metadata about documents or recognised facts that provide the basis for the recording of a registration, cadastre change, right, responsibility or administrative action by the land office. Implementation of the LADM LA_Source class.
Tags: LADM Reference Object, Change History
spatial_source 1 2 8 A spatial source may be the final (sometimes formal) documents, or all documents related to a survey. Sometimes serveral documents are the result of a single survey. A spatial source may be official or not (i.e. a registered survey plan or an aerial photograph). Implementation of the LADM LA_Source class. Not used by SOLA.
Tags: LADM Reference Object, Change History, Not Used
spatial_source_measurement 1 7 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
spatial_source_type 1 4 Code list of spatial source types. Implementation of the LADM LA_SpatialSourceType class. Not used by SOLA.
Tags: Reference Table, LADM Reference Object, Not Used
Trigger Function: f_for_tbl_source_trg_change_of_status 0 Function triggered on update of the source table that updates the status of any previous version of a source record to Previous when the new source record receives a Current or Historic status.
         
11 Tables     73  
0 Views     0