Table sola.administrative.notifiable_party_for_baunit
Parties to be informed about transaction on baunit.

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
party_id varchar 40
target_party_id varchar 40
baunit_name varchar 40
application_id varchar 40
service_id varchar 40
cancel_service_id varchar 40  √  null
status varchar 40 'c'::character varying
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:56 NZST 2016

Column(s) Type Sort Constraint Name
party_id + target_party_id + baunit_name Primary key Asc/Asc/Asc notifiable_party_for_baunit_pkey
rowidentifier Performance Asc notifiable_party_for_baunit_index_on_rowidentifier