banknotecountprotocol

262 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
banknotecount.banknoteCountProtocol_id FK_67067AC65C3545B8R
cashreport.banknoteCountProtocol_id FK_7D2900345C3545B8R
cashTotal DECIMAL 10,2 null
cashReport_id VARCHAR 36 √ null
cashreport.id FK_C15A35D9856092CER
user_id INT 10 √ null
users.id FK_C15A35D9A76ED395R
intermediate BIT 1 null
created DATETIME 19 √ null
systemTotal DECIMAL 10,2 √ null
cashJournal_id VARCHAR 36 √ null
cashjournal.id FK_C15A35D9A0F81733R
customTotal DECIMAL 10,2 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_C15A35D9A0F81733 Performance Asc cashJournal_id
IDX_C15A35D9A76ED395 Performance Asc user_id
UNIQ_C15A35D9856092CE Must be unique Asc cashReport_id

Relationships

Close relationships within degrees of separation