| SchemaSpy Analysis of sola.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 Tue May 31 09:59 NZST 2016 | |
| Database Type: PostgreSQL - 9.4.6 |
|
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 |