Table sola.address.address
Describes a postal or physical address.
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
party.address_id party_address_id_fk10 R
spatial_unit_address.address_id spatial_unit_address_address_id_fk90 C
Address identifier.
description varchar 255  √  null The postal or physical address or if no formal addressing is used, a description or place name for the location.
ext_address_id varchar 40  √  null Optional identifier for the address that may reference further address details from an external system (e.g. address validation database).
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the address_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:56 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc address_pkey
rowidentifier Performance Asc address_index_on_rowidentifier

Close relationships: