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 |
---|---|---|---|---|---|---|
address | change_action | bpchar | 1 | 'i'::bpchar | ||
address | change_time | timestamp | 29,6 | now() | ||
address | change_user | varchar | 50 | √ | null | |
address | description | varchar | 255 | √ | null | |
address | ext_address_id | varchar | 40 | √ | null | |
address | id | varchar | 40 | |||
address | rowidentifier | varchar | 40 | uuid_generate_v1() | ||
address | rowversion | int4 | 10 | 0 |