Transaction_history

Columns

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

Foreign keys in this table

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