SchemaSpy Analysis of sola.address - ColumnsExtension to the LADM for capturing postal and physical addresses. Allows SOLA to support integration with external address validation services if required. Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:56 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sola.address contains 8 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
address 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).
address change_time timestamp 29,6 now() The date and time the row was last modified.
address change_user varchar 50  √  null The user id of the last person to modify the row.
address description varchar 255  √  null The postal or physical address or if no formal addressing is used, a description or place name for the location.
address 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).
address id varchar 40 Address identifier.
address rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the address_historic table
address rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.