Table sola.source.source
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

 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
id varchar 40
application_uses_source.source_id application_uses_source_source_id_fk127 C
power_of_attorney.id power_of_attorney_id_fk31 C
source_describes_ba_unit.source_id source_describes_ba_unit_source_id_fk51 C
source_describes_party.source_id source_describes_party_source_id_fk42 C
source_describes_rrr.source_id source_describes_rrr_source_id_fk49 C
spatial_source.id spatial_source_id_fk28 C
transaction_source.source_id transaction_source_source_id_fk101 C
LADM Definition: Source identifier.
maintype varchar 20  √  null
presentation_form_type.code source_maintype_fk1 R
LADM Definition: The type of the representation of the content of the source.
la_nr varchar 20 SOLA Extension: Reference number or identifier assigned to the document by the land office.
reference_nr varchar 255  √  null SOLA Extension: Reference number or identifier assigned to the document by an external agency.
archive_id varchar 40  √  null
archive.id source_archive_id_fk0 R
SOLA Extension: Archive identifier for the source.
acceptance date 13  √  null LADM Definition: The date of force of law of the source by an authority.
recordation date 13  √  null LADM Definition: The date of formalization by the source agency.
submission date 13  √  now() LADM Definition: The date of submission of the source by a party.
expiration_date date 13  √  null SOLA Extension: The date the document expires and is no longer enforceable.
ext_archive_id varchar 40  √  null SOLA Extension: Identifier of the source in an external document management system. Used by SOLA to reference the digital copy of the document in the document table.
availability_status_code varchar 20 'available'::character varying
availability_status_type.code source_availability_status_code_fk2 R
LADM Definition: The code describing the availability status of the document.
type_code varchar 20
administrative_source_type.code source_type_code_fk3 R
LADM Definition: The type of document.
content varchar 4000  √  null LADM Definition: The content of the source. Not used by SOLA as digital copies of documents are stored in the document table.
status_code varchar 20  √  null
reg_status_type.code source_status_code_fk4 R
SOLA Extension: Status (pending, current, historic) of the source. Only used for transactioned documents such as power of attorney.
transaction_id varchar 40  √  null
transaction.id source_transaction_id_fk5 C
SOLA Extension: Reference to the transaction used to register the document in SOLA. Only used for transactioned documents such as power of attorney.
owner_name varchar 255  √  null SOLA Extension: The name of the firm or bank that created the document (a.k.a. Source Agency).
version varchar 10  √  null SOLA Extension: The document version.
description varchar 255  √  null
signing_date date 13  √  null SOLA Extension: The date the document was signed by all parties.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the source_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.
classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this Source. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this Source. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc source_pkey
archive_id Performance Asc source_archive_id_fk0_ind
availability_status_code Performance Asc source_availability_status_code_fk2_ind
rowidentifier Performance Asc source_index_on_rowidentifier
maintype Performance Asc source_maintype_fk1_ind
status_code Performance Asc source_status_code_fk4_ind
transaction_id Performance Asc source_transaction_id_fk5_ind
type_code Performance Asc source_type_code_fk3_ind

Close relationships  within of separation:

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