Table sola.source.power_of_attorney
An extension of the soure.source table that captures details for power of attorney documents.
Tags: FLOSS SOLA Extension, Change History

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
id varchar 40 power_of_attorney_id_fk31 C
Identifier for the power of attorney record. Matches the source identifier for the power of attorney record.
person_name varchar 500 The name of the person that is granting the power of attorney (a.k.a. grantor).
attorney_name varchar 500 The name of the person that will act on behalf of the grantor as their attorney.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the power_of_attorney_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar 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 The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc power_of_attorney_pkey
id Performance Asc power_of_attorney_id_fk31_ind
rowidentifier Performance Asc power_of_attorney_index_on_rowidentifier

Close relationships  within of separation:

Excluded from diagram's relationships: archive.change_time  spatial_source.change_action  spatial_source_measurement.change_time  source.rowidentifier  archive.rowidentifier  spatial_source.rowidentifier  source.rowversion  archive.change_action  spatial_source_measurement.rowidentifier  source.change_action  spatial_source_measurement.rowversion  archive.rowversion  source.change_user  spatial_source_measurement.change_action  source.change_time  spatial_source.change_user  spatial_source.change_time  archive.change_user  spatial_source.rowversion  spatial_source_measurement.change_user