Table sola.party.gender_type
Code list of gender types. Used to identify the gender of the party where the party represents an individual.
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.gender_code fk_party_gender R
party.gender_code party_gender_code_fk13 R
The code for the gender type.
display_value varchar 500 Displayed value of the gender type.
status bpchar 1 't'::bpchar Status of the gender type
description varchar 1000  √  null Description of the gender type.

Analyzed at Tue May 31 09:58 NZST 2016

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