Code list of party role types. Used to identify the types of role a party can have in relation to land office transactions and data. E.g. applicant, bank, lodgingAgent, etc.
Tags: FLOSS SOLA Extension, Reference Table

Generated by
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
party_role.type_code party_role_type_code_fk37 C
The code for the party role type.
display_value varchar 500 Displayed value of the party role type.
status bpchar 1 't'::bpchar Status of the party role type
description varchar 1000  √  null Description of the party role type.

Analyzed at Tue May 31 09:58 NZST 2016

Column(s) Type Sort Constraint Name
code Primary key Asc party_role_type_pkey
display_value Must be unique Asc party_role_type_display_value_unique

Close relationships  within of separation:

Excluded from diagram's relationships: group_party.change_action  party_member.rowidentifier  party.change_time  source_describes_party.rowidentifier  party_member.change_action  party.rowidentifier  party_role.change_action  party.rowversion  party_role.change_user  party_role.change_time  party_member.change_time  source_describes_party.change_user  group_party.rowversion  source_describes_party.change_action  party_role.rowidentifier  party_role.rowversion  party_member.change_user  group_party.rowidentifier  group_party.change_user  group_party.change_time  party_member.rowversion  party.change_action  source_describes_party.change_time  source_describes_party.rowversion  party.change_user