cashreport

282 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.cashReport_id FK_3E0BC42E856092CER
banknotecountprotocol.cashReport_id FK_C15A35D9856092CER
cashreportitem.cashReport_id FK_AA0D882856092CER
ecreport.cashReport_id FK_329AF1E9856092CER
orders.cashReport_id FK_E52FFDEE856092CER
voucherreport.cashReport_id FK_8BACCD26856092CER
number INT 10 null
date DATE 10 null
cashJournal_id VARCHAR 36 null
cashjournal.id FK_7D290034A0F81733R
completed BIT 1 null
cashTotal DECIMAL 10,2 null
receiptTotal DECIMAL 10,2 null
outcomeTotal DECIMAL 10,2 null
banknoteCountProtocol_id VARCHAR 36 null
banknotecountprotocol.id FK_7D2900345C3545B8R
user_id INT 10 null
users.id FK_7D290034A76ED395R
completedDate DATETIME 19 null
openingInventory DECIMAL 10,2 null
ecReport_id VARCHAR 36 null
ecreport.id FK_7D2900345FFE0628R
voucherReport_id VARCHAR 36 null
voucherreport.id FK_7D29003479443B8AR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_7D290034A0F81733 Performance Asc cashJournal_id
IDX_7D290034A76ED395 Performance Asc user_id
UNIQ_7D2900345C3545B8 Must be unique Asc banknoteCountProtocol_id
UNIQ_7D2900345FFE0628 Must be unique Asc ecReport_id
UNIQ_7D29003479443B8A Must be unique Asc voucherReport_id

Relationships