Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IncidentSeq | int identity | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| ModifiedBy | varchar | 50 | √ | null |
|
|
||
| IncidentDate | datetime | 16,3 | √ | null |
|
|
||
| TimeInRaw | varchar | 5 | null |
|
|
|||
| IncidentTimeIn | datetime | 16,3 | √ | null |
|
|
||
| IncidentDateTimeIn | datetime | 16,3 | √ | null |
|
|
||
| TimeOutRaw | varchar | 5 | null |
|
|
|||
| IncidentTimeOut | datetime | 16,3 | √ | null |
|
|
||
| IncidentDateTimeOut | datetime | 16,3 | √ | null |
|
|
||
| IncidentType | varchar | 15 | null |
|
|
|||
| Diagnosis | varchar | 2147483647 | √ | null |
|
|
||
| Despatch | varchar | 2147483647 | √ | null |
|
|
||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| FollowUpFlag | bit | 1 | null |
|
|
|||
| FollowUp | varchar | 2147483647 | √ | null |
|
|
||
| FollowUpDate | datetime | 16,3 | √ | null |
|
|
||
| TreatedByDetails | varchar | 2147483647 | √ | null |
|
|
||
| InjuryDetails | varchar | 2147483647 | √ | null |
|
|
||
| ScaleOfInjuryCode | varchar | 15 | null |
|
|
|||
| HowInjurySustained | varchar | 2147483647 | √ | null |
|
|
||
| InjuryActionTakenCode | varchar | 15 | null |
|
|
|||
| InjuryMedicationSubscribedDetails | varchar | 2147483647 | √ | null |
|
|
||
| InjuryFollowUpDetails | varchar | 2147483647 | √ | null |
|
|
||
| InjuryReferrelCode | varchar | 15 | null |
|
|
|||
| InjuryWitnessesDetails | varchar | 2147483647 | √ | null |
|
|
||
| NotificationSentWithStudentFlag | bit | 1 | null |
|
|
|||
| ParentPhonedNotificationFlag | bit | 1 | null |
|
|
|||
| ParentPhonedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| ParentMailedNotificationFlag | bit | 1 | null |
|
|
|||
| ParentMailedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| GuardianPhonedNotificationFlag | bit | 1 | null |
|
|
|||
| GuardianPhonedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| GuardianMailedNotificationFlag | bit | 1 | null |
|
|
|||
| GuardianMailedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| HeadOfHousePhonedNotificationFlag | bit | 1 | null |
|
|
|||
| HeadOfHousePhonedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| HeadOfHouseMailedNotificationFlag | bit | 1 | null |
|
|
|||
| HeadOfHouseMailedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| HeadOfHouseEMailedNotificationFlag | bit | 1 | null |
|
|
|||
| HeadOfHouseEMailedNotificationDetails | varchar | 255 | √ | null |
|
|
||
| DirectorOfStudentsNotificationFlag | bit | 1 | null |
|
|
|||
| DirectorOfStudentsNotificationDetails | varchar | 255 | √ | null |
|
|
||
| HeadOfSchoolNotificationFlag | bit | 1 | null |
|
|
|||
| HeadOfSchoolNotificationDetails | varchar | 255 | √ | null |
|
|
||
| HeadmasterNotificationFlag | bit | 1 | null |
|
|
|||
| HeadmasterNotificationDetails | varchar | 255 | √ | null |
|
|
||
| WorkcoverClaimSubmittedFlag | bit | 1 | null |
|
|
|||
| WorkcoverClaimSubmittedDetails | varchar | 255 | √ | null |
|
|
||
| FollowupActionDetails | varchar | 2147483647 | √ | null |
|
|
||
| InjuryMedicationSubscribedDescription | varchar | 2147483647 | √ | null |
|
|
Table contained 0 rows