m_tellers

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_cashiers.teller_id FK_m_cashiers_m_teller R
office_id int8 19 null
m_office.id FK_m_tellers_m_office R
debit_account_id int8 19 √ null
acc_gl_account.id FK_m_tellers_gl_account_debit_account_id R
credit_account_id int8 19 √ null
acc_gl_account.id FK_m_tellers_gl_account_credit_account_id R
name varchar 50 null
description varchar 100 √ null
valid_from date 13 √ null
valid_to date 13 √ null
state int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
m_tellers_pkey 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
m_tellers_office_name_unq Must be unique Asc/Asc office_id + name

Relationships

Close relationships within degrees of separation