养老院管理系统数据库设计

养老院管理系统数据库物理模型数据表报告养老院管理系统数据库设计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 表的列清单代码名称数据类型主要的强制注释MigrationIdMigrationIdnvarchar(150)TRUETRUEContextKeyContextKeynvarchar(300)TRUETRUEModelModelvarbinary(max)FALSETRUEProductVersionProductVersionnvarchar(32)FALSETRUEII.2 表 AbnormalReminderII.2.1 表的列清单代码名称数据类型主要的强制注释ArerIdArerIdintTRUETRUEBedIdBedIdintFALSEFALSEHeartRateLowHeartRateLowfloatFALSEFALSEHeartRateHeightHeartRateHeightfloatFALSEFALSERespiratoryRateLowRespiratoryRateLowfloatFALSEFALSERespiratoryRateHeightRespiratoryRateHeightfloatFALSEFALSELeavedTimeLeavedTimefloatFALSEFALSECreateTimeCreateTimedatetimeFALSEFALSEUpdateTimeUpdateTimedatetimeFALSEFALSEIsUseIsUseintFALSEFALSEReminderStartTimeReminderStartTimefloatFALSEFALSEReminderEndTimeReminderEndTimefloatFALSEFALSEOperatorOperatorvarchar(50)FALSEFALSEDurationDurationfloatFALSEFALSEII.3 表 AccountII.3.1 表的列清单代码名称数据类型主要的强制注释AccIdAccIdintTRUETRUEAccNameAccNamevarchar(30)FALSEFALSEAccCodeAccCodevarchar(20)FALSETRUEPasswordPasswordvarchar(50)FALSETRUECreatetimeCreatetimedatetimeFALSEFALSELastLogtimeLastLogtimedatetimeFALSEFALSEOrganizationIdOrganizationIdintFALSEFALSEIsUseIsUseintFALSEFALSEII.4 表 Account_UserFocusII.4.1 表的列清单代码名称数据类型主要的强制注释UserFocusIdUserFocusIdintTRUETRUEAccountIdAccountIdintFALSEFALSEUserIdUserIdintFALSEFALSEDateTimeDateTimedatetimeFALSEFALSEII.5 表 AccountPrivilegeII.5.1 表的列清单代码名称数据类型主要的强制注释APIdAPIdintTRUETRUEAccIdAccIdintFALSEFALSEAccCodeAccCodevarchar(20)FALSEFALSEMPIdMPIdintFALSEFALSEII.6 表 AccountRoleII.6.1 表的列清单代码名称数据类型主要的强制注释ARIdARIdintTRUETRUEAccIdAccIdintFALSEFALSEAccCodeAccCodevarchar(20)FALSEFALSERoleIdRoleIdintFALSEFALSERoleCodeRoleCodevarchar(20)FALSEFALSEII.7 表 AccountSessionII.7.1 表的列清单代码名称数据类型主要的强制注释IdIdintTRUETRUESessionKeySessionKeyvarcha

编号：342927850 类型：共享资源大小：109.48KB 格式：DOCX 上传时间：2023-01-18

2
金贝

版权申诉 word格式文档无特别注明外均可编辑修改；预览文档经过压缩，下载后原文更清晰！

关键词：: 养老院管理系统数据库设计

