CTM_Orders

8282 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Order ID int 4 null
CTM_Notes.Order ID Implied ConstraintR
VW_CTM_PerDiemOrders.Order ID Implied ConstraintR
Status varchar 50 √ null
Shift Start Time varchar 50 √ null
Shift End Time varchar 50 √ null
Temp Id int 4 √ null
First Name varchar 100 √ null
Last Name varchar 100 √ null
Client Id int 4 √ null
Client Name varchar 200 √ null
Region Name varchar 50 √ null
Order Specialty varchar 50 √ null
Order Certification varchar 100 √ null
Floor varchar 50 √ null
Shift Number int 4 √ null
Note varchar 4000 √ null
Payroll Number varchar 200 √ null
Less Lunch Min varchar 50 √ null
Date/Time Created varchar 50 √ null
Taken By int 4 √ null
Booked By User ID int 4 √ null
Order Type ID int 4 √ null
Order Type varchar 50 √ null
City varchar 100 √ null
State varchar 20 √ null
Zip Code varchar 20 √ null
Order Source ID int 4 √ null
Order Source Name varchar 200 √ null
LT OrderID int 4 √ null
Date/Time Modified varchar 50 √ null
Subject ID int 4 √ null
Subject varchar 200 √ null
VMS int 4 √ null
AVA_insdate datetime2 16 √ (getdate())
RegionID int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_CTM_Orders Primary key Asc Order ID

Relationships

Close relationships within degrees of separation