Table sola_cs.party.source_describes_party
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
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
source_id varchar 40
source.id source_describes_party_source_id_fk42 C
party_id varchar 40
party.id 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 ?? ??? 16 22:01 ALMT 2015

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