SystemProcessControl


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SystemProcessNumber int identity 4 √ null
Events.AbsenceEventsSystemProcessNumber FK_Events_AbsenceEventsSystemProcessNumber R
Objects.SystemProcessNumber FK_Objects_SystemProcessControl R
StaffSchedule.SystemProcessNumber FK_StaffSchedule_SystemProcessControl R
StudentAwards.SystemProcessNumber FK_StudentAwards_SystemProcessControl R
SubjectClassStaff.SystemProcessNumber FK_SubjectClassStaff_SystemProcessControl R
SystemProcessControlPrints.SystemProcessNumber FK_SystemProcessControlPrints_SystemProcessControl R
VSNBatches.SystemProcessNumber FK_VSNBatches_SystemProcessControl R
wkStudentNZMOEENROL.SystemProcessNumber FK_wkStudentNZMOEENROL_SystemProcessControl R
wkStudentNZMOEGetNSN.SystemProcessNumber FK_wkStudentNZMOEGetNSN_SystemProcessControl R
CreatedDate datetime 16,3 √ (getdate())
CreatedBy varchar 50 √ null
ProcessDate datetime 16,3 √ (getdate())
SystemCode varchar 15 ('')
CompleteFlag bit 1 ((0))
DeletedFlag bit 1 ((0))
ProcessDescription varchar 255 ('')
SystemSubCode varchar 15 ('')
CreatedByID int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_SystemProcessControl Primary key Asc SystemProcessNumber
AK_SystemProcessControl_CreatedByID Performance Asc CreatedByID
AK_SystemProcessControl_SystemCode Performance Asc SystemCode

Relationships

Close relationships within degrees of separation