Table sola.party.communication_type
Code list of communication types. Used to identify the types of communication that can be used between the land administration agency and their clients.
Tags: FLOSS SOLA Extension, 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
party.preferred_communication_code party_preferred_communication_code_fk11 R
The code for the communication type.
display_value varchar 500 Displayed value of the communication type.
status bpchar 1 't'::bpchar Status of the communication type
description varchar 1000  √  null Description of the communication type.

Analyzed at Tue May 31 09:58 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
code Primary key Asc communication_type_pkey
display_value Must be unique Asc communication_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