Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
account_id | NUMBER | 39 | 0 |
account_id |
Accounts |
||
action | VARCHAR2 | 8 | |||||
amount | NUMBER | 20 | 2 | ||||
date_time | TIMESTAMP | ||||||
date_transaction | TIMESTAMP | ||||||
document_number | VARCHAR2 | 90 | |||||
entity_id | NUMBER | 39 | 0 |
entity_id |
Entity |
||
transaction_id | NUMBER | 39 | 0 |
transaction_id |
Transactions |
||
transaction_number | VARCHAR2 | 138 | |||||
transaction_type | VARCHAR2 | 8 | |||||
user_id | NUMBER | 39 | 0 |
entity_id |
Entity |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
transaction_history_accounts_fk | account_id | Accounts | account_id | 1 |
transaction_history_entity_fk | user_id | Entity | entity_id | 1 |
transaction_history_entity_fk_2 | entity_id | Entity | entity_id | 1 |
transaction_history_transactions_fk | transaction_id | Transactions | transaction_id | 1 |