voucherreport

194 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
cashreport.voucherReport_id FK_7D29003479443B8AR
orders.voucherReport_id FK_E52FFDEE79443B8AR
voucherreportitem.voucherReport_id FK_7BED79A279443B8AR
user_id INT 10 null
users.id FK_8BACCD26A76ED395R
number INT 10 null
completed BIT 1 null
completedDate DATETIME 19 null
date DATE 10 null
receiptTotal DECIMAL 10,2 null
cashReport_id VARCHAR 36 null
cashreport.id FK_8BACCD26856092CER
cashJournal_id VARCHAR 36 null
cashjournal.id FK_8BACCD26A0F81733R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_8BACCD26A0F81733 Performance Asc cashJournal_id
IDX_8BACCD26A76ED395 Performance Asc user_id
UNIQ_8BACCD26856092CE Must be unique Asc cashReport_id

Relationships