SchemaSpy Analysis of sola.administrative - ColumnsThe SOLA implementation of the LADM Administrative package. Models land use rights and restrictions how those rights and restrictions relate to property and people. Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:56 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sola.administrative contains 208 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
ba_unit change_action bpchar 1 'i'::bpchar SOLA Extension: Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
ba_unit_area 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).
ba_unit_contains_spatial_unit 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).
ba_unit_target 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).
condition_for_rrr 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).
mortgage_isbased_in_rrr 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).
notation 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).
notifiable_party_for_baunit change_action bpchar 1 'i'::bpchar
party_for_rrr 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).
required_relationship_baunit 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).
rrr change_action bpchar 1 'i'::bpchar SOLA Extension: Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
rrr_share 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).
source_describes_ba_unit 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).
source_describes_rrr 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).
rrr is_primary bool 1 false SOLA Extension. Flag it indicate if the RRR is the primary RRR for the BA Unit. One one of the current RRRs on the BA Unit can be flagged as the primary RRR.
rrr_type is_primary bool 1 false SOLA Extension: Flag to indicate if the RRR type is a primary RRR.
rrr_type party_required bool 1 LADM Defintion: Flag to indicate at least one party must be associated with this RRR.
rrr_type share_check bool 1 LADM Defintion: Flag to indicate the that the sum of all shares for the RRR must be checked to ensure it equals 1.
ba_unit_rel_type status bpchar 1 Status of the relationship type.
ba_unit_type status bpchar 1 't'::bpchar SOLA Extension: Status of the BA Unit type.
condition_type status bpchar 1 Status of the condition type.
mortgage_type status bpchar 1 SOLA Extension: Status of the mortgage type.
rrr_group_type status bpchar 1 SOLA Extension: Status of the RRR group type.
rrr_type status bpchar 1 't'::bpchar SOLA Extension: Status of the RRR type.
rrr_share denominator int2 5 Denominator part of the share (i.e. bottom number of fraction)
rrr_share nominator int2 5 Nominiator part of the share (i.e. top number of fraction)
rrr mortgage_interest_rate numeric 5,2  √  null LADM Definition: The interest rate of the mortgage as a percentage.
condition_for_rrr condition_quantity int4 10  √  null A quantity value associted to the condition.
rrr mortgage_ranking int4 10  √  null LADM Definition: The ranking order if more than one mortgage applies to the right.
ba_unit rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
ba_unit_area rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
ba_unit_contains_spatial_unit rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
ba_unit_target rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
condition_for_rrr rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
mortgage_isbased_in_rrr rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
notation rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
notifiable_party_for_baunit rowversion int4 10 0
party_for_rrr rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
required_relationship_baunit rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
rrr rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
rrr_share rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
source_describes_ba_unit rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
source_describes_rrr rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
rrr due_date date 13  √  null SOLA Extension: The date of the next payment for the RRR. E.g. the lease rental due date.
condition_for_rrr condition_unit varchar 15  √  null The unit of measure applicable for the condition quantity.
notation reference_nr varchar 15 The notation reference number. Value determined using the generate-notation-reference-nr business rule.
rrr share float8 17,17  √  null LADM Defintion: Share of the RRR expressed as a fraction with numerator and denominator. Not used by SOLA as shares in rights are represetned in the rrr_share table. This avoids having multiple RRR of the same type on the BA Unit that only differ by share amounts.
ba_unit_area size numeric 19,2 The value of the area. Must be in metres squared and can be converted for display if requried.
ba_unit classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this Ba Unit. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
notation classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this Notation. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
rrr classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this RRR. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
ba_unit_rel_type code varchar 20 The code for the relationship type.
ba_unit_type code varchar 20 LADM Defintion: The code for the BA Unit type.
condition_type code varchar 20 The code for the condition type.
mortgage_type code varchar 20 LADM Defintion: The code for the mortgage type.
rrr_group_type code varchar 20 LADM Defintion: The code for the RRR group type.
rrr_type code varchar 20 LADM Defintion: The code for the RRR type.
condition_for_rrr condition_code varchar 20  √  null The type of condition.
rrr mortgage_type_code varchar 20  √  null LADM Definition: The type of mortgage.
ba_unit name_firstpart varchar 20 SOLA Extension: The first part of the name or reference assigned by the land administration agency to identify the property.
sys_reg_owner_name name_firstpart varchar 20  √  null
sys_reg_state_land name_firstpart varchar 20  √  null
systematic_registration_listing name_firstpart varchar 20  √  null
rrr nr varchar 20 SOLA Extension: Number to identify the RRR. Determined by the generate-rrr-nr business rule. This value is used to track the different versions of the RRR as it is edited over time.
ba_unit redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this Ba Unit. 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.
notation redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this Notation. 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.
rrr redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this RRR. 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.
required_relationship_baunit relation_code varchar 20 Code that identifies the type of relationship between the two BA Units.
rrr_type rrr_group_type_code varchar 20 LADM Defintion: Identifies if the RRR type is a right, restriction or a responsibility.
rrr_type rrr_panel_code varchar 20  √  null SOLA Extension. Used to identify the SOLA panel class to display to the user when they view or edit the RRR.
ba_unit status_code varchar 20 'pending'::character varying LADM Definition: The status of the BA unit.
notation status_code varchar 20 'pending'::character varying The status of the notation.
rrr status_code varchar 20 'pending'::character varying SOLA Extension: The status of the RRR.
ba_unit type_code varchar 20 'basicPropertyUnit'::character varying LADM Definition: The type of BA Unit. E.g. basicPropertyUnit, administrativeUnit, etc.
ba_unit_area type_code varchar 20 The type of area. E.g. officialArea, calculatedArea, etc.
rrr type_code varchar 20 LADM Definition: The type of RRR. E.g. freehold ownership, lease, mortage, caveat, etc.
rrr amount numeric 29,2  √  null LADM Definition: The value of the mortgage. SOLA Extension: The amount associated with the RRR. E.g the value of the mortgage, the rental amount for a lease, etc.
sys_reg_owner_name size numeric 29,2  √  null
sys_reg_state_land size numeric 29,2  √  null
systematic_registration_listing size numeric 29,2  √  null
ba_unit change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
ba_unit_area change_time timestamp 29,6 now() The date and time the row was last modified.
ba_unit_contains_spatial_unit change_time timestamp 29,6 now() The date and time the row was last modified.
ba_unit_target change_time timestamp 29,6 now() The date and time the row was last modified.
condition_for_rrr change_time timestamp 29,6 now() The date and time the row was last modified.
mortgage_isbased_in_rrr change_time timestamp 29,6 now() The date and time the row was last modified.
notation change_time timestamp 29,6 now() The date and time the row was last modified.
notifiable_party_for_baunit change_time timestamp 29,6 now()
party_for_rrr change_time timestamp 29,6 now() The date and time the row was last modified.
required_relationship_baunit change_time timestamp 29,6 now() The date and time the row was last modified.
rrr change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
rrr_share change_time timestamp 29,6 now() The date and time the row was last modified.
source_describes_ba_unit change_time timestamp 29,6 now() The date and time the row was last modified.
source_describes_rrr change_time timestamp 29,6 now() The date and time the row was last modified.
ba_unit creation_date timestamp 29,6  √  null SOLA Extension: The datetime the BA Unit is formally recognised by the land administration agency (i.e. registered or issued).
ba_unit expiration_date timestamp 29,6  √  null SOLA Extension: The datetime the BA Unit was superseded and became historic.
rrr expiration_date timestamp 29,6  √  null LADM Definition: The date and time defining when the RRR remains in force to. Implementation of the LADM LA_RRR.timespec field.
notation notation_date timestamp 29,6  √  null The date the notation is formalised/registered.
rrr registration_date timestamp 29,6  √  null SOLA Extension: The date and time the RRR was formally registered by the Land Administration Agency.
notifiable_party_for_baunit application_id varchar 40
ba_unit_area ba_unit_id varchar 40 Identifier for the BA Unit this area value is associated to.
ba_unit_as_party ba_unit_id varchar 40 Identifier for the BA Unit.
ba_unit_contains_spatial_unit ba_unit_id varchar 40 Identifier for the BA Unit.
ba_unit_target ba_unit_id varchar 40 Identifier for the BA Unit.
notation ba_unit_id varchar 40  √  null Identifier of the BA Unit the notation is associated with. Only populated if the notation is linked directly to the BA Unit. NULL if the notation is associated with an RRR.
rrr ba_unit_id varchar 40 LADM Definition: Identifier for the BA Unit the RRR applies to.
source_describes_ba_unit ba_unit_id varchar 40 Identifier for the BA Unit.
sys_reg_owner_name ba_unit_id varchar 40  √  null
sys_reg_state_land ba_unit_id varchar 40  √  null
systematic_registration_listing ba_unit_id varchar 40  √  null
notifiable_party_for_baunit baunit_name varchar 40
notifiable_party_for_baunit cancel_service_id varchar 40  √  null
required_relationship_baunit from_ba_unit_id varchar 40 The originating BA Unit (a.k.a. parent BA Unit). Usually a parent BA Unit will have multiple child BA Units associted to it. E.g. Island/region is the parent BA Unit for a town
ba_unit id varchar 40 LADM Definition: Identifier for the BA Unit.
ba_unit_area id varchar 40 Identifier for the BA Unit Area.
condition_for_rrr id varchar 40 Identifier for the condition.
notation id varchar 40 Identifier for the notation.
rrr id varchar 40 LADM Definition: Identifier for the RRR
rrr_share id varchar 40 Identifier for the RRR share.
sys_reg_owner_name id varchar 40  √  null
sys_reg_state_land id varchar 40  √  null
systematic_registration_listing id varchar 40  √  null
mortgage_isbased_in_rrr mortgage_id varchar 40 Identifier for the mortgage
ba_unit_as_party party_id varchar 40 Identifier for the Party.
notifiable_party_for_baunit party_id varchar 40
party_for_rrr party_id varchar 40 Identifier for the party associated to the RRR.
ba_unit rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the ba_unit_as_party table
ba_unit_area rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the ba_unit_area_historic table
ba_unit_as_party rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the ba_unit_as_party table
ba_unit_contains_spatial_unit rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the ba_unit_contains_spatial_unit_historic table
ba_unit_target rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the ba_unit_target_historic table
condition_for_rrr rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the condition_for_rrr_historic table
mortgage_isbased_in_rrr rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the ba_unit_contains_spatial_unit_historic table
notation rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the notation_historic table
notifiable_party_for_baunit rowidentifier varchar 40 uuid_generate_v1()
party_for_rrr rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the party_for_rrr_historic table
required_relationship_baunit rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the required_relationship_baunit_historic table
rrr rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the rrr_historic table
rrr_share rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the rrr_share_historic table
source_describes_ba_unit rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the source_describes_ba_unit_historic table
source_describes_rrr rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the source_describes_ba_unit_historic table
condition_for_rrr rrr_id varchar 40 Identifier of the RRR the condition relates to.
mortgage_isbased_in_rrr rrr_id varchar 40 Identifier for the RRR associated to the mortgage.
notation rrr_id varchar 40  √  null Identifier of the RRR the notation is assocaited with. Must not be populated if ba_unit_id is populated.
party_for_rrr rrr_id varchar 40 Identifier for the RRR.
rrr_share rrr_id varchar 40 Identifier of the RRR the share is assocaited with.
source_describes_rrr rrr_id varchar 40 Identifier for the RRR.
notifiable_party_for_baunit service_id varchar 40
party_for_rrr share_id varchar 40  √  null Identifier for the share the party has in the RRR. Not populated unless the RRR is subject to a shared allocation. E.g. Mortgage RRR does not have shares.
source_describes_ba_unit source_id varchar 40 Identifier for the source associated with the BA Unit.
source_describes_rrr source_id varchar 40 Identifier for the source associated with the RRR.
ba_unit_contains_spatial_unit spatial_unit_id varchar 40 Identifier for the Spatial Unit associated to the BA Unit.
notifiable_party_for_baunit status varchar 40 'c'::character varying
notifiable_party_for_baunit target_party_id varchar 40
required_relationship_baunit to_ba_unit_id varchar 40 The target BA Unit (a.k.a. child BA Unit). For any given relationship type, the child BA Unit will usually only have one logical parent BA Unit. E.g. A new title is the child BA Unit of the original title that is being superseded.
ba_unit transaction_id varchar 40  √  null SOLA Extension: Reference to the SOLA transaction that created the BA Unit.
ba_unit_target transaction_id varchar 40 Identifier for the transaction to cancel the BA Unit.
notation transaction_id varchar 40 Identifier of the transaction that created the notation.
rrr transaction_id varchar 40 SOLA Extension: Identifier of the transaction that created the RRR.
ba_unit change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
ba_unit_area change_user varchar 50  √  null The user id of the last person to modify the row.
ba_unit_contains_spatial_unit change_user varchar 50  √  null The user id of the last person to modify the row.
ba_unit_target change_user varchar 50  √  null The user id of the last person to modify the row.
condition_for_rrr change_user varchar 50  √  null The user id of the last person to modify the row.
mortgage_isbased_in_rrr change_user varchar 50  √  null The user id of the last person to modify the row.
notation change_user varchar 50  √  null The user id of the last person to modify the row.
notifiable_party_for_baunit change_user varchar 50  √  null
party_for_rrr change_user varchar 50  √  null The user id of the last person to modify the row.
required_relationship_baunit change_user varchar 50  √  null The user id of the last person to modify the row.
rrr change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
rrr_share change_user varchar 50  √  null The user id of the last person to modify the row.
source_describes_ba_unit change_user varchar 50  √  null The user id of the last person to modify the row.
source_describes_rrr change_user varchar 50  √  null The user id of the last person to modify the row.
ba_unit name_lastpart varchar 50 SOLA Extension: The remaining part of the name or reference assigned by the land administration agency to identify the property.
sys_reg_owner_name name_lastpart varchar 50  √  null
sys_reg_state_land name_lastpart varchar 50  √  null
systematic_registration_listing name_lastpart varchar 50  √  null
ba_unit name varchar 255  √  null LADM Definition: The name of the BA Unit. Usually a concatenation of the name_firstpart and name_lastpart formatted as required.
condition_for_rrr custom_condition_text varchar 500  √  null User entered text describing the condition and/or updated or revised text obtained from the template condition text.
ba_unit_rel_type display_value varchar 500 Displayed value of the relationship type.
ba_unit_type display_value varchar 500 LADM Defintion: Displayed value of the BA Unit type.
condition_type display_value varchar 500 Displayed value of the condition type.
mortgage_type display_value varchar 500 LADM Defintion: Displayed value of the mortgage type.
rrr_group_type display_value varchar 500 LADM Defintion: Displayed value of the RRR group type.
rrr_type display_value varchar 500 LADM Defintion: Displayed value of the RRR type.
ba_unit_rel_type description varchar 1000  √  null Description of the relationship type.
ba_unit_type description varchar 1000  √  null LADM Defintion: Description of the BA Unit type.
mortgage_type description varchar 1000  √  null LADM Defintion: Description of the mortgage type.
rrr_group_type description varchar 1000  √  null LADM Defintion: Description of the RRR group type.
rrr_type description varchar 1000  √  null LADM Defintion: Description of the RRR type.
notation notation_text varchar 1000  √  null The text of the notation. Note that template notation text can be obtained from the request type (i.e. service) the notation has been created as part of.
condition_type description varchar 10000 The template text describing the condition.
sys_reg_owner_name agricultural numeric 131089  √  null
sys_reg_state_land agricultural numeric 131089  √  null
sys_reg_owner_name commercial numeric 131089  √  null
sys_reg_state_land commercial numeric 131089  √  null
sys_reg_owner_name industrial numeric 131089  √  null
sys_reg_state_land industrial numeric 131089  √  null
sys_reg_owner_name residential numeric 131089  √  null
sys_reg_state_land residential numeric 131089  √  null
sys_reg_owner_name land_use_code varchar 2147483647  √  null
sys_reg_state_land land_use_code varchar 2147483647  √  null
systematic_registration_listing land_use_code varchar 2147483647  √  null
sys_reg_owner_name last_name text 2147483647  √  null
sys_reg_owner_name name text 2147483647  √  null
systematic_registration_listing name text 2147483647  √  null
sys_reg_owner_name value text 2147483647  √  null
sys_reg_state_land value text 2147483647  √  null