StaffSchedule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StaffScheduleSeq int identity 4 √ null
EventAppointment.StaffScheduleSeq FK_EventAppointment_StaffSchedule R
StaffSchedule.ParentStaffScheduleSeq FK_ParentStaffScheduleSeq_StaffScheduleSeq R
StaffScheduleStudentClasses.StaffScheduleSeq FK_StaffScheduleStudentClasses_StaffSchedule R
StaffScheduleDefinitionSeq int 4 ((0))
StaffID int 4 null
ScheduleDateTimeFrom datetime 16,3 null
ScheduleDateTimeTo datetime 16,3 null
ScheduleDateFrom datetime 16,3 √ null
ScheduleTimeFrom datetime 16,3 √ null
ScheduleDateTo datetime 16,3 √ null
ScheduleTimeTo datetime 16,3 √ null
Comment varchar 1000 ('')
Room varchar 15 ('')
TeamCode varchar 15 ('')
ParentStaffScheduleSeq int 4 √ null
StaffSchedule.StaffScheduleSeq FK_ParentStaffScheduleSeq_StaffScheduleSeq R
AttendanceCreatedByDate datetime 16,3 √ null
AttendanceCreatedByID int 4 ('')
AttendanceModifiedByDate datetime 16,3 √ null
AttendanceModifiedByID int 4 ('')
SubjectClassesSeq int 4 √ null
SubjectClasses.SubjectClassesSeq FK_SubjectClasses_StaffSchedule R
TimesheetsSeq int 4 √ null
Timesheets.TimesheetsSeq FK_StaffSchedule_TimesheetsSeq_Timesheets_TimesheetsSeq R
ClassType varchar 15 ('')
ModifiedDatetime datetime 16,3 √ (getdate())
LocationCode varchar 15 √ null
StaffScheduleTypeCode varchar 15 √ null
Results varchar 1000 ('')
SummaryNotes varchar 2147483647 ('')
Opposition varchar 1000 ('')
ConfirmedDateTime datetime 16,3 √ null
ConfirmedByUser varchar 100 ('')
SystemProcessNumber int 4 √ null
SystemProcessControl.SystemProcessNumber FK_StaffSchedule_SystemProcessControl R

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_StaffSchedule Primary key Asc StaffScheduleSeq
AK_StaffSchedule_ParentStaffScheduleSeq Performance Asc ParentStaffScheduleSeq
AK_StaffSchedule_ScheduleDateFrom Performance Asc ScheduleDateFrom
AK_StaffSchedule_ScheduleDateTimeFrom Performance Asc ScheduleDateTimeFrom
AK_StaffSchedule_ScheduleDateTimeFrom_ScheduleDateTimeTo_includes Performance Asc/Asc ScheduleDateTimeFrom + ScheduleDateTimeTo
AK_StaffSchedule_ScheduleTimeFrom Performance Asc ScheduleTimeFrom
AK_StaffSchedule_StaffID Performance Asc StaffID
AK_StaffSchedule_SubjectClassesSeq Performance Asc SubjectClassesSeq
AK_StaffSchedule_TimesheetsSeq Performance Asc TimesheetsSeq

Relationships

Close relationships within degrees of separation