receipt_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKc2liwj75wuhhydftax1gmwp4o R
REVTYPE TINYINT 3 √ null
locationGroupId INT 10 √ null
orderTypeId INT 10 √ null
ordertype.id Implied Constraint R
poId INT 10 √ null
po.id Implied Constraint R
soId INT 10 √ null
so.id Implied Constraint R
statusId INT 10 √ null
typeId INT 10 √ null
userId INT 10 √ null
xoId INT 10 √ null
xo.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc id + REV
FKc2liwj75wuhhydftax1gmwp4o Performance Asc REV

Relationships

Close relationships within degrees of separation