Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TimesheetsSeq | int identity | 4 | √ | null |
|
|
||||
| StaffID | int | 4 | null |
|
|
|||||
| PayCode | varchar | 10 | ('') |
|
|
|||||
| StartTime | datetime | 16,3 | √ | null |
|
|
||||
| EndTime | datetime | 16,3 | √ | null |
|
|
||||
| Hours | int | 4 | ((0)) |
|
|
|||||
| Minutes | int | 4 | ((0)) |
|
|
|||||
| Status | varchar | 15 | ('') |
|
|
|||||
| Comment | varchar | 255 | √ | ('') |
|
|
||||
| PostingNumber | int | 4 | √ | null |
|
|
||||
| HoursBreak | int | 4 | ((0)) |
|
|
|||||
| MinutesBreak | int | 4 | ((0)) |
|
|
|||||
| ApprovedTotalMinutes | int | 4 | ((0)) |
|
|
|||||
| TotalMinutes | int | 4 | ((0)) |
|
|
|||||
| ModifiedByDate | datetime | 16,3 | √ | null |
|
|
||||
| ModifiedByID | int | 4 | √ | null |
|
|
||||
| PayrollEmployeePayDetailGUID | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Timesheets | Primary key | Asc | TimesheetsSeq |
| AK_Timesheets_StaffID_TimesheetsSeq | Performance | Asc/Asc | StaffID + TimesheetsSeq |
Relationships
Close relationships within degrees of separation
