Tables


SchemaSpy Analysis of RMS_v22_02

Generated on Tue Nov 22 15:39 GMT 2022

XML Representation
Insertion Order Deletion Order
TABLES 199
VIEWS 10
COLUMNS 961
Constraints 245
Anomalies 33
Routines 0

Database Properties

Database Type: Microsoft SQL Server - 13.00.7016

Tables

Table / View Children Parents Columns Type Comments
SystemAudit 0 2 6 Table
BloodTestResults 2 4 7 Table
ResultOperators 3 0 2 Table
TimelineEventStartDateTypes 1 0 3 Table
LibraryFiles 4 1 7 Table
ModifiedDukes 1 0 3 Table
InvestigationTypes 4 0 3 Table
SNOMEDMorphologies 1 0 4 Table
SNOMEDICD10Link 0 2 5 Table
CNSs 3 0 4 Table
CNSIndicationCodes 1 0 4 Table
AlertTypes 1 0 3 Table
GynaecologyReferrals 0 1 1 Table
InvestigationActivityTemplateSchedule 0 2 2 Table
ManualTimeLines 0 1 6 Table
_Deprecated_21_01_CEAThresholdLevels 0 1 7 Table
BloodTestUnitAssociations 0 2 3 Table
PatientNotificationEmails 0 0 3 Table
ThyroidStaging 0 1 1 Table
ICD10 2 1 5 Table
ActivityScheduleClosedReasons 1 0 2 Table
TNMGroupings 1 0 2 Table
AlertMessages 2 1 7 Table
AnatomicalSides 1 0 3 Table
MDTDiscussionActivityTemplateSchedule 0 1 1 Table
_Deprecated_21_01_LabTestPanelAssociations 0 2 2 Table
BloodTestRangeTypeDefinitions 0 2 4 Table
DiagnosisMets 0 4 6 Table
Patients 3 7 32 Table
AuditRecords 0 3 7 Table
MDTDiscussionActivitySchedule 0 1 1 Table
BreastInvestigationResults 0 11 12 Table
Severities 1 0 3 Table
ColorectalStaging 1 2 3 Table
DocumentExportMessages 0 4 10 Table
BloodTestRanges 0 3 10 Table
BreastSides 1 0 2 Table
ReviewContactTypes 1 0 2 Table
LibraryResource 0 1 1 Table
AlertStatus 1 0 3 Table
AspNetRoles 1 0 2 Table
DocumentExportMessageStatusTypes 1 0 3 Table
LungReferrals 0 1 1 Table
MessageTypes 0 0 3 Table
BreastSites 1 0 2 Table
TNM_T_Letter 3 0 2 Table
UserAdminAuditActions 1 0 3 Table
PortalMessages 0 3 13 Table
SystemAreas 1 0 3 Table
Ethnicities 1 0 3 Table
_Deprecated_21_01_LabTests 2 1 5 Table
ProstateReferrals 1 1 1 Table
UnitOfMeasurements 5 0 3 Table
DemographicInterfaceMessages 2 2 13 Table
GPs 3 0 5 Table
PracticeGPAssociations 0 2 2 Table
ReviewContacts 0 2 7 Table
CancerSites 9 0 3 Table
AlertSettings 2 1 10 Table
BreastReferrals 0 1 1 Table
MonitoringStatusChangedReasons 1 0 3 Table
Titles 1 0 2 Table
GleasonTertiaryScores 1 0 2 Table
MetsTypes 1 0 2 Table
DisRadiologyLinkage 0 0 6 Table
MetsCertainties 1 0 2 Table
TNMEditions 3 0 2 Table
ReviewInvestigationTypes 0 2 2 Table
InvestigationOutcomes 1 0 2 Table
RecordTypes 2 0 3 Table
PortalMessageTypes 1 0 3 Table
Referrals 27 4 11 Table
UserJobRoles 1 0 3 Table
ReferenceDataAudit 0 1 6 Table
PortalTriggerSources 1 0 3 Table
BloodTestPanelAssociations 0 2 2 Table
BasisOfDiagnosis 1 0 2 Table
UserAdminAudit 0 1 5 Table
ActivityScheduleStartDateTypes 0 0 3 Table
AuditActions 2 0 3 Table
BreastSwitchChangeReasonTypes 1 0 3 Table
Tests 0 1 5 Table
LibraryTemplatePlaceholders 0 0 3 Table
ActivitySchedule 6 6 15 Table
Notes 0 1 6 Table
ColorectalReferrals 1 1 1 Table
SNOMEDDiagnosis 2 0 4 Table
AspNetUserLogins 0 1 3 Table
ActivityScheduleStatusTypes 1 0 3 Table
ReviewOutcomes 1 0 2 Table
DemographicInterfaceMessageAmendments 0 2 4 Table
TumourStatus 1 0 3 Table
BloodTestPanels 2 0 3 Table
MetsLocations 1 0 2 Table
Activities 3 2 5 Table
ActivityTemplateSchedule 5 3 9 Table
AspNetUsers 6 2 20 Table
HaematologyReferrals 0 1 1 Table
TNMVersions 3 0 2 Table
DisRadiologyImport 1 0 23 Table
_Deprecated_21_01_TumourMarkerResultsDefined 0 3 3 Table
_Deprecated_20_03_PatientPreferredContact 2 1 9 Table
DisOscopyImport 0 0 19 Table
AmendmentFields 1 0 3 Table
ReferenceDataBackup 0 0 6 Table
ViewAuditRecords 0 2 6 Table
HNAActivityTemplateSchedule 0 1 1 Table
MenopausalStatus 1 0 2 Table
SNOMED_CT 1 0 5 Table
__MigrationHistory 0 0 4 Table
ClinicalReviewActivityTemplateSchedule 0 1 1 Table
ReferralMonitoringStatus 0 3 8 Table
AspNetUserClaims 0 1 4 Table
MessageStatus 1 0 3 Table
PortalRegistrationAuditRecords 0 1 5 Table
BreastSwitchActivitySchedule 0 1 1 Table
UpperGIReferrals 0 1 1 Table
_Deprecated_21_01_TumourMarkerResultsOther 0 1 3 Table
TesticularReferrals 0 1 1 Table
BloodTestResultOther 0 1 3 Table
GradesOfDifferentiation 1 0 3 Table
ResultOutcomes 3 0 2 Table
ReviewOutcomeRecipients 0 2 2 Table
ColorectalSynchronousTumourSites 0 2 2 Table
ICD10Group 2 0 4 Table
LibraryTemplate 0 1 1 Table
TNM_M_Letter 3 0 2 Table
_Deprecated_21_01_TumourMarkerResults 2 3 6 Table
HNAActivitySchedule 0 1 1 Table
AssessedByHCPs 0 0 3 Table
BreastSwitchActivityTemplateSchedule 0 1 1 Table
CCGs 1 0 2 Table
TNM_N_Value 3 0 2 Table
UserPermissions 0 4 5 Table
AlertEventMessages 0 2 2 Table
DisRadiologyTestResults 1 1 9 Table
TNM_T_Value 3 0 2 Table
SkinReferrals 0 1 1 Table
Organisations 6 0 4 Table
UserPermissionSections 1 0 3 Table
TNM_M_Value 3 0 2 Table
Practices 2 0 9 Table
Consultants 3 1 7 Table
MonitoringStatus 1 0 3 Table
_Deprecated_21_01_LabTestResultOther 0 1 3 Table
DateComparisons 1 0 3 Table
PortalMessageStatuses 1 0 3 Table
UserPermissionLevels 1 0 3 Table
CancerSubSites 1 1 4 Table
NhsNumberStatus 1 0 3 Table
TumourGrades 1 0 3 Table
AlertMethods 1 0 3 Table
BreastStaging 0 5 6 Table
CancerSiteSettings 0 3 5 Table
Reviews 3 5 11 Table
ClinicalReviewActivitySchedule 0 1 1 Table
Diagnosis 2 13 17 Table
ConsultantTitles 1 0 3 Table
TesticularStaging 0 1 1 Table
LymphNodeScores 1 0 3 Table
Staging 5 11 14 Table
Alerts 3 5 7 Table
DemographicInterfaceMessageErrors 0 2 4 Table
AlertEventStatus 1 0 3 Table
AlertRecipients 1 0 3 Table
Genders 1 0 3 Table
OutcomeRecipients 1 0 3 Table
_Deprecated_21_01_LabTestResults 2 4 7 Table
PatientNotificationSMS 1 0 3 Table
InvestigationReviewStatuses 0 1 5 Table
DisOscopyLinkage 0 0 6 Table
SynchronousTumourSites 1 0 2 Table
BACKUP_20_2_TumourMarkers 0 0 6 Table
_Deprecated_21_01_LabTestResultDefined 0 2 3 Table
ProstateStaging 0 2 3 Table
Lateralities 1 0 3 Table
DocumentActions 0 2 7 Table
_Deprecated_21_01_TumourMarkers 1 2 5 Table
AlertErrors 0 4 8 Table
AlertEvents 2 4 7 Table
BreastSwitches 0 7 13 Table
AnatomicalSites 3 0 3 Table
TNM_N_Letter 3 0 2 Table
Investigations 5 17 31 Table
PracticeCCGMappings 0 1 2 Table
ThyroidReferrals 0 1 1 Table
BloodTestResultDefined 0 3 3 Table
_Deprecated_21_01_LabTestPanels 2 0 3 Table
InvestigationTypeModalityMapping 0 0 2 Table
InvestigationActivitySchedule 0 2 2 Table
UrologyReferrals 0 1 1 Table
ActivityStatusTypes 1 0 3 Table
ActivityTimeSpanTypes 4 0 3 Table
NPIPrognosis 1 0 2 Table
ActivityTemplates 2 1 4 Table
HeadAndNeckReferrals 0 1 1 Table
_Deprecated_21_01_PSAThresholdLevels 0 1 7 Table
BloodTests 6 0 4 Table
AspNetUserRoles 0 2 2 Table
eImport_Audit_AssociatedData 0 0 6 View
MergedActivitySchedules 0 0 7 View
BloodTestRanges_NotDeleted 0 0 10 View
CurrentReferralMonitoringStatus 0 0 3 View
ReferralMonitoringStatus_NotDeleted 0 0 7 View
Alerts_RelevantReferrals 0 1 3 View
CurrentInvestigationReviewStatuses 0 0 2 View
BloodTestAndRelevantRange 0 1 26 View
Investigations_NotDeleted_BTARR 0 0 4 View
BloodTestUnits 0 0 3 View