Table sola.administrative.rrr_type
Code list of RRR types. E.g. freehold owernship, lease, mortgage, caveat, etc. Implementation of the LADM LA_ResponsibilityType, LA_RightType and LA_RestrictionType classes.
Tags: LADM Reference Object, Reference Table

 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
br_validation.target_rrr_type_code br_validation_target_rrr_type_code_fk112 R
claim.type_code claim_fk_type_code R
request_type.rrr_type_code request_type_rrr_type_code_fk21 R
rrr.type_code rrr_type_code_fk41 R
LADM Defintion: The code for the RRR type.
rrr_group_type_code varchar 20
rrr_group_type.code rrr_type_rrr_group_type_code_fk22 R
LADM Defintion: Identifies if the RRR type is a right, restriction or a responsibility.
display_value varchar 500 LADM Defintion: Displayed value of the RRR type.
is_primary bool 1 false SOLA Extension: Flag to indicate if the RRR type is a primary RRR.
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.
party_required bool 1 LADM Defintion: Flag to indicate at least one party must be associated with this RRR.
description varchar 1000  √  null LADM Defintion: Description of the RRR type.
status bpchar 1 't'::bpchar SOLA Extension: Status of the RRR type.
rrr_panel_code varchar 20  √  null
config_panel_launcher.code rrr_type_config_panel_launcher_fkey R
SOLA Extension. Used to identify the SOLA panel class to display to the user when they view or edit the RRR.

Analyzed at Tue May 31 09:56 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
code Primary key Asc rrr_type_pkey
rrr_panel_code Performance Asc rrr_type_config_panel_launcher_fkey_ind
display_value Must be unique Asc rrr_type_display_value_unique
rrr_group_type_code Performance Asc rrr_type_rrr_group_type_code_fk22_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  rrr.rowidentifier  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  rrr.change_action  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  rrr.change_time  notation.change_user  ba_unit_target.rowversion  ba_unit.rowidentifier  ba_unit_area.rowversion  rrr.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  rrr.change_user  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