Table sola.party.party_member
Identifies the parties belonging to a group party. Implementation of the LADM LA_PartyMember class. Not used by SOLA.
Tags: LADM Reference Object, Change History, Not Used

 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
party_id varchar 40
party.id party_member_party_id_fk34 C
LADM Definition: Identifier for the party.
group_id varchar 40
group_party.id party_member_group_id_fk35 C
LADM Definition: Identifier of the group party
share float8 17,17  √  null LADM Definition: The share of a RRR held by a party member expressed as a fraction with a numerator and a denominator.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_member_historic table
rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar SOLA Extension: Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.

Analyzed at Tue May 31 09:58 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
party_id + group_id Primary key Asc/Asc party_member_pkey
group_id Performance Asc party_member_group_id_fk35_ind
rowidentifier Performance Asc party_member_index_on_rowidentifier
party_id Performance Asc party_member_party_id_fk34_ind

Close relationships  within of separation:

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