Implements the many-to-many relationship identifying administrative source instances with party instances

LADM Reference Object
Relationship LA_AdministrativeSource - LA_PARTY
LADM Definition
Not Defined

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
source_id varchar 40 source_describes_party_source_id_fk42 C
party_id varchar 40 source_describes_party_party_id_fk41 C
rowidentifier varchar 40 uuid_generate_v1()
rowversion int4 10 0
change_action bpchar 1 'i'::bpchar
change_user varchar 50  √  null
change_time timestamp 29,6 now()

Analyzed at Tue May 31 09:58 NZST 2016

Column(s) Type Sort Constraint Name
source_id + party_id Primary key Asc/Asc source_describes_party_pkey
rowidentifier Performance Asc source_describes_party_index_on_rowidentifier
party_id Performance Asc source_describes_party_party_id_fk41_ind
source_id Performance Asc source_describes_party_source_id_fk42_ind

Close relationships  within of separation:

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