m_tellers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_cashiers.teller_id FK_m_cashiers_m_tellerR
office_id BIGINT 19 null
m_office.id FK_m_tellers_m_officeR
debit_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_m_tellers_gl_account_debit_account_idR
credit_account_id BIGINT 19 √ NULL
acc_gl_account.id FK_m_tellers_gl_account_credit_account_idR
name VARCHAR 50 null
description VARCHAR 100 √ NULL
valid_from DATE 10 √ NULL
valid_to DATE 10 √ NULL
state SMALLINT 5 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_m_tellers_gl_account_credit_account_id Performance Asc credit_account_id
FK_m_tellers_gl_account_debit_account_id Performance Asc debit_account_id
IK_m_tellers_m_office Performance Asc office_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation