m_client_transaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
acc_gl_journal_entry.client_transaction_id FK_acc_gl_journal_entry_m_client_transactionR
m_client_charge_paid_by.client_transaction_id FK_m_client_charge_paid_by_m_client_transactionR
client_id BIGINT 19 null
m_client.id FK_m_client_transaction_m_clientR
office_id BIGINT 19 null
currency_code VARCHAR 3 null
payment_detail_id BIGINT 19 √ NULL
is_reversed BIT 1 null
external_id VARCHAR 50 √ NULL
transaction_date DATE 10 null
transaction_type_enum SMALLINT 5 null
amount DECIMAL 19,6 null
created_date DATETIME 19 null
appuser_id BIGINT 19 null
m_appuser.id FK_m_client_transaction_m_appuserR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
external_id Must be unique Asc external_id
FK_m_client_transaction_m_appuser Performance Asc appuser_id
FK_m_client_transaction_m_client Performance Asc client_id

Relationships

Close relationships within degrees of separation