Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
AbsenceEventsDailyCalcSeq | int identity | 4 | √ | null |
|
|
||
AbsenceDate | datetime | 16,3 | √ | null |
|
|
||
ID | int | 4 | √ | null |
|
|
||
AbsenceFactor | decimal | 5,2 | √ | null |
|
|
||
AbsenceMinutes | int | 4 | √ | null |
|
|
||
CreatedDate | datetime | 16,3 | √ | null |
|
|
||
ModifiedDate | datetime | 16,3 | √ | null |
|
|
||
SlipsUnexplainedCount | int | 4 | √ | null |
|
|
||
DayStartTime | datetime | 16,3 | √ | null |
|
|
||
DayEndTime | datetime | 16,3 | √ | null |
|
|
||
TimetableGroup | varchar | 10 | √ | null |
|
|
||
FileYear | int | 4 | √ | null |
|
|
||
FileSemester | int | 4 | √ | null |
|
|
||
DayNumber | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_AbsenceEventsDailyCalc_AbsenceEventsDailyCalcSeq | Primary key | Asc | AbsenceEventsDailyCalcSeq |