3rows
5 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ShiftID | INTEGER | no | PK | — |
Name | TEXT | no | — | — |
StartTime | TEXT | no | — | — |
EndTime | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
HumanResources_Shift_AK_Shift_NameNameHumanResources_Shift_AK_Shift_StartTime_EndTimeStartTime + EndTime2 unique indexes inspected
HumanResources_Shift_AK_Shift_NameNameCREATE UNIQUE INDEX "HumanResources_Shift_AK_Shift_Name" ON "HumanResources.Shift" ("Name")HumanResources_Shift_AK_Shift_StartTime_EndTimeStartTime + EndTimeCREATE UNIQUE INDEX "HumanResources_Shift_AK_Shift_StartTime_EndTime" ON "HumanResources.Shift" ("StartTime", "EndTime")Data preview
Sample records
| ShiftID | Name | StartTime | EndTime | ModifiedDate |
|---|---|---|---|---|
| 1 | Day | 07:00:00.0000000 | 15:00:00.0000000 | 2008-04-30 00:00:00.000 |
| 2 | Evening | 15:00:00.0000000 | 23:00:00.0000000 | 2008-04-30 00:00:00.000 |
| 3 | Night | 23:00:00.0000000 | 07:00:00.0000000 | 2008-04-30 00:00:00.000 |
Interactive explorer