SchemaSpy Analysis of sola.transaction - ColumnsExtension to the LADM used by SOLA to track all changes made to data as a result of an application service. | Generated by SchemaSpy |
Generated by SchemaSpy on Tue May 31 09:59 NZST 2016 |
| ||||||
|
sola.transaction contains 26 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
transaction | approval_datetime | timestamp | 29,6 | √ | null | The date and time the transaction is approved. | |
transaction | bulk_generate_first_part | bool | 1 | false | Flag used by the bulk operations functionality to determine if the first_namepart for cadastre objects should be automatically generated. | ||
transaction | 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). | ||
transaction_source | 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). | ||
transaction | change_time | timestamp | 29,6 | now() | The date and time the row was last modified. | ||
transaction_source | change_time | timestamp | 29,6 | now() | The date and time the row was last modified. | ||
transaction | change_user | varchar | 50 | √ | null | The user id of the last person to modify the row. | |
transaction_source | change_user | varchar | 50 | √ | null | The user id of the last person to modify the row. | |
reg_status_type | code | varchar | 20 | The code for the registration status type. | |||
transaction_status_type | code | varchar | 20 | The code for the transaction status type. | |||
reg_status_type | description | varchar | 1000 | √ | null | Description of the registration status type. | |
transaction_status_type | description | varchar | 1000 | √ | null | Description of the transaction status type. | |
reg_status_type | display_value | varchar | 500 | Displayed value of the registration status type. | |||
transaction_status_type | display_value | varchar | 500 | Displayed value of the transaction status type. | |||
transaction | from_service_id | varchar | 40 | √ | null | The identifier of the service that initiated the transaction. NULL if the transaction has been created using other means. E.g. for migration or bulk data loading purposes. | |
transaction | id | varchar | 40 | Identifier for the transaction. | |||
transaction | is_bulk_operation | bool | 1 | false | Flag used to indicate the transaction was created in support of a bulk operation. | ||
transaction | rowidentifier | varchar | 40 | uuid_generate_v1() | Identifies the all change records for the row in the transaction_historic table | ||
transaction_source | rowidentifier | varchar | 40 | uuid_generate_v1() | Identifies the all change records for the row in the transaction_source_historic table | ||
transaction | rowversion | int4 | 10 | 0 | Sequential value indicating the number of times this row has been modified. | ||
transaction_source | rowversion | int4 | 10 | 0 | Sequential value indicating the number of times this row has been modified. | ||
transaction_source | source_id | varchar | 40 | The identifier of the source associated to the transation. | |||
reg_status_type | status | bpchar | 1 | Status of the registration status type | |||
transaction_status_type | status | bpchar | 1 | Status of the transaction status type | |||
transaction | status_code | varchar | 20 | 'pending'::character varying | The status of the transaction | ||
transaction_source | transaction_id | varchar | 40 | Identifier for the transaction. |