Please enable JavaScript.
Coggle requires JavaScript to display documents.
HW databases (healthWatch (Department ([ :1234:] :key:DepartmentID, [ …
HW databases
healthWatch
UserProjectRoundUserAnswer
🔑 UserProjectRoundUserAnswerID
ProjectRoundUserID
AnswerKey
DT
UserProfileID
AnswerID
UserProfile
🔑 UserProfileID
UserID
SponsorID
DepartmentID
ProfileComparisonID
Created
AdminNews
[🔢] :key: AdminNewsID
[:calendar::clock2:] :hole: DT
[ :heavy_plus_sign::scroll:] :hole: News
Affiliate
[:1234:] :key: AffiliateID
[ :scroll:64] :hole: Affiliate
Agreement
[:1234:] :key: AgreementID
[:calendar::clock2:] :hole: EffectivityDate
[ :scroll:255] :hole: Name
[ :1234:] :hole: AgreementContentID
[ :1234:] :hole: Type
AgreementContent
[ :1234:] :key: AgreementContentID
[ :scroll:255] :hole:Name
AgreementContentLang
[ :1234:] :key: AgreementContentLangID
[ :book:] :hole: AgreementText
[ :scroll:255] :hole: Name
[ :1234:] :hole:AgreementContentID
[ :1234:] :hole: LangID
AgreementLang
[ :1234:] :key: AgreementLangID
[ :1234:] :hole: AgreementID
[ :scroll:255] :hole: Name
[ :1234:] :hole:LangID
BA
[ :1234:] :key:BAID
[ :1234:] :hole:BQID
[ :scroll:255] :hole:Internal
[ :1234:] :hole:SortOrder
[ :1234:] :hole:Value
BALang
[ :1234:] :key:BALangID
[ :1234:] :hole:BAID
[ :1234:] :hole: LangID
[ :scroll:255] :hole:BA
BQLang
[ :1234:] :key:BALangID
[ :1234:] :hole:BAID
[ :1234:] :hole:LangID
[ :scroll:255] :hole:BA
BQ
[ :1234:] :key:BQID
[ :1234:] :hole:Type
[ :1234:] :hole:ReqLength
[ :1234:] :hole:MaxLength
[ :1234:] :hole: Comparison
[ :1234:] :hole:Layout
[ :1234:] :hole:Restricted
[ :1234:] :hole:IncludeInDemographics
[ :scroll:255] :hole:Internal
[ :scroll:64] :hole:DefaultVal
[ :scroll:16] :hole:MeasurementUnit
[ :scroll:16] :hole:Variable
[ :heavy_plus_sign::scroll:64] :hole:InternalAggregate
BQVisibility
[ :1234:] :key:BQvisibilityID
[ :1234:] :hole: ChildBQID
[ :1234:] :hole: BQID
[ :1234:] :hole: BAID
CX
[ :1234:] :hole: :key:CXID
Department
[ :1234:] :key:DepartmentID
[ :1234:] :hole:SponsorID
[ :1234:] :hole:ParentDepartmentID
[ :1234:] :hole:SortOrder
[ :1234:] :hole:PreviewExtendedSurveys
[ :1234:] :hole:MinUserCountToDisclose
[ :1234:] :hole:LoginDays
[ :1234:] :hole:LoginWeekday
[ :scroll:255] :hole:Department
[ :scroll:64] :hole:DepartmentShort
[ :scroll:16] :hole:DepartmentAnonymized
[ :heavy_plus_sign::scroll:255] :hole:SortString
[ :id:] :hole:DepartmentKey
[ :1234:] :hole: 🖩 SortStringLength
Diary
[ :1234:] :key: DiaryID
[ :book:] :hole:DiaryNote
[ :heavy_minus_sign: :calendar: :clock2:] :hole:DiaryDate
[ :1234:] :hole: UserID
[ :1234:] :hole: Mood
[ :heavy_minus_sign: :calendar: :clock2:] :hole:CreatedDT
[ :heavy_minus_sign: :calendar: :clock2:] :hole:DeletedDT
Exercise
[ :1234:] :key: ExerciseID
[ :1234:] :hole:ExerciseSortOrder
[ :1234:] :hole:ExerciseAreaID
[ :1234:] :hole:RequiredUserLevel
[ :1234:] :hole:ExerciseCategoryID
[ :1234:] :hole:PrintOnBottom
[ :1234:] :hole:Status
[ :1234:] :hole:Minutes
[ :scroll:255] :hole:ExerciseImg
[ :book:] :hole: Script
ExerciseArea
[ :1234:] :hole: ExerciseAreaSortOrder
[ :scroll:255] :hole: ExerciseAreaImg
[ :1234:] :key: ExerciseAreaID
ExerciseAreaLang
[ :1234:] :key:ExerciseAreaLangID
[ :1234:] :hole: ExerciseAreaID
[ :1234:] :hole: Lang
[ :scroll:255] :hole:ExerciseArea
ExerciseCategory
[ :1234:] :key:ExerciseCategoryID
[ :1234:] :hole: ExerciseCategorySortOrder
ExerciseCategoryLang
[ :1234:] :hole: ExerciseCategoryID
[ :1234:] :hole: Lang
[ :1234:] :key: ExerciseCategoryLangID
[ :scroll:255] :hole: ExerciseCategory
ExerciseMiracle (PRESUMED OBSOLETE)
[ :1234:] :key: ExerciseMiracleID
ExerciseStats
[ :1234:] :key: ExerciseStatsID
[ :1234:] :hole:UserID
[ :1234:] :hole:UserProfileID
[ :1234:] :hole:ExerciseVariantLangID
[ :heavy_minus_sign::calendar::clock2:] :hole: DateTime
ExerciseType
[ :1234:] :key:ExerciseTypeID
[ :1234:] :hole: ExerciseTypeSortOrder
ExerciseTypeLang
[ :1234:] :key:ExerciseTypeLangID
[ :1234:] :hole:ExerciseTypeID
[ :scroll:64] :hole:ExerciseType
[ :scroll:64] :hole:ExerciseSubType
[ :1234:] :hole: Lang
ExerciseVariant
[:1234:] 🔑 ExerciseVariantID
[ :1234:] :hole: ExerciseTypeID
[ :1234:] :hole: ExerciseID
ExerciseVariantLang
[ :1234:] :key: ExerciseVariantLangID
[ :1234:] :hole: ExerciseVariantID
[ :1234:] :hole:Lang
[ :1234:] :hole: ExerciseFileSize
[ :1234:] :hole: ExerciseWindowX
[ :1234:] :hole:ExerciseWindowY
[ :book:] :hole: ExerciseContent
[ :scroll:255] :hole: ExerciseFile
Legend
🔑Key value
❄️Unique
Data types
📅🕑 Datetime
🔢 int
📜255 = varchar(255)
:heavy_plus_sign::scroll:255 = nvchar(255)
:book: text
🆔Uniqueidentifier
:heavy_minus_sign: 📅🕑 smalldatetime
🕳️Nullable
🖩Calculated
eform
Answer
🔑🔢 AnswerID
ProjectRoundID
ProjectRoundUnitID
ProjectRoundUserID
StartDT
EndDT
AnswerKey
ExtendedFirst
CurrentPage
FeedbackAlert
AnswerValue
🔑AnswerValue
AnswerID
QuestionID
OptionID
ValueInt
ValueDecimal
ValueDateTime
CreatedDateTime
CreatedSessionID
DeletedSessionID
ValueText
ValueTextJapaneseUnicode