养老院管理系统数据库设计
养老院管理系统数据库物理模型数据表报告 养老院管理系统数据库设计Sybase PowerDesigner2023-01-13Page 36 of 36I 表清单I.1 表清单名称代码_MigrationHistory_MigrationHistoryAbnormalReminderAbnormalReminderAccountAccountAccount_UserFocusAccount_UserFocusAccountPrivilegeAccountPrivilegeAccountRoleAccountRoleAccountSessionAccountSessionAlarmRecordAlarmRecordAlarmSetUserAlarmSetUserAlarmTemplateAlarmTemplateAreaAreaBedBedBeLeaveBedAnalyBeLeaveBedAnalyBodyPostureDataBodyPostureDataBreathHomeDeviceDataBreathHomeDeviceDataBreathingCountBreathingCountBreathingTrendBreathingTrendCityCityConsultationConsultationCookBookCookBookCookBookDetailCookBookDetailDeviceLocationDeviceLocationDeviceLocationOptionDeviceLocationOptionDrugsManagerDrugsManagerDrugSpecificationsDrugSpecificationsEquipmentEquipmentexamdataexamdatahealth_bloodglucosehealth_bloodglucosehealth_BpRecordhealth_BpRecordhealth_ecgdatahealth_ecgdatahealth_weighthealth_weightHeartCountHeartCountHeartTrendHeartTrendHistory_BeLeaveBedAnalyHistory_BeLeaveBedAnalyHistory_BodyPostureDataHistory_BodyPostureDataHistory_BreathingTrendHistory_BreathingTrendHistory_HeartTrendHistory_HeartTrendHistory_SignDataTrendHistory_SignDataTrendHistory_SleepQualityAnalyHistory_SleepQualityAnalyIntegratedmachineIntegratedmachineLogsManagerLogsManagerMessageHandlingMessageHandlingModuleModuleModulePrivilegeModulePrivilegeOrganizationOrganizationPasthistoryPasthistoryPrivilegePrivilegeProvinceProvinceRoleRoleRolePrivilegeRolePrivilegeShoesShoesSignDataAnalySignDataAnalySignDataTrendSignDataTrendSleepQualityAnalySleepQualityAnalyUserUserUserAttachmentUserAttachmentUserBreathHomeDeviceUserBreathHomeDeviceUserContactUserContactUserCookDetailUserCookDetailUserDeviceReUserDeviceReUserDrugsManagerUserDrugsManagerUserDrugsRecordUserDrugsRecordUserHealthUserHealthUserlocationUserlocationUserLocationAlarmUserLocationAlarmUserLocationRangeUserLocationRangeUserNursingevaluationUserNursingevaluationUserNursingRecordUserNursingRecordUserOtherUserOtherWechatConfigWechatConfigWechatUserWechatUserWechatUserDeviceWechatUserDeviceWechatUserOrganizationWechatUserOrganizationII 表列清单II.1 表 _MigrationHistoryII.1.1 表 <_MigrationHistory> 的列清单代码名称数据类型主要的强制注释MigrationIdMigrationIdnvarchar(150)TRUETRUEContextKeyContextKeynvarchar(300)TRUETRUEModelModelvarbinary(max)FALSETRUEProductVersionProductVersionnvarchar(32)FALSETRUEII.2 表 AbnormalReminderII.2.1 表 <AbnormalReminder> 的列清单代码名称数据类型主要的强制注释ArerIdArerIdintTRUETRUEBedIdBedIdintFALSEFALSEHeartRateLowHeartRateLowfloatFALSEFALSEHeartRateHeightHeartRateHeightfloatFALSEFALSERespiratoryRateLowRespiratoryRateLowfloatFALSEFALSERespiratoryRateHeightRespiratoryRateHeightfloatFALSEFALSELeavedTimeLeavedTimefloatFALSEFALSECreateTimeCreateTimedatetimeFALSEFALSEUpdateTimeUpdateTimedatetimeFALSEFALSEIsUseIsUseintFALSEFALSEReminderStartTimeReminderStartTimefloatFALSEFALSEReminderEndTimeReminderEndTimefloatFALSEFALSEOperatorOperatorvarchar(50)FALSEFALSEDurationDurationfloatFALSEFALSEII.3 表 AccountII.3.1 表 <Account> 的列清单代码名称数据类型主要的强制注释AccIdAccIdintTRUETRUEAccNameAccNamevarchar(30)FALSEFALSEAccCodeAccCodevarchar(20)FALSETRUEPasswordPasswordvarchar(50)FALSETRUECreatetimeCreatetimedatetimeFALSEFALSELastLogtimeLastLogtimedatetimeFALSEFALSEOrganizationIdOrganizationIdintFALSEFALSEIsUseIsUseintFALSEFALSEII.4 表 Account_UserFocusII.4.1 表 <Account_UserFocus> 的列清单代码名称数据类型主要的强制注释UserFocusIdUserFocusIdintTRUETRUEAccountIdAccountIdintFALSEFALSEUserIdUserIdintFALSEFALSEDateTimeDateTimedatetimeFALSEFALSEII.5 表 AccountPrivilegeII.5.1 表 <AccountPrivilege> 的列清单代码名称数据类型主要的强制注释APIdAPIdintTRUETRUEAccIdAccIdintFALSEFALSEAccCodeAccCodevarchar(20)FALSEFALSEMPIdMPIdintFALSEFALSEII.6 表 AccountRoleII.6.1 表 <AccountRole> 的列清单代码名称数据类型主要的强制注释ARIdARIdintTRUETRUEAccIdAccIdintFALSEFALSEAccCodeAccCodevarchar(20)FALSEFALSERoleIdRoleIdintFALSEFALSERoleCodeRoleCodevarchar(20)FALSEFALSEII.7 表 AccountSessionII.7.1 表 <AccountSession> 的列清单代码名称数据类型主要的强制注释IdIdintTRUETRUESessionKeySessionKeyvarcha