Data Model

Jump to bottom

Dan Lebrero edited this page Jan 20, 2020 · 2 revisions

Basic Data Model

Common fields

BaseDomain common fields

Key key
Date createdDateTime
Date lastUpdateDateTime
Long lastUpdateUserId
Long createUserId

Survey Data model

domain model

SurveyGroup

String name = null
String code = null
String description = null

Survey

String code = null
String name = null
String desc = null
Status status = null
Double version = null
String path = null
Long surveyGroupId
String pointType
String defaultLanguageCode
Boolean requireApproval = false

QuestionGroup

String name = null
String desc = null
String code = null
String path = null
Long surveyId
Integer order

Question

Type type = null
String tip = null
String text = null
Boolean dependentFlag = null
Boolean allowMultipleFlag = null
Boolean allowOtherFlag = null
Boolean Collapseable = false
Boolean immutable = false
Long dependentQuestionId
String dependentQuestionAnswer
Long questionGroupId
Long surveyId
Integer order = null
Boolean mandatoryFlag = null
String path = null
String referenceId
Boolean allowDecimal
Boolean allowSign
Double minVal
Double maxVal
Boolean isName

QuestionOption

String code = null
String text
Long questionId
Integer order

QuestionHelpMedia

String resourceUrl = null
Type type = null
String text = null
Long QuestionId

Survey Instance Data model

domain model

Device data model

domain model

Device

DeviceType deviceType
String phoneNumber
String esn
String EMEI -- currently does not exist yet
String deviceIdentifier
Date inServiceDate
Date ourServiceDate
Date lastUpdate
String osVersion
String gallatinSoftwareManifest
Double lastKnowLat
Double lastKnowLon
Double lastKnownAccuracy
Date lastLocationBeaconTime
String deviceGroup
String deviceGroupId -- currently does not exist yet

DeviceGroup -- currently does not exist yet

String name = null
String code = null
String description = null

Admin data model

domain model

Editorial data model

domain model

Metric data model

domain model