Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| AbsenceEventsSeq | int identity | 4 | √ | null |
|
|
||||
| MasterAbsenceEventsSeq | int | 4 | √ | null |
|
|
||||
| SupersededByAbsenceEventsSeq | int | 4 | √ | null |
|
|
||||
| AbsenceEventTypeCode | varchar | 15 | null |
|
|
|||||
| ID | int | 4 | null |
|
|
|||||
| EventDateTime | datetime | 16,3 | null |
|
|
|||||
| EventDate | datetime | 16,3 | √ | null |
|
|
||||
| EventTime | datetime | 16,3 | √ | null |
|
|
||||
| CreatedByID | int | 4 | √ | null |
|
|
||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
||||
| ModifiedByID | int | 4 | √ | null |
|
|
||||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||||
| AbsenceTypeCode | varchar | 15 | ('') |
|
|
|||||
| AbsenceReasonCode | varchar | 15 | ('') |
|
|
|||||
| SchoolInOutStatus | varchar | 5 | ('') |
|
|
|||||
| EnteredInAdvanceFlag | bit | 1 | ((0)) |
|
|
|||||
| SystemGeneratedFlag | bit | 1 | ((0)) |
|
|
|||||
| SystemProcessNumber | int | 4 | ((0)) |
|
|
|||||
| NoteReceivedFlag | bit | 1 | ((0)) |
|
|
|||||
| ContactMadeFlag | bit | 1 | ((0)) |
|
|
|||||
| ApprovedFlag | bit | 1 | ((0)) |
|
|
|||||
| ReportedByID | int | 4 | √ | null |
|
|
||||
| ReportedByName | varchar | 200 | ('') |
|
|
|||||
| EventComment | varchar | 100 | ('') |
|
|
|||||
| LeavingWithID | int | 4 | √ | null |
|
|
||||
| AbsencePeriodCode | varchar | 15 | ('') |
|
|
|||||
| ContactReceivedFlag | bit | 1 | ((0)) |
|
|
|||||
| MasterEndAbsenceEventsSeq | int | 4 | √ | null |
|
|
||||
| NoteMadeFlag | bit | 1 | ((0)) |
|
|
|||||
| TerminalCode | varchar | 15 | ('') |
|
|
|||||
| LinkedID | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AbsenceEvents | Primary key | Asc | AbsenceEventsSeq |
| AK_AbsenceEvents_AbsenceTypeCode_EventDate_includes | Performance | Asc/Asc | AbsenceTypeCode + EventDate |
| AK_AbsenceEvents_EventDate | Performance | Asc | EventDate |
| AK_AbsenceEvents_EventDateTime | Performance | Asc | EventDateTime |
| AK_AbsenceEvents_ExplainedByAbsenceEventsSeq | Performance | Asc | SupersededByAbsenceEventsSeq |
| AK_AbsenceEvents_ID | Performance | Asc | ID |
| AK_AbsenceEvents_ID_AbsenceEventsSeq | Performance | Asc/Asc | ID + AbsenceEventsSeq |
| AK_AbsenceEvents_MasterAbsenceEventsSeq | Performance | Asc | MasterAbsenceEventsSeq |
| AK_AbsenceEvents_MasterEndAbsenceEventsSeq_EventDate_includes | Performance | Asc/Asc | MasterEndAbsenceEventsSeq + EventDate |
| AK_AbsenceEvents_SystemProcessNumber | Performance | Asc | SystemProcessNumber |
Relationships
Close relationships within degrees of separation
