Table sola.transaction.transaction_status_type
Code list of transaction status types. E.g. pending, approved, cancelled, completed.
Tags: FLOSS SOLA Extension, Reference Table

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
code varchar 20
transaction.status_code transaction_status_code_fk27 R
The code for the transaction status type.
display_value varchar 500 Displayed value of the transaction status type.
description varchar 1000  √  null Description of the transaction status type.
status bpchar 1 Status of the transaction status type

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
code Primary key Asc transaction_status_type_pkey
display_value Must be unique Asc transaction_status_type_display_value_unique

Close relationships  within of separation:

Excluded from diagram's relationships: transaction_source.change_action  transaction.change_time  transaction_source.rowidentifier  transaction.change_action  transaction.rowidentifier  transaction.rowversion  transaction_source.rowversion  transaction_source.change_user  transaction.change_user  transaction_source.change_time