CTM_Notes

14141 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Note ID int 4 √ null
Temp ID int 4 √ null
Client ID int 4 √ null
Order ID int 4 √ null
CTM_Orders.Order ID Implied ConstraintR
LT Order ID int 4 √ null
Date/Time Created varchar 50 √ null
Date/Time Modified varchar 50 √ null
Note Type ID int 4 √ null
Note Type Code varchar 200 √ null
Note Type Name varchar 500 √ null
Note varchar 4000 √ null
Make Task Y/N int 4 √ null
Task Due Date varchar 50 √ null
Task Status ID int 4 √ null
Task Priority ID int 4 √ null
Task Assign ID int 4 √ null
Date/Time Completed varchar 50 √ null
Completed By varchar 200 √ null
User IDC varchar 200 √ null
User IDM varchar 200 √ null
Submission ID int 4 √ null
Vendor ID int 4 √ null
Package ID int 4 √ null
AVA_insdate datetime2 16 (getdate())

Relationships

Close relationships within degrees of separation