watch_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
REV BIGINT 19 null
revinfo.id FK27rcb0qt1w4t8din47ew2rbna R
REVTYPE TINYINT 3 √ null
alertLevel DECIMAL 28,9 √ null
columnName VARCHAR 60 √ null
comparison INT 10 √ null
criticalLevel DECIMAL 28,9 √ null
itemDesc VARCHAR 90 √ null
itemId INT 10 √ null
lgSumTypeId INT 10 √ null
lgsumtype.id Implied Constraint R
locationGroupId INT 10 √ null
strId VARCHAR 30 √ null
sysUserId INT 10 √ null
sysuser.id Implied Constraint R
tableId INT 10 √ null
typeId INT 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation