Table sola.administrative.rrr
RRR are the specific rights, restrictions and responsibilities that can be registered on a property e.g. freehold ownership, lease, mortgage, caveat, etc. Implementation of the LADM LA_RRR 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
condition_for_rrr.rrr_id condition_for_rrr_rrr_id_fk86 C
mortgage_isbased_in_rrr.mortgage_id mortgage_isbased_in_rrr_mortgage_id_fk47 C
mortgage_isbased_in_rrr.rrr_id mortgage_isbased_in_rrr_rrr_id_fk46 C
notation.rrr_id notation_rrr_id_fk76 C
party_for_rrr.rrr_id party_for_rrr_rrr_id_fk81 C
rrr_share.rrr_id rrr_share_rrr_id_fk79 C
source_describes_rrr.rrr_id source_describes_rrr_rrr_id_fk48 C
LADM Definition: Identifier for the RRR
ba_unit_id varchar 40
ba_unit.id rrr_ba_unit_id_fk42 C
LADM Definition: Identifier for the BA Unit the RRR applies to.
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.
type_code varchar 20
rrr_type.code rrr_type_code_fk41 R
LADM Definition: The type of RRR. E.g. freehold ownership, lease, mortage, caveat, etc.
status_code varchar 20 'pending'::character varying
reg_status_type.code rrr_status_code_fk43 R
SOLA Extension: The status of the 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.
transaction_id varchar 40
transaction.id rrr_transaction_id_fk44 C
SOLA Extension: Identifier of the transaction that created the RRR.
registration_date timestamp 29,6  √  null SOLA Extension: The date and time the RRR was formally registered by the Land Administration Agency.
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.
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.
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.
due_date date 13  √  null SOLA Extension: The date of the next payment for the RRR. E.g. the lease rental due date.
mortgage_interest_rate numeric 5,2  √  null LADM Definition: The interest rate of the mortgage as a percentage.
mortgage_ranking int4 10  √  null LADM Definition: The ranking order if more than one mortgage applies to the right.
mortgage_type_code varchar 20  √  null
mortgage_type.code rrr_mortgage_type_code_fk45 R
LADM Definition: The type of mortgage.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the rrr_historic table
rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
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).
change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
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.
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.

Analyzed at Tue May 31 09:56 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc rrr_pkey
ba_unit_id Performance Asc rrr_ba_unit_id_fk42_ind
rowidentifier Performance Asc rrr_index_on_rowidentifier
mortgage_type_code Performance Asc rrr_mortgage_type_code_fk45_ind
status_code Performance Asc rrr_status_code_fk43_ind
transaction_id Performance Asc rrr_transaction_id_fk44_ind
type_code Performance Asc rrr_type_code_fk41_ind

Close relationships  within of separation:

Excluded from diagram's relationships: notation.rowidentifier  source_describes_ba_unit.rowidentifier  required_relationship_baunit.change_action  source_describes_rrr.change_time  source_describes_ba_unit.change_action  source_describes_rrr.rowversion  mortgage_isbased_in_rrr.change_user  notifiable_party_for_baunit.change_time  condition_for_rrr.change_action  ba_unit_contains_spatial_unit.rowversion  source_describes_rrr.change_user  mortgage_isbased_in_rrr.rowversion  rrr_share.change_time  source_describes_rrr.rowidentifier  party_for_rrr.rowidentifier  notation.change_action  rrr_share.change_action  mortgage_isbased_in_rrr.change_action  ba_unit.rowversion  ba_unit_target.change_time  party_for_rrr.rowversion  notation.change_time  notation.rowversion  rrr_share.rowidentifier  ba_unit.change_user  source_describes_ba_unit.rowversion  required_relationship_baunit.rowversion  rrr_share.change_user  condition_for_rrr.change_time  required_relationship_baunit.rowidentifier  rrr_share.rowversion  condition_for_rrr.rowidentifier  party_for_rrr.change_user  source_describes_rrr.change_action  ba_unit_contains_spatial_unit.rowidentifier  party_for_rrr.change_time  notifiable_party_for_baunit.rowversion  condition_for_rrr.rowversion  ba_unit_contains_spatial_unit.change_user  ba_unit_contains_spatial_unit.change_time  ba_unit_target.change_user  required_relationship_baunit.change_time  condition_for_rrr.change_user  ba_unit.change_time  ba_unit_area.rowidentifier  source_describes_ba_unit.change_time  notation.change_user  ba_unit_target.rowversion  ba_unit.rowidentifier  ba_unit_area.rowversion  party_for_rrr.change_action  ba_unit_as_party.rowidentifier  ba_unit_target.rowidentifier  ba_unit_area.change_user  source_describes_ba_unit.change_user  mortgage_isbased_in_rrr.rowidentifier  ba_unit_area.change_action  ba_unit.change_action  required_relationship_baunit.change_user  notifiable_party_for_baunit.rowidentifier  ba_unit_area.change_time  ba_unit_target.change_action  ba_unit_contains_spatial_unit.change_action  notifiable_party_for_baunit.change_user  notifiable_party_for_baunit.change_action  mortgage_isbased_in_rrr.change_time