资源描述：: 养老院管理系统数据库物理模型数据表报告养老院管理系统数据库设计 Sybase PowerDesigner 2023-01-13 Page 36 of 36 I 表清单 I.1 表清单名称代码 __MigrationHistory __MigrationHistory AbnormalReminder AbnormalReminder Account Account Account_UserFocus Account_UserFocus AccountPrivilege AccountPrivilege AccountRole AccountRole AccountSession AccountSession AlarmRecord AlarmRecord AlarmSetUser AlarmSetUser AlarmTemplate AlarmTemplate Area Area Bed Bed BeLeaveBedAnaly BeLeaveBedAnaly BodyPostureData BodyPostureData BreathHomeDeviceData BreathHomeDeviceData BreathingCount BreathingCount BreathingTrend BreathingTrend City City Consultation Consultation CookBook CookBook CookBookDetail CookBookDetail DeviceLocation DeviceLocation DeviceLocationOption DeviceLocationOption DrugsManager DrugsManager DrugSpecifications DrugSpecifications Equipment Equipment examdata examdata health_bloodglucose health_bloodglucose health_BpRecord health_BpRecord health_ecgdata health_ecgdata health_weight health_weight HeartCount HeartCount HeartTrend HeartTrend History_BeLeaveBedAnaly History_BeLeaveBedAnaly History_BodyPostureData History_BodyPostureData History_BreathingTrend History_BreathingTrend History_HeartTrend History_HeartTrend History_SignDataTrend History_SignDataTrend History_SleepQualityAnaly History_SleepQualityAnaly Integratedmachine Integratedmachine LogsManager LogsManager MessageHandling MessageHandling Module Module ModulePrivilege ModulePrivilege Organization Organization Pasthistory Pasthistory Privilege Privilege Province Province Role Role RolePrivilege RolePrivilege Shoes Shoes SignDataAnaly SignDataAnaly SignDataTrend SignDataTrend SleepQualityAnaly SleepQualityAnaly User User UserAttachment UserAttachment UserBreathHomeDevice UserBreathHomeDevice UserContact UserContact UserCookDetail UserCookDetail UserDeviceRe UserDeviceRe UserDrugsManager UserDrugsManager UserDrugsRecord UserDrugsRecord UserHealth UserHealth Userlocation Userlocation UserLocationAlarm UserLocationAlarm UserLocationRange UserLocationRange UserNursingevaluation UserNursingevaluation UserNursingRecord UserNursingRecord UserOther UserOther WechatConfig WechatConfig WechatUser WechatUser WechatUserDevice WechatUserDevice WechatUserOrganization WechatUserOrganization II 表列清单 II.1 表 __MigrationHistory II.1.1 表 <__MigrationHistory> 的列清单代码名称数据类型主要的强制注释 MigrationId MigrationId nvarchar(150) TRUE TRUE ContextKey ContextKey nvarchar(300) TRUE TRUE Model Model varbinary(max) FALSE TRUE ProductVersion ProductVersion nvarchar(32) FALSE TRUE II.2 表 AbnormalReminder II.2.1 表的列清单代码名称数据类型主要的强制注释 ArerId ArerId int TRUE TRUE BedId BedId int FALSE FALSE HeartRateLow HeartRateLow float FALSE FALSE HeartRateHeight HeartRateHeight float FALSE FALSE RespiratoryRateLow RespiratoryRateLow float FALSE FALSE RespiratoryRateHeight RespiratoryRateHeight float FALSE FALSE LeavedTime LeavedTime float FALSE FALSE CreateTime CreateTime datetime FALSE FALSE UpdateTime UpdateTime datetime FALSE FALSE IsUse IsUse int FALSE FALSE ReminderStartTime ReminderStartTime float FALSE FALSE ReminderEndTime ReminderEndTime float FALSE FALSE Operator Operator varchar(50) FALSE FALSE Duration Duration float FALSE FALSE II.3 表 Account II.3.1 表的列清单代码名称数据类型主要的强制注释 AccId AccId int TRUE TRUE AccName AccName varchar(30) FALSE FALSE AccCode AccCode varchar(20) FALSE TRUE Password Password varchar(50) FALSE TRUE Createtime Createtime datetime FALSE FALSE LastLogtime LastLogtime datetime FALSE FALSE OrganizationId OrganizationId int FALSE FALSE IsUse IsUse int FALSE FALSE II.4 表 Account_UserFocus II.4.1 表的列清单代码名称数据类型主要的强制注释 UserFocusId UserFocusId int TRUE TRUE AccountId AccountId int FALSE FALSE UserId UserId int FALSE FALSE DateTime DateTime datetime FALSE FALSE II.5 表 AccountPrivilege II.5.1 表的列清单代码名称数据类型主要的强制注释 APId APId int TRUE TRUE AccId AccId int FALSE FALSE AccCode AccCode varchar(20) FALSE FALSE MPId MPId int FALSE FALSE II.6 表 AccountRole II.6.1 表的列清单代码名称数据类型主要的强制注释 ARId ARId int TRUE TRUE AccId AccId int FALSE FALSE AccCode AccCode varchar(20) FALSE FALSE RoleId RoleId int FALSE FALSE RoleCode RoleCode varchar(20) FALSE FALSE II.7 表 AccountSession II.7.1 表的列清单代码名称数据类型主要的强制注释 Id Id int TRUE TRUE SessionKey SessionKey varcha

展开阅读全文