Appearance
dbo.ethFormDepartureNotice
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethFormDepartureNotice.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | ID | int | no | identity | |
| 2 | Userfullname | nvarchar(100) | no | ||
| 3 | nvarchar(100) | no | |||
| 4 | DepartureDate | datetime | no | ||
| 5 | DepartureTime | time(7) | no | ||
| 6 | LineManagerId | uniqueidentifier | yes | ||
| 7 | LineManagerName | nvarchar(100) | yes | ||
| 8 | FleetReportOption | nvarchar(100) | yes | ||
| 9 | AssetToReturn | nvarchar(100) | yes | ||
| 10 | StaffDepartureCommunicated | bit | yes | ||
| 11 | CreatedAt | datetime | no | ||
| 12 | EthUserID | nvarchar(100) | yes |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK__ethFormD__3214EC271997C7D3 | CLUSTERED | yes | yes | ID |
Referenced by
Procedures: dbo.spEthFormDepartureNoticeUpsert

