Plugin installed incorrectly. Rename plugin directory 'swiftmail.backup' to 'swiftmail'.
en:software:dashboard:dashboard_tablestructure
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:software:dashboard:dashboard_tablestructure [2018/07/11 10:01] Julian Le |
en:software:dashboard:dashboard_tablestructure [2021/07/01 09:52] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ===== Conditions for an evaluation ===== | ||
| - | ===== Requirements for an analysis ===== | + | Evaluations are defined by SQL-Statements. Therefor only the following predefined [[:en:software:dashboard:dashboard_views|dashboard views]] can be used. |
| - | A standard SQL statement can be initiated in order to conduct an analysis. For this analysis to be successful the predefined [[dashboard_views|database views]] have to be used. The new structure can be seen [[en:software:dashboard:dashboard_tablestructure_v2|here ]]. | + | |
| - | <note tip>Please note the comments further down on the page!</note> | ||
| ---- | ---- | ||
| - | ===== An Overview of the Tables ===== | + | ===== Old Views ===== |
| - | {{ software:dashboard:sqllogo.jpg }} | + | |
| - | ---- | + | If you are still using the old views, they can be looked into [[:en:software:dashboard:dashboard_tablestructure_old|here]]. |
| - | ===== Explanation of the Table Contents ===== | + | <note important>Please contact the support before the update, because column names change and widgets have to be adjustzed after the update!</note> |
| - | <note tip>the **clientID** field always references the id of the view_identity</note> | + | ---- |
| - | === view_activity === | + | |
| + | ====== Explanation of table contents ====== | ||
| + | |||
| + | {{ :dashboard_views.png?332x500}} | ||
| + | |||
| + | * **id **contains the so called primary key and is a unique key in the table. | ||
| + | * **instanceId **contains the primary key of the processinstance that corresponds to this object/entry. | ||
| + | * **<placeholder>****Name**contains the object's name. | ||
| + | * **<placeholder>****Description**contains the object's description. | ||
| + | * **<placeholder>Start** returns the time, when the process became active on this object. A task can e.g. be crated earlier and be started at a later point in time. | ||
| + | * **<placeholder>End** returns the time, when the process left this object. | ||
| + | * **creationTime **is the entry's creation time. | ||
| + | * **creationUserId **contains the primary key (see id) of the user, which created the entry. | ||
| + | * **is<Placeholder>**contains a true/false value. | ||
| + | * **isArchiv** indicates, whether the object is already archived or not. | ||
| + | —- | ||
| + | |||
| + | view_activity | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: Name of the activity | + | * **activityName**: Name of the activity |
| + | * **activityDescription**: Contains a description of the activity | ||
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| * **creationTime**: The exact point in time when the activity was initiated | * **creationTime**: The exact point in time when the activity was initiated | ||
| * **creationUserId**: A number referencing the impacted user | * **creationUserId**: A number referencing the impacted user | ||
| * **instanceId**: A number which references an impacted instance in which the activity is active | * **instanceId**: A number which references an impacted instance in which the activity is active | ||
| - | * **start**: The exact point in time when this activity was started | + | * **activityStart**: The exact point in time when this activity was started |
| - | * **end**: The exact point in time when the activity was finally terminated | + | * **activityEnd**: The exact point in time when the activity was finally terminated |
| - | * **loopCount**: The number of runs of an activity | + | * **loopCount**: If the process runs through the activity repeatedly (loops), the runs are saved here. |
| - | * **duration**: The maximum duration of processing time assigned to this activity | + | * **duration**: contains the activity's maximum and modelled process time. |
| - | * **escalationTime**: The calculated point in time for the next escalation within the activity | + | * **escalationTime**: contains the calculated time of the activity's next escalation. |
| - | * **estimatedEnd**: Shows the estimated end-date of the acticity | + | * **estimatedEnd**: contains the activity's expected end date. |
| - | * **milestone**: This entry displays if this activity is considered to be a milestone indicating the achievement of a certain benchmark | + | * **mileStoneDate**: contains the time, when the next milestone should be reached. |
| - | * **mileStoneDate**: The point in time when this milestone has to be accomplished | + | * **elapsedTime**: contains the elapsed time for processing the activity. |
| - | * **elapsedTime**: Shows the time which has already been taken for task completion | + | * **timeBuffer**: contains the calculated buffer for this activity. |
| - | * **inTime**: Shows if the activity is still running in accordance with the time-plan | + | * **calculatedEST**: [[:en:support:cpm|Calculated earliest start time]] |
| - | * **timeBuffer**: Calculated "buffer" time for the activity | + | * **calculatedEFT**: [[:en:support:cpm|Calculated earliest finish time]] |
| - | * **calculatedEST**: [[:en:support:cpm|The calculated earliest starting time]] | + | * **calculatedLST**: [[:en:support:cpm|Calculated latest start time]] |
| - | * **calculatedEFT**: [[:en:support:cpm|The calculated earliest ending time]] | + | * **calculatedLFT**: [[:en:support:cpm|Calculated latest finish time]] |
| - | * **calculatedLST**: [[:en:support:cpm|The calculated latest point in time for starting]] | + | * **valueEST**: pure time display of [[:en:support:cpm|earliest start time]] (contains [[:en:software:tim:calendar_profile|Business Calender]]) |
| - | * **calculatedLFT**: [[:en:support:cpm|The calculated latest point in time for ending]] | + | * **valueEFT**: pure time display of [[:en:support:cpm|earliest finish time]] (contains [[:en:software:tim:calendar_profile|Business Calender]]) |
| - | * **valueEST**: The net time specification for [[:en:support:cpm|the earliest starting point]] (contains the [[:en:software:tim:calendar_profile|Business Calender]]) | + | * **valueLST**: pure time display of [[:en:support:cpm|latest start time]] (contains [[:en:software:tim:calendar_profile|Business Calender]]) |
| - | * **valueEFT**: The net time specification for [[:en:support:cpm|the earliest ending point]](contains the [[:en:software:tim:calendar_profile|Business Calender]]) | + | * **valueLFT**: pure time display of [[:en:support:cpm|latest finish time]] (contains [[:en:software:tim:calendar_profile|Business Calender]]) |
| - | * **valueLST**: The net time specification for [[:en:support:cpm|the latest starting point]](contains the [[:en:software:tim:calendar_profile|Business Calender]]) | + | * **activityType**: returns type of activity (ScriptNode, Tasknode, Mailnode,…). |
| - | * **valueLFT**: The net time specification for [[:en:support:cpm|the latest ending point]](contains the [[:en:software:tim:calendar_profile|Business Calender]]) | + | * **isMilestone**: indicates, whether the activity is a milestone or not. |
| - | * **type**: Returns the type of the activity (scriptnode, tasknode, mailnode, etc.) | + | * **inTime**: indicates, whether the activity is still on schedule or not. |
| === view_definition === | === view_definition === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: The name of the process definition | + | * **definitionName**: The name of the process definition |
| + | * **definitionDescription**: Contains a description of the definition | ||
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| - | * **creationTime**: Point in time at which the process definition was [[:en:software:tim:deploy_processdefinition|deployed]] | + | * **creationTime**: Point in time at which the process definition was [[:en:software:dashboard:en:software:tim:deploy_processdefinition|deployed]] |
| - | * **creationUserId**: The unique ID of the user who [[:en:software:tim:deploy_processdefinition|deployed]] the task instance | + | * **creationUserId**: The unique ID of the user who [[:wiki.tim-solutions.de:doku.php?id=:en:software:dashboard:en:software:tim:deploy_processdefinition|deployed]] the task instance |
| - | * **description**: A description of the process definition | + | * **version**: processdefinition's present version |
| - | * **version**: Version in which the process definition is found | + | * **escalationStatus**: statement about the process' escalation status |
| - | * **escalationStatus**: Information pertaining to the escalation status o the process | + | * **owner**: process owner (or group) |
| - | * **owner**: The user or group responsible for the process | + | * **starter**: User or group, who is allowed to start the definition. |
| - | * **starter**: User or group who has the right to start the definition | + | * **deployer**: User or group, who is allowed to deploy the definition. |
| - | * **deployer**: User or group who has the right to deploy the definition | + | * **isArchiv**: indicates, whether the definition is already archived or not. |
| - | * **archived**: Tells whether or not the instance has already been archived | + | |
| === view_effort === | === view_effort === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: The name assigned to the effort | + | * **effortName**: The name assigned to the effort |
| + | * **effortDescription** | ||
| * **clientId**: The number corresponding to the impacted client | * **clientId**: The number corresponding to the impacted client | ||
| * **creationTime**: The point in time at which this effort was made | * **creationTime**: The point in time at which this effort was made | ||
| * **creationUserId**: The unique ID of the user who is responsible for causing the effort | * **creationUserId**: The unique ID of the user who is responsible for causing the effort | ||
| - | * **effortType**: The type of effort ("time invested" or "money spent") | ||
| - | * **value**: Information on the value of the effort without using an unit | ||
| - | * **description**: Description of the effort | ||
| - | * **costCenterName**: The name of the cost center responsible for the effort | ||
| * **instanceId**: The number corresponding to the impacted instance | * **instanceId**: The number corresponding to the impacted instance | ||
| - | * **parentFolderId**: The number corresponding to the impacted virtual index | + | * **effortType**: type of effort (time or money) |
| + | * **effortValue**: value of effort without unit | ||
| + | * **timeValue: **contains the time effort. | ||
| + | * **financeValue **contains the financial effort and the cost center's consideration in the moment of capture. | ||
| + | * **costcenterName**: contains the cost center, on which the effort was booked. | ||
| + | * **currency: **contains the currency, with which the effort was booked, in the moment of capture. | ||
| + | * **hourlyRate **contains the cost center's hourly pay in the moment of capture. | ||
| + | * **parentFolderId**: contains the corresponding folder's primary key. | ||
| === view_identity === | === view_identity === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: Name of the user | + | * **identityName**: Contains the name if the identity |
| - | * **displayName**: Contains the complete name and user name **(i.e. John Doe (J. Doe))** | + | |
| * **clientId**: A number corresponding to the client at hand | * **clientId**: A number corresponding to the client at hand | ||
| * **creationTime**: The point in time when this identity/user was created | * **creationTime**: The point in time when this identity/user was created | ||
| - | * **lastLogin**: Contains the time at which the user last logged in | ||
| * **creationUserId**: The number corresponding to of the user who created this user/group/client | * **creationUserId**: The number corresponding to of the user who created this user/group/client | ||
| - | * **identityType**: The type of identity/user (e.g., user, group, client) | + | * **displayName**: contains the full name and username (e.g. **Max Mustermann (M.Muster)**). |
| - | * **email**: The e-mail address of the user or group | + | * **lastLogin**: contains the time, when the user last logged in. |
| - | * **firstname**: The first name of the user | + | * **loginCount**: contains the user's number of logins. |
| - | * **lastname**: The surname of the user | + | * **identityType**: user's type of identity, can have following values: 'USER', 'GROUP', 'MEMBERSHIP' or 'CLIENT' |
| - | * **archived** : Indicates if this iuser/group/client has already been archived | + | * **email**: user's or group's email-address |
| - | * **blocked**: Indicates if this iuser/group/client is blocked | + | * **firstname**: user's first name |
| - | * **userID**: Contains a number pointing to a user who belongs to this community | + | * **lastname**: user's last name |
| - | * **parentID**: Contains the number, which points to the group who belongs to this community | + | * **parentUserId**: contains primary key, that points to the group, which belongs to this membership. |
| + | * **userID** : contains primary key, that points to the user, which belongs to this membership (only affects identityType 'MEMBERSHIP'). | ||
| + | * **userProfileId**: contains the primary key that contains the userprofile. | ||
| + | * **isBlocked**: indicates whether this user/group/client is blocked or not | ||
| + | * **isArchiv**: indicates whether this user/group/client is archived or not | ||
| === view_instance === | === view_instance === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: The name of the process instance | + | * **instanceName**: The name of the process instance |
| - | * **definitionName**: The name of the superordinate process definition | + | * **instanceDescription**: Contains a description of the instance |
| * **clientId**: A number affiliated with client of the process instance | * **clientId**: A number affiliated with client of the process instance | ||
| * **creationTime**: The point in time at which the process instance was started | * **creationTime**: The point in time at which the process instance was started | ||
| - | * **key**: This displays the value generated by the [[:en:software:tim:actionhandler:yearidgenerator|YearIDGenerator]], assuming that this functionality is enabled | ||
| * **creationUserId**: A number corresponding to the user who started this process instance | * **creationUserId**: A number corresponding to the user who started this process instance | ||
| - | * **definitionId**: A number corresponding to the process definition that is at the base of this instance | + | * **creationGroupId **:contains the primary key of the group that started the process |
| - | * **instanceDescription**: An additional description of the process instance | + | * **rootTokenId**: contains the primary key of the current token, that points to the current activity. |
| - | * **creationGroup**: A number corresponsing to the group that initiated the process instance | + | * **parentProcessToken**: contains the primary key tha points to the corresponding main process. |
| - | * **end**: This is the exact point in time when the process instance was terminated | + | * **instanceKey**: contains the created value of the [[:en:software:tim:actionhandler:yearidgenerator|YearIDGenerator]], if it was used. |
| - | * **archive**: This reports if this process instance has already been archived | + | * **definitionId**: contains a number that points to a processdefinition, which underlies this instance. |
| - | * **archivationUserId** : This provides information on the UserID of the user who archived this instance | + | * **definitionName**: the underlying processdefinition's name |
| - | * **rootToken**: This entry gives details about the progress of the process instance (the current node is marked by this token) | + | * **instanceStart**: This is the exact point in time when the process instance was started |
| - | * **parentProcessToken**: If the current process instance is only a subordinate process, then this is the token attributed to the related main process | + | * **instanceEnd**: This is the exact point in time when the process instance was terminated |
| - | * **nextEscalationTime**: This entry shows the calculated point in time pertaining to the next escalation of the process | + | * **archivationUserId** : contains the primary key that points to the user, which archived this instance. |
| - | * **processVariableIndex**: —- | + | * **archivationTime: **point in time, where the processinstance was archived |
| - | * **index1-10 and value1-10**: Important information of the process instance, the worth of which stands in value and the position is given over the index. | + | * **nextEscalationTime**: contains the calculated time of the process' next escalation. |
| + | * **index1-10 und value1-10**: Aall indexnames and values which were labeled as indexvalues in the process. | ||
| + | * **isArchiv**: statement whether the processinstance is already archived or not | ||
| === view_swimlane === | === view_swimlane === | ||
| - | * **id**: The unique identification number used throughout the entire database | + | * **id**:The unique identification number used throughout the entire database |
| - | * **name**: name of the swimlane | + | * **swimlaneName**: name of the swimlane |
| - | * **clientID**: A number corresponding to the client at hand | + | * **clientId**: A number corresponding to the client at hand |
| - | * **instanceId**: A number corresponding to the corresponding instance | + | * **instanceId**: contains the primary key which points to the corresponding instance. |
| - | * **actor**: A number corresponding to the associated user | + | * **actorId**: contains the primary key that points to the current corresponding user. |
| - | * **pooledActor**: A number corresponding to the associated group | + | * **pooledActorId**: contains the primary key that points to the corresponding group |
| === view_task === | === view_task === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: Name of the task | + | * **taskName**:Name of the task |
| + | * **taskDescription**: Contains a description of the task | ||
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| * **creationTime**: The exact point in time when the task was initiated | * **creationTime**: The exact point in time when the task was initiated | ||
| * **creationUserId**: A number referencing the impacted user | * **creationUserId**: A number referencing the impacted user | ||
| * **instanceId**: A number which references an impacted instance in which the task is active | * **instanceId**: A number which references an impacted instance in which the task is active | ||
| - | * **start**: The exact point in time when this task was started | + | * **taskStart**: The exact point in time when this task was started |
| - | * **end**: The exact point in time when the task was finally terminated | + | * **taskEnd**: The exact point in time when the task was finally terminated |
| - | * **isOpen**: Denotes if a task has already been completed (Caution! not all signal-methods complete tasks) | + | * **actorId**:contains the primary key that points to the current corresponding user. |
| - | * **swimlaneId**: Contains a number referencing the swimlane in which the tasks is held | + | * **pooledActorId**: contains the primary key that points to the current corresponding group. |
| - | * **actor**: A number corresponding to the associated user | + | * **activityId**: contains the primary key that points to the superordinate activity. |
| - | * **pooledActor**: Contains a number referencing the currently associated group | + | * **parentFolderId**: contains the corresponding folder's primary key. |
| - | * **activity**: contains a number there corresponds to the superordinate activity | + | * **swimlaneId**: contains the primary key that points to the swimlane, in which the task lies. |
| - | * **isAdhoc**: Shows whether this activity was ranked as an [[:en:software:tim:ad_hoc_tasks|AdHoc-task]] or not | + | * **remainingTime**:contains the remaining time for processing the activity. |
| - | * **parentFolderId**: A number corresponding to the impacted virtual index | + | * **elapsedTime**: contains the elapsed time for processing the activity. |
| - | * **archive**: This reports if this task has already been archived | + | * **isOpen**: indicates whether the task is finished or not (Attention! Signal-Methods often do not finish tasks!) |
| - | * **remainingTime**: Shows the time which remains for task completion | + | * **isAdhoc**: indicates whether this task was created as an [en[:software:tim:ad_hoc_tasks|AdHoc task]] or not |
| - | * **elapsedTime**: Shows the time which has already been taken for task completion | + | * **isArchiv**: |
| === view_token === | === view_token === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name**: The name of the token | + | * **tokenName**: The name of the token |
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| - | * **nodeInstance**: Contains the number of the activity corresponding ot this task | + | * **instanceId**: contains the primary key which points to the corresponding instance. |
| - | * **instanceId**: Contains the number corresponding to the associated instance | + | * **activityId**: contains the primary key which points to the corresponding activity. |
| - | * **parent**: The number corresponding to the main process | + | * **parentTokenId**: contains the primary key which points to a sub-token. If the Roottoken is on a closing AND gateway, a sub-token is found for each entry/exit |
| === view_variable === | === view_variable === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name** : Name of the instance variable | + | * **variableName**: Name of the instance variable |
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| - | * **instanceId**: A number referencing the corresponding instance | + | * **instanceId**: contains a number which points to the corresponding instance |
| - | * **stringValue**: Contains the content of the process variable | + | * **stringValue**: contains the processvariable's content |
| - | * **label**: Contains the label associated with the process variable | + | * **label**: contains the processvariable's corresponding label |
| === view_role === | === view_role === | ||
| - | * **identityId**: Contains the number corresponding to the currently-associated user | + | * **identityId**: contains the primary key that points to the current corresponding user. |
| - | * **roleId**: Contains the number corresponding to the currently-associated role | + | * **roleId**: contains the primary key that points to the current corresponding role. |
| === view_costcenter === | === view_costcenter === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| + | * **costcenterName**: Name of the cost center | ||
| + | * **costcenterDescription**: Contains a description of the costcenter | ||
| * **clientId**: A number referencing a specific client | * **clientId**: A number referencing a specific client | ||
| * **creationTime**: The exact point in time when the cost center was initiated | * **creationTime**: The exact point in time when the cost center was initiated | ||
| * **creationUserId**: A number referencing the user who created the cost center | * **creationUserId**: A number referencing the user who created the cost center | ||
| - | * **name** : Name of the cost center | + | * **hourly**: contains the cost center's hourly pay |
| - | * **description**: Description of the cost center | + | * **currency**: contains the cost center's currency |
| - | * **hourly**: Contains the hourly rate of the cost center | + | |
| - | * **currency**: The currency in which the cost center is calculated | + | |
| === view_systemconfiguration === | === view_systemconfiguration === | ||
| * **id**: The unique identification number used throughout the entire database | * **id**: The unique identification number used throughout the entire database | ||
| - | * **name** : The name of the configuration | + | * **configurationName**:The name of the configuration |
| + | * **clientId**: A number corresponding to the impacted client | ||
| * **creationTime**: Contains the creation time of the configuration | * **creationTime**: Contains the creation time of the configuration | ||
| - | * **lastModificationTime**: Contains the time at which the profile was last modified | + | * **costCenter** : user's cost center from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **ignoreLDAPAuthentification**: Field "ignore LDAP Authenfication" in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **department**: user's department from the[[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **notifyAsignee**: Field "Notify asignee if his task is done by somebody else" in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **personnelNumber** : user's personnel number from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **notifyByMail** : Field "Email-Notification preferred" in the [[:en:software:tim:userprofil_profile|userprofile]] or from the [[:en:software:tim:client_profile|client profile]] | + | * **phoneNumber** : user's telephone number from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **costCenter** : Cost center of the user in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **tableRowCount** : field "Display table rows" from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **department**: Department of the user in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **timezoneOffset** : user's timezone |
| - | * **personnelNumber** : Personnel number of the user in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **lastModificationTime**: contains the time, when the profile was last edited. |
| - | * **phoneNumber** : Phone number of the user in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **lastModificationUserId**: contains the primary key of the user that last edited the profile. |
| - | * **tableRowCount** : Field "Display table rows" in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **defaultRepresentativeId** : contains the primary key of the user that is lodged as the representative in the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **timezoneOffset** : Timezone of the user in the [[:en:software:tim:userprofil_profile|userprofile]] | + | * **departmentChiefId**: contains the primary key of the user that is lodged as the department chief in the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **clientId** : A number corresponding to the impacted client | + | * **supervisorId** : contains the primary key of the user that is lodged as the supervisor in the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **lastModificationUserId**: User who did the last changes on this [[:en:software:tim:userprofil_profile|userprofile]] | + | * **companyId** : field "Company ID" from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **parentFolderId** : A number corresponding to the virtual directory | + | * **companyName**: field "Company Name" from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **defaultRepresentativeId** : Contains a number that corresponds to the user who is stored as the substitute in the [[:en:software:tim:userprofil_profile|Userprofile]] | + | * **country**: field "Country" from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **supervisorId** :The unique ID of the supervisor assigned to the user[[:en:software:tim:userprofil_profile|Userprofile]] | + | * **isNotifingByMail**: field "Email-Notification preferred" from the [[:en:software:tim:userprofil_profile|userprofil]] or from the [[:en:software:tim:client_profile|clientprofil]] |
| - | * **companyId** : Field "Company ID" of the user from the [[:en:software:tim:userprofil_profile|Userprofile]] | + | * **isNotifingAsignee**: field "Notify asignee if his task is done by somebody else" from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **companyName**: Field "Company Name" of the user from the [[:en:software:tim:userprofil_profile|Userprofile]] | + | * **isIgnoringLDAPAuth**: field "ignore LDAP authentication" from the [[:en:software:tim:userprofil_profile|userprofil]] |
| - | * **country**: Field "country" of the user from the [[:en:software:tim:userprofil_profile|Userprofile]] | + | === view_folder === |
| + | |||
| + | * **id**: The unique identification number used throughout the entire database | ||
| + | * **folderName**: Name of the folder | ||
| + | * **clientId**: A number referencing a specific client | ||
| + | * **creationTime**: Contains the creation time of the folder | ||
| + | * **creationUserId**: A number referencing the creater | ||
| + | * **parentFolderId**: contains a primary key that points to itself and presents a subfolder in the documents | ||
| + | * **isArchiv**: Shows wether the folder is archived | ||
en/software/dashboard/dashboard_tablestructure.1531296097.txt.gz · Last modified: 2021/07/01 09:55 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: 2013 T!M Solutions GmbH
