vendorparts_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FKm5lily7ephmxyl00p2kd87tdj R
REVTYPE TINYINT 3 √ null
dateCreated DATETIME 26 √ null
defaultFlag BIT 1 √ null
lastCost DECIMAL 28,9 √ null
lastDate DATETIME 26 √ null
leadTime INT 10 √ null
partId INT 10 √ null
part.id Implied Constraint R
qtyMax DECIMAL 28,9 √ null
qtyMin DECIMAL 28,9 √ null
uomId INT 10 √ null
uom.id Implied Constraint R
userId INT 10 √ null
vendorId INT 10 √ null
vendor.id Implied Constraint R
vendorPartNumber VARCHAR 70 √ null

Indexes

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

Relationships

Close relationships within degrees of separation