Code list of id types. Used to identify the types of id that can be used to verify the identity of an individual, group or organisation. E.g. nationalId, nationalPassport, driverLicense, 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.id_type_code fk_party_id_type R
party.id_type_code party_id_type_code_fk12 R
The code for the id type.
display_value varchar 500 Displayed value of the id type.
status bpchar 1 't'::bpchar Status of the id type
description varchar 1000  √  null Description of the id type.

Analyzed at Tue May 31 09:58 NZST 2016

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