Table sola_cs.party.id_type
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
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.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 ?? ??? 16 22:01 ALMT 2015

Indexes:
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: party.change_time  source_describes_party.change_action  party_member.change_time  party_role.change_action  source_describes_party.change_time  party_member.rowidentifier  party_role.rowidentifier  party_role.rowversion  group_party.rowversion  group_party.change_user  party.rowidentifier  party.change_user  party_role.change_time  group_party.change_time  group_party.rowidentifier  group_party.change_action  party.change_action  source_describes_party.rowidentifier  source_describes_party.rowversion  source_describes_party.change_user  party_member.change_user  party_member.change_action  party.rowversion  party_role.change_user  party_member.rowversion