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 |
| ||||||
|
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 | rowversion | int4 | 10 | 0 | Sequential value indicating the number of times this row has been modified. | ||
address | change_time | timestamp | 29,6 | now() | The date and time the row was last modified. | ||
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 | 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. |