| View Name: | MARIChefInfoDashboard |
| Based on table: | MPChefInfoDashboard |
| Group: | |
| Description: | Project Dash Board Settings |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DashboardID | DashboardID INT Primary |
||
| DashboardType | DashboardType INT Index |
||
| DashboardClassID | DashboardClassID INT Index |
||
| DashboardClassKey | DashboardClassKey NVARCHAR (20) Index |
||
| DashboardOrder | DashboardOrder INT |
Visible Order | |
| DashboardOrderBehind | DashboardOrderBehind INT |
Order behind Parent | MARIChefInfoDashboard.DashboardOrderBehind |
| UserMode | UserMode INT Index |
||
| UserID | UserID NVARCHAR (4) Index |
||
| DashboardName | DashboardName NVARCHAR (100) Index |
||
| PeriodFrom | PeriodFrom INT |
MARIPeriods.PeriodFrom | |
| PeriodTo | PeriodTo INT |
MARIPeriods.PeriodTo | |
| PeriodCurrent | PeriodCurrent INT |
MARIPeriods.PeriodCurrent | |
| PlanPeriodFrom | PlanPeriodFrom INT |
MARIPeriods.PlanPeriodFrom | |
| PlanPeriodTo | PlanPeriodTo INT |
MARIPeriods.PlanPeriodTo | |
| CWFrom | CWFrom INT |
Calendar Week | MARIPeriodsCalendarWeeks.CWFrom |
| CWTo | CWTo INT |
Calendar Week | MARIPeriodsCalendarWeeks.CWTo |
| CWCurrent | CWCurrent INT |
Calendar Week | MARIPeriodsCalendarWeeks.CWCurrent |
| PlanCWFrom | PlanCWFrom INT |
Calendar Week | MARIPeriodsCalendarWeeks.PlanCWFrom |
| PlanCWTo | PlanCWTo INT |
Calendar Week | MARIPeriodsCalendarWeeks.PlanCWTo |
| RightsMainApp | RightsMainApp BIGINT |
bit flag | MARIUserGroups.RightsMainApp (WHERE BenutzerTyp=1) |
| RightsLAN | RightsLAN BIGINT |
bit flag | MARIUserGroups.RightsLAN (WHERE BenutzerTyp=1) |
| RightsWAN | RightsWAN BIGINT |
bit flag | MARIUserGroups.RightsWAN (WHERE BenutzerTyp=1) |
| PictureID | PictureID INT |
MARIPictures.PictureID | |
| FilterStore | FilterStore NTEXT |
||
| MenuOption | MenuOption INT |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MARIChefInfoDashboard | Project Dash Board Settings |
| MARIChefInfoDashboardTiles | Project Dash Board Settings Tiles |