Competent Data Model
Last modified by Ondřej Steffl on 2024/07/25 11:56
ActionLog
- actionTypeId (Integer)
- actionUid (String)
- anonymised (Boolean)
- created (Date)
- ctObjectType (CtObjectType)
- description (String)
- id (Integer)
- logData (String)
- objectId (Integer)
- subtypeId (Integer)
- userId (Integer)
ActivityActivitySet
- activityMt (ActivityMt)
- activitySet (ActivitySet)
- created (Date)
- id (Integer)
ActivityActivity
- childActivityMt (ActivityMt)
- created (Date)
- id (Integer)
- parentActivityMt (ActivityMt)
ActivityExtDocument
- activityMt (ActivityMt)
- activityRun (ActivityRun)
- blockRun (BlockRun)
- created (Date)
- document (Document)
- id (Integer)
- publicVisible (Boolean)
- userActivityStateArchived (Boolean)
- userActivityStateArchivedPassed (Boolean)
- userActivityStateCancelled (Boolean)
- userActivityStateChooseRun (Boolean)
- userActivityStateEvaluation (Boolean)
- userActivityStateEvaluationPassed (Boolean)
- userActivityStateFinished (Boolean)
- userActivityStateFinishedExpired (Boolean)
- userActivityStateFinishedExpiredPassed (Boolean)
- userActivityStateFinishedPassed (Boolean)
- userActivityStateFuture (Boolean)
- userActivityStateInterested (Boolean)
- userActivityStateLaunch (Boolean)
- userActivityStateLaunchPassed (Boolean)
- userActivityStateOrdered (Boolean)
- userActivityStateRegistered (Boolean)
- userActivityStateReserved (Boolean)
ActivityMt
- advancedSettings (String)
- afterAcquireValidity (Integer)
- afterDueDateCompletition (Boolean)
- afterDueDateLaunch (Boolean)
- ancestorActivitySet (ActivitySet)
- autoExtensionCount (Integer)
- autoExtensionDays (Integer)
- blockPath (String)
- capacity (Integer)
- contractorMt (ContractorMt)
- created (Date)
- ctActivitySchema (CtActivitySchema)
- ctActivityState (CtActivityState)
- ctActivityType (CtActivityType)
- ctEvaluationType (CtEvaluationType)
- customId (String)
- defaultEvaluator (UserMt)
- description (String)
- externalId (Integer)
- fixedValidity (Date)
- hideAttempts (Boolean)
- id (Integer)
- imageUrl (String)
- interest (Boolean)
- itemOrder (Integer)
- lastUpdated (Date)
- launchContent (String)
- launchTimeLength (Integer)
- launchType (Integer)
- launchUrl (String)
- mandatoryEvaluator (Boolean)
- maxScore (Integer)
- multiActive (Boolean)
- multipleRunAllowed (Boolean)
- name (String)
- nextActivity (ActivityMt)
- numAttempts (Integer)
- orderEnabled (Boolean)
- parentDirs (String)
- parentRegistration (Boolean)
- passScore (Integer)
- periodPreset (String)
- price (Integer)
- rating (Integer)
- ratingCount (Integer)
- ratingPreset (String)
- registration (Boolean)
- reservation (Boolean)
- resultDataTemplate (String)
- review (Boolean)
- selectiveCompletition (Boolean)
- sell (Boolean)
- subtype (Subtype)
- url (String)
- version (String)
- visible (Boolean)
ActivityPt
- activityMt (ActivityMt)
- booleanVal (Boolean)
- dateVal (Date)
- id (Integer)
- longVal (Long)
- paramType (ParamType)
- stringVal (String)
- textVal (String)
ActivityRun
- activityMt (ActivityMt)
- capacity (Integer)
- created (Date)
- ctActivityState (CtActivityState)
- id (Integer)
- multiPhase (Boolean)
- name (String)
- notes (String)
- place (Place)
- price (Integer)
- publishDate (Date)
- registerEnd (Date)
- registerStart (Date)
- runEnd (Date)
- runStart (Date)
ActivitySet
- created (Date)
- ctActivitySetType (CtActivitySetType)
- fullLoaded (Boolean)
- hidden (Boolean)
- id (Integer)
- imageUrl (String)
- itemOrder (Integer)
- name (String)
- parentSet (ActivitySet)
- setPath (String)
AppInfo
- category (String)
- config (String)
- ctParamValueType (CtParamValueType)
- editable (Boolean)
- frontend (Boolean)
- id (Integer)
- paramName (String)
- paramValue (String)
- runnable (Boolean)
BlockRunActivityRun
- activityMt (ActivityMt)
- activityRun (ActivityRun)
- blockRun (BlockRun)
- id (Integer)
BlockRun
- activityBlockMt (ActivityMt)
- capacity (Integer)
- created (Date)
- ctActivityState (CtActivityState)
- id (Integer)
- name (String)
- notes (String)
- place (Place)
- publishDate (Date)
- registerEnd (Date)
- registerStart (Date)
- runEnd (Date)
- runStart (Date)
CtActivityPeriodType
- id (Integer)
- name (String)
CtActivitySchema
- id (Integer)
- name (String)
CtActivitySetType
- id (Integer)
- name (String)
CtActivityState
- id (Integer)
- name (String)
CtActivityType
- id (Integer)
- name (String)
CtDocumentType
- id (Integer)
- name (String)
CtEvaluationType
- id (Integer)
- name (String)
CtLanguage
- englishName (String)
- id (Integer)
- iso (String)
- isoLong (String)
- name (String)
- nativeName (String)
- shortName (String)
CtObjectPermission
- ctObjectType (CtObjectType)
- id (Integer)
- name (String)
- requiredObjectPermission (CtObjectPermission)
CtObjectType
- dbTable (Boolean)
- id (Integer)
- name (String)
CtParamValueType
- id (Integer)
- name (String)
CtTaskType
- id (Integer)
- name (String)
CtTreeObjectType
- id (Integer)
- name (String)
- shortName (String)
CtUserActivityState
- active (Boolean)
- id (Integer)
- name (String)
CtUserPositionState
- active (Boolean)
- id (Integer)
- name (String)
CtUserQualificationState
- active (Boolean)
- id (Integer)
- name (String)
DocumentDocumentSet
- created (Date)
- document (Document)
- documentSet (DocumentSet)
- id (Integer)
DocumentSet
- created (Date)
- description (String)
- id (Integer)
- name (String)
Document
- created (Date)
- ctDocumentType (CtDocumentType)
- description (String)
- docTemplate (Boolean)
- emailTemplate (Boolean)
- extension (String)
- id (Integer)
- lastUpdated (Date)
- name (String)
- originalName (String)
- url (String)
EmailAggregationQueue
- aggregateText (String)
- context (String)
- emailTemplateUsage (EmailTemplateUsage)
- executionTime (Date)
- footerText (String)
- headerText (String)
- htmlContent (Boolean)
- id (Integer)
- recipientEmail (String)
- recipientUserMt (UserMt)
- subject (String)
EmailQueue
- context (String)
- emailBody (String)
- emailSubject (String)
- failed (Boolean)
- hash (String)
- htmlContent (Boolean)
- id (Integer)
- recipientUserEmail (String)
- recipientUserMt (UserMt)
- sent (Boolean)
- sentDate (Date)
EmailTemplateUsage
- activityMt (ActivityMt)
- customTarget (String)
- id (Integer)
- noChildAccess (Boolean)
- notifAggregated (Boolean)
- period (String)
- replaceGlobal (Boolean)
- targetUserTypes (String)
- templateType (EmailTemplate)
- timeTrigger (String)
- triggerId (Integer)
EmailTemplate
- ctLanguage (CtLanguage)
- description (String)
- htmlContent (Boolean)
- id (Integer)
- name (String)
- templateAggregated (Boolean)
- templateFooter (String)
- templateHeader (String)
- templateText (String)
- templateType (String)
LogicalActivitySetConfig
- activitySet (ActivitySet)
- id (Integer)
- logicalExpression (String)
LogicalActivitySetMember
- activitySet (ActivitySet)
- id (Integer)
- logicalActivitySetConfig (LogicalActivitySetConfig)
MessageComment
Message
- assigneeUserMt (UserMt)
- assigneeUsergroupMt (UsergroupMt)
- attachments (String)
- created (Date)
- creatorUserMt (UserMt)
- emailNotification (Boolean)
- id (Integer)
- message (String)
- messageStateId (Integer)
- messageTypeId (Integer)
- subject (String)
- targetActivityMt (ActivityMt)
- targetUaa (UserActivityAccess)
- targetUaat (UserActivityAttempt)
- targetUserMt (UserMt)
- updated (Date)
Notification
- created (Date)
- id (Integer)
- notifString (String)
- parameters (String)
- resolved (Boolean)
- seen (Boolean)
- translate (Boolean)
- userMt (UserMt)
ObjectRoleObjectRole
- childObjectRole (ObjectRole)
- id (Integer)
- parentObjectRole (ObjectRole)
ObjectRolePermission
- ctObjectPermission (CtObjectPermission)
- global (Boolean)
- id (Integer)
- objectRole (ObjectRole)
ObjectRoleTargetObject
- ctObjectType (CtObjectType)
- id (Integer)
- objectRole (ObjectRole)
ObjectRole
- assignable (Boolean)
- autoAddGlobal (Boolean)
- created (Date)
- customId (String)
- global (Boolean)
- globalRole (Boolean)
- id (Integer)
- internal (Boolean)
- name (String)
- noInheritance (Boolean)
- noTreePropagation (Boolean)
ParamType
- config (String)
- ctParamValueType (CtParamValueType)
- dbNullAllowed (Boolean)
- defaultValue (String)
- fieldOrder (Integer)
- hidden (Boolean)
- hint (String)
- humanReadable (String)
- id (Integer)
- mainParam (Boolean)
- maxLength (Integer)
- minLength (Integer)
- mtName (String)
- name (String)
- nonEditable (Boolean)
- nullAllowed (Boolean)
- subtype (Subtype)
- targetFieldName (String)
- targetTable (String)
Place
- address (String)
- city (String)
- created (Date)
- description (String)
- descriptionKey (String)
- floor (String)
- houseNumber (String)
- id (Integer)
- landRegNumber (String)
- listable (Boolean)
- name (String)
- room (String)
- state (String)
- zipCode (String)
PrerequisiteReqDependency
- created (Date)
- id (Integer)
- parentReqDependency (PrerequisiteReqDependency)
- prerequisiteRequirements (PrerequisiteRequirements)
- requiredActivityMt (ActivityMt)
- requiredQualificationMt (QualificationMt)
PrerequisiteRequirements
- activityMt (ActivityMt)
- created (Date)
- description (String)
- hasDescendants (Boolean)
- id (Integer)
- isRelationOr (Boolean)
- name (String)
- parentRequirement (PrerequisiteRequirements)
- prerequisiteRequirements (PrerequisiteRequirements)
- qualificationMt (QualificationMt)
QualificationDocument
- created (Date)
- document (Document)
- id (Integer)
- qualificationMt (QualificationMt)
- userQualificationStateAssigned (Boolean)
- userQualificationStateCanceled (Boolean)
- userQualificationStateCompleted (Boolean)
- userQualificationStateCompletedExpired (Boolean)
- userQualificationStateFailed (Boolean)
QualificationMt
- afterAcquireValidity (Integer)
- contractorMt (ContractorMt)
- created (Date)
- description (String)
- fixedValidity (Date)
- id (Integer)
- name (String)
- requiredExpression (String)
- resultDataTemplate (String)
- resultDataTypeId (Integer)
- subtype (Subtype)
QualificationPt
- booleanVal (Boolean)
- dateVal (Date)
- id (Integer)
- longVal (Long)
- paramType (ParamType)
- qualificationMt (QualificationMt)
- stringVal (String)
- textVal (String)
Subtype
- config (String)
- ctActivityType (CtActivityType)
- ctObjectType (CtObjectType)
- derivedFrom (Subtype)
- id (Integer)
- menuOrder (Integer)
- mtName (String)
- name (String)
Task
- completed (Boolean)
- created (Date)
- ctObjectType (CtObjectType)
- ctTaskType (CtTaskType)
- description (String)
- executionTime (Date)
- failed (Boolean)
- id (Integer)
- objectId (Integer)
- taskData (String)
TimePlace
- activityMt (ActivityMt)
- activityRun (ActivityRun)
- created (Date)
- endTime (Date)
- id (Integer)
- name (String)
- notes (String)
- place (Place)
- startTime (Date)
UserActivityAccess
- accessEnd (Date)
- accessRule (String)
- accessStart (Date)
- active (Boolean)
- activeAttempt (UserActivityAttempt)
- activityMt (ActivityMt)
- activityRun (ActivityRun)
- attemptsLeft (Integer)
- attemptsMax (Integer)
- autoAssigned (Boolean)
- bestAttempt (UserActivityAttempt)
- blockExtensionData (String)
- blockRun (BlockRun)
- blockStateData (String)
- completeUntil (Date)
- created (Date)
- ctActivityPeriodType (CtActivityPeriodType)
- ctUserActivityState (CtUserActivityState)
- deletedCount (Integer)
- evalStartType (Integer)
- evaluator (UserMt)
- extensionCounter (Integer)
- id (Integer)
- mostRecent (Boolean)
- mostRecentNoFuture (Boolean)
- optimalEnd (Date)
- optimalStart (Date)
- originalCompleteUntil (Date)
- parentAccess (UserActivityAccess)
- passed (Boolean)
- passedDate (Date)
- period (String)
- rating (Integer)
- ratingText (String)
- subAccessCount (Integer)
- subAccessPassed (Integer)
- successValidUntil (Date)
- totalTime (Integer)
- userMt (UserMt)
- usergroupActivityAssignment (UsergroupActivityAssignment)
UserActivityAttempt
- attachments (String)
- ctEvaluationType (CtEvaluationType)
- evaluator (UserMt)
- externalId (Integer)
- finished (Date)
- forcedFinish (Boolean)
- id (Integer)
- inEvaluation (Boolean)
- maxScore (String)
- note (String)
- passScore (String)
- passed (Boolean)
- progress (Integer)
- resultData (String)
- resultDataType (String)
- resultDataTypeId (Integer)
- score (String)
- spentTime (Integer)
- started (Date)
- submitted (Date)
- userActivityAccess (UserActivityAccess)
- userActivityAttemptActiveAttempt (UserActivityAccess)
- userActivityAttemptBestAttempt (UserActivityAccess)
UserActivityRunStaff
- activityMt (ActivityMt)
- activityRun (ActivityRun)
- blockRun (BlockRun)
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- timePlace (TimePlace)
- userMt (UserMt)
UserActivitySet
- activitySet (ActivitySet)
- created (Date)
- id (Integer)
- inherited (Boolean)
- objectRole (ObjectRole)
- userMt (UserMt)
- userRoleSubtreeUid (String)
UserActivity
- activityMt (ActivityMt)
- created (Date)
- id (Integer)
- inherited (Boolean)
- objectRole (ObjectRole)
- userMt (UserMt)
- userRoleSubtreeUid (String)
UserContractor
- contractorMt (ContractorMt)
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- userMt (UserMt)
UserExtDocumentExt
- created (Date)
- document (Document)
- documentSet (DocumentSet)
- id (Integer)
- objectRole (ObjectRole)
- userMt (UserMt)
- usergroupMt (UsergroupMt)
UserExtRole
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- userMt (UserMt)
- usergroupMt (UsergroupMt)
UsergroupActivityAssignment
- accessLengthSource (Integer)
- accessStart (Date)
- activityMt (ActivityMt)
- activitySet (ActivitySet)
- blockAssignConfig (String)
- completeUntil (Date)
- created (Date)
- dayCount (Integer)
- disabled (Boolean)
- id (Integer)
- parentUaas (UsergroupActivityAssignment)
- period (String)
- periodSource (Integer)
- resetProgress (Boolean)
- usergroupMt (UsergroupMt)
UsergroupActivitySet
- activitySet (ActivitySet)
- created (Date)
- id (Integer)
- inherited (Boolean)
- objectRole (ObjectRole)
- usergroupMt (UsergroupMt)
- usergroupRoleSubtreeUid (String)
UsergroupActivity
- activityMt (ActivityMt)
- created (Date)
- id (Integer)
- inherited (Boolean)
- objectRole (ObjectRole)
- usergroupMt (UsergroupMt)
- usergroupRoleSubtreeUid (String)
UsergroupContractor
- contractorMt (ContractorMt)
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- usergroupMt (UsergroupMt)
UsergroupMt
- created (Date)
- customId (String)
- description (String)
- id (Integer)
- name (String)
- subtype (Subtype)
UsergroupPosition
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- position (Position)
- usergroupMt (UsergroupMt)
UsergroupPt
- booleanVal (Boolean)
- dateVal (Date)
- id (Integer)
- longVal (Long)
- paramType (ParamType)
- stringVal (String)
- textVal (String)
- usergroupMt (UsergroupMt)
UsergroupQualification
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- qualificationMt (QualificationMt)
- usergroupMt (UsergroupMt)
UsergroupUsergroup
- childUsergroupMt (UsergroupMt)
- created (Date)
- id (Integer)
- parentUsergroupMt (UsergroupMt)
UserMessage
- emailNotification (Boolean)
- id (Integer)
- lastSeenMessageCommentId (Integer)
- message (Message)
- seen (Boolean)
- userMt (UserMt)
UserMt
- birthDate (LocalDate)
- birthNumber (String)
- birthPlace (String)
- contactPlace (Place)
- created (Date)
- ctLanguage (CtLanguage)
- customId (String)
- disabled (Boolean)
- email (String)
- emailVerified (Boolean)
- externalId (Integer)
- firstName (String)
- id (Integer)
- imageUrl (String)
- lastName (String)
- login (String)
- password (String)
- phonePersonal (String)
- phoneWork (String)
- residentPlace (Place)
- salt (String)
- subtype (Subtype)
- superUser (Boolean)
- titleAfter (String)
- titleBefore (String)
- userStatistics (UserStatistics)
UserPt
- booleanVal (Boolean)
- dateVal (Date)
- id (Integer)
- longVal (Long)
- paramType (ParamType)
- stringVal (String)
- textVal (String)
- userMt (UserMt)
UserQualificationAttempt
- acquired (Date)
- created (Date)
- ctUserQualificationState (CtUserQualificationState)
- dueDate (Date)
- evaluator (UserMt)
- id (Integer)
- qualificationMt (QualificationMt)
- resultData (String)
- resultDataTypeId (Integer)
- userMt (UserMt)
- validUntil (Date)
UserQualification
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- qualificationMt (QualificationMt)
- userMt (UserMt)
UserStatistics
- failedActCount (Integer)
- failedBlockCount (Integer)
- failedFbackCount (Integer)
- futureActCount (Integer)
- futureBlockCount (Integer)
- futureFbackCount (Integer)
- id (Integer)
- starCount (Integer)
- successActCount (Integer)
- successBlockCount (Integer)
- successFbackCount (Integer)
- successLateActCount (Integer)
- successLateBlockCount (Integer)
- successLateFbackCount (Integer)
- totalActCount (Integer)
- totalBlockCount (Integer)
- totalFbackCount (Integer)
- totalFbackStudyTime (Integer)
- totalStudyTime (Integer)
UserUsergroup
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- parentUserUsergroup (UserUsergroup)
- userMt (UserMt)
- usergroupMt (UsergroupMt)
UserUser
- childUserMt (UserMt)
- created (Date)
- id (Integer)
- objectRole (ObjectRole)
- parentUserMt (UserMt)
Workflow
- customJsonData (String)
- description (String)
- disabled (Boolean)
- id (Integer)
- permanent (Boolean)
- regularExpression (Boolean)
- standardUri (Boolean)
- triggerAction (String)
- triggerObjectId (String)
- triggerObjectType (String)
- triggerParamName (String)
- triggerUserId (String)
- uriDescriptor (String)
- workflowExecutor (String)