ecreport

194 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
cashreport.ecReport_id FK_7D2900345FFE0628R
ecreportitem.ecReport_id FK_4313015B5FFE0628R
orders.ecReport_id FK_E52FFDEE5FFE0628R
user_id INT 10 null
users.id FK_329AF1E9A76ED395R
number INT 10 null
completed BIT 1 null
completedDate DATETIME 19 null
date DATE 10 null
receiptTotal DECIMAL 10,2 null
cashJournal_id VARCHAR 36 null
cashjournal.id FK_329AF1E9A0F81733R
cashReport_id VARCHAR 36 null
cashreport.id FK_329AF1E9856092CER

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_329AF1E9A0F81733 Performance Asc cashJournal_id
IDX_329AF1E9A76ED395 Performance Asc user_id
UNIQ_329AF1E9856092CE Must be unique Asc cashReport_id

Relationships