Stop Smoking Services

The Smokers table contains detailed information about the patients. It includes the smoker’s Name, Height, Weight, and Date of Birth, along with their Initial Diagnosis and any Other Details. This table serves as the foundation for patient profiles, tracking personal data and medical history necessary for developing tailored treatment plans.

The Patient Symptoms table records each smoker's symptoms and assessments. It tracks the Symptom Name, Date of Assessment, and the staff member who conducted the evaluation. The Value field is used to quantify the severity or presence of a symptom. This data allows healthcare professionals to assess the smoker's condition over time and adjust treatments accordingly.

The Patient Treatments table documents the treatments prescribed to smokers. It includes fields like Treatment Name, Date of Treatment, and Other Details, providing a clear history of the interventions each patient has undergone. This helps in managing and adjusting treatment plans to meet individual patient needs and track their effectiveness.

The Overall Diagnoses table holds possible diagnoses that could be relevant to the smoker's health. It stores the Diagnosis Name, a brief Description, and the Probability of each diagnosis. This table helps practitioners evaluate the likelihood of various diagnoses, contributing to more accurate patient assessments.

The Diagnosis of Symptoms table links specific symptoms to diagnoses, detailing the Diagnosis Name, Symptom Name, and the Min and Max Value that help define the symptom’s relationship with the diagnosis. The Probability field shows how likely a diagnosis is given the symptoms, supporting the medical team in making informed decisions.

The Symptoms table catalogs potential symptoms smokers may experience. It includes fields such as Name and Description, serving as a reference for patient assessments and making it easier to track common or unique symptoms across multiple patients.

The Treatments table lists all possible treatments offered in the program. This table contains fields like Name and Description, providing a resource for practitioners to choose from when prescribing patient care plans and tracking which treatments have been most effective.

The Staff table records the medical professionals involved in the smoking cessation program. It includes their Name, Title, Contact Information, and other personal details. This table helps manage staff assignments and ensures that each patient is treated by a qualified healthcare professional, keeping a clear record of which staff members are responsible for patient care.

Overall, this database supports the coordination and management of a stop-smoking program by ensuring that key patient information, symptoms, treatments, and staff details are easily accessible and organized for efficient healthcare delivery.