cashjournal

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
banknotecountprotocol.cashJournal_id FK_C15A35D9A0F81733R
cashreport.cashJournal_id FK_7D290034A0F81733R
ecreport.cashJournal_id FK_329AF1E9A0F81733R
voucherreport.cashJournal_id FK_8BACCD26A0F81733R
client_id VARCHAR 36 √ null
client.id FK_A7F52B619EB6921R
created DATETIME 19 null
number INT 10 null
posTerminal_id VARCHAR 36 √ null
posterminal.id FK_A7F52B64BE3C43ER
completed BIT 1 null
completedDate DATETIME 19 √ null
completedByUser_id INT 10 √ null
users.id FK_A7F52B634956C29R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_A7F52B619EB6921 Performance Asc client_id
IDX_A7F52B634956C29 Performance Asc completedByUser_id
IDX_A7F52B64BE3C43E Performance Asc posTerminal_id

Relationships

Close relationships within degrees of separation