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

 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
code varchar 20
attachment.type_code fk_document_type_code R
request_type_requires_source_type.source_type_code request_type_requires_source_type_source_type_code_fk128 C
source.type_code source_type_code_fk3 R
LADM Definition: The code for the administrative source type.
display_value varchar 500 LADM Definition: Displayed value of the administrative source type.
status bpchar 1 SOLA Extension: Status of the administrative source type
description varchar 1000  √  null LADM Definition: Description of the administrative source type.
is_for_registration bool 1  √  false SOLA Extension: Flag that identifies whether documents of this type must be formally registered in SOLA before they can be used in rights registration. E.g. Power of Attorney documents must be registered in SOLA before they can be associated with transfer transactions, etc.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
code Primary key Asc administrative_source_type_pkey
display_value Must be unique Asc administrative_source_type_display_value_unique

Close relationships  within of separation:

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