CREATE TABLE DoctorPatientInterview (
InterviewId INT IDENTITY(1,1) PRIMARY KEY,
DoctorQuestion NVARCHAR(500),
PatientResponse NVARCHAR(500),
DoctorReply NVARCHAR(500)
);
-- Sample Inserts (first 10 shown)
INSERT INTO DoctorPatientInterview (DoctorQuestion, PatientResponse, DoctorReply) VALUES
('How are you feeling today?', 'I’ve been feeling dizzy.', 'Let’s check your blood pressure.'),
('Have you had any pain recently?', 'Yes, in my lower back.', 'I’ll schedule a scan to investigate.'),
('How’s your sleep been?', 'I wake up several times a night.', 'We may need to review your sleep hygiene and apnea treatment.'),
('Are you taking your medications regularly?', 'I missed a few doses last week.', 'Let’s talk about reminders or simplifying your schedule.'),
('Any changes in appetite?', 'I’ve lost interest in food.', 'That could be linked to mood — let’s explore further.'),
('Have you experienced any swelling?', 'Yes, in my left leg.', 'We’ll check for fluid retention or clot risk.'),
('How’s your mood lately?', 'I feel low and unmotivated.', 'Let’s track your mood daily and consider support options.'),
('Do you feel safe at home?', 'Yes, but I’m very isolated.', 'Let’s connect you with community support.'),
('Any recent falls or fainting?', 'I fainted yesterday morning.', 'We’ll monitor your blood pressure and hydration closely.'),
('Are you managing your diabetes well?', 'My sugar levels have been erratic.', 'We’ll adjust your diet log and medication timing.');
CREATE TABLE DoctorPatientInterview (
InterviewId INT IDENTITY(1,1) PRIMARY KEY,
DoctorQuestion NVARCHAR(500),
PatientResponse NVARCHAR(500),
DoctorReply NVARCHAR(500)
);
-- Insert 101 rows
INSERT INTO DoctorPatientInterview (DoctorQuestion, PatientResponse, DoctorReply) VALUES
('How are you feeling today?', 'I’ve been feeling dizzy.', 'Let’s check your blood pressure.'),
('Have you had any pain recently?', 'Yes, in my lower back.', 'I’ll schedule a scan to investigate.'),
('How’s your sleep been?', 'I wake up several times a night.', 'We may need to review your sleep hygiene and apnea treatment.'),
('Are you taking your medications regularly?', 'I missed a few doses last week.', 'Let’s talk about reminders or simplifying your schedule.'),
('Any changes in appetite?', 'I’ve lost interest in food.', 'That could be linked to mood — let’s explore further.'),
('Have you experienced any swelling?', 'Yes, in my left leg.', 'We’ll check for fluid retention or clot risk.'),
('How’s your mood lately?', 'I feel low and unmotivated.', 'Let’s track your mood daily and consider support options.'),
('Do you feel safe at home?', 'Yes, but I’m very isolated.', 'Let’s connect you with community support.'),
('Any recent falls or fainting?', 'I fainted yesterday morning.', 'We’ll monitor your blood pressure and hydration closely.'),
('Are you managing your diabetes well?', 'My sugar levels have been erratic.', 'We’ll adjust your diet log and medication timing.'),
-- Rows 11 to 101 continue below
('Have you noticed any changes in vision?', 'Things look blurry sometimes.', 'We’ll schedule an eye exam.'),
('Do you have any allergies?', 'I’m allergic to penicillin.', 'We’ll note that in your chart and avoid prescribing it.'),
('How often do you exercise?', 'Rarely, I feel too tired.', 'Let’s start with light stretching and build up.'),
('Are you experiencing any chest pain?', 'Only when I climb stairs.', 'We’ll do an ECG and check your heart health.'),
('Do you smoke?', 'Yes, about 10 cigarettes a day.', 'Let’s discuss a quit plan and support options.'),
('Do you drink alcohol?', 'Only on weekends.', 'We’ll monitor liver function and discuss moderation.'),
('Have you had any recent infections?', 'I had a UTI last month.', 'Let’s check if it fully cleared.'),
('Are you feeling anxious?', 'Yes, especially in crowds.', 'We can explore therapy or medication options.'),
('Do you have trouble concentrating?', 'Yes, my mind feels foggy.', 'We’ll assess for cognitive fatigue or depression.'),
('Any changes in bowel habits?', 'I’ve been constipated.', 'We’ll adjust your diet and consider a mild laxative.'),
('Do you have regular headaches?', 'Yes, almost daily.', 'We’ll track triggers and consider a neurologist referral.'),
('Are you experiencing shortness of breath?', 'Yes, when I walk.', 'We’ll check your lungs and oxygen levels.'),
('Do you have a support system?', 'Just my support worker.', 'Let’s explore community groups or peer support.'),
('Have you had any recent hospital visits?', 'I was admitted for dehydration.', 'We’ll review your fluid intake and recovery.'),
('Do you feel rested when you wake up?', 'No, I feel exhausted.', 'We’ll review your sleep apnea treatment.'),
('Are you experiencing joint pain?', 'Yes, in my knees.', 'We’ll assess for arthritis or inflammation.'),
('Do you have any skin issues?', 'I have a rash on my arm.', 'We’ll examine it and consider a dermatology referral.'),
('Have you had any weight changes?', 'I lost 5kg in two weeks.', 'We’ll investigate possible causes.'),
('Do you feel safe walking alone?', 'Not really.', 'We’ll assess your mobility and fall risk.'),
('Are you experiencing numbness?', 'Yes, in my fingers.', 'We’ll check for nerve compression or diabetes effects.'),
('Do you have regular meals?', 'I skip breakfast often.', 'Let’s build a simple meal plan.'),
('Are you feeling hopeful?', 'Not lately.', 'We’ll talk about mental health support.'),
('Do you have any hearing issues?', 'I struggle in noisy places.', 'We’ll schedule a hearing test.'),
('Are you experiencing nausea?', 'Yes, especially in the morning.', 'We’ll check for digestive or hormonal causes.'),
('Do you have a fever?', 'I felt hot last night.', 'We’ll take your temperature and run tests.'),
('Are you experiencing palpitations?', 'Yes, my heart races sometimes.', 'We’ll do a Holter monitor test.'),
('Do you have trouble swallowing?', 'Yes, with solid food.', 'We’ll refer you for a swallowing study.'),
('Are you experiencing fatigue?', 'All the time.', 'We’ll check for anemia and thyroid issues.'),
('Do you have any dental pain?', 'Yes, my molar hurts.', 'We’ll refer you to a dentist.'),
('Are you experiencing back pain?', 'Yes, especially when sitting.', 'We’ll assess posture and spine alignment.'),
('Do you have any urinary issues?', 'I go frequently at night.', 'We’ll check for prostate or bladder concerns.'),
('Are you experiencing muscle cramps?', 'Yes, in my calves.', 'We’ll check electrolytes and hydration.'),
('Do you have any memory issues?', 'I forget things often.', 'We’ll do a cognitive screening.'),
('Are you experiencing dizziness?', 'Yes, when I stand up.', 'We’ll check for orthostatic hypotension.'),
('Do you have any tingling sensations?', 'Yes, in my feet.', 'We’ll assess for neuropathy.'),
('Are you experiencing bloating?', 'Yes, after meals.', 'We’ll review your diet and digestion.'),
('Do you have any difficulty breathing at night?', 'Yes, I wake up gasping.', 'We’ll review your CPAP settings.'),
('Are you experiencing sadness?', 'Yes, most days.', 'We’ll explore therapy and medication options.'),
('Do you have any chest tightness?', 'Yes, when stressed.', 'We’ll assess for anxiety or cardiac causes.'),
('Are you experiencing lightheadedness?', 'Yes, especially in the morning.', 'We’ll monitor your blood pressure.'),
('Do you have any trouble walking?', 'Yes, I feel unstable.', 'We’ll assess gait and balance.'),
('Are you experiencing itching?', 'Yes, on my arms.', 'We’ll check for allergies or skin conditions.'),
('Do you have any trouble focusing?', 'Yes, I get distracted easily.', 'We’ll explore ADHD or mood-related causes.'),
('Are you experiencing swelling in your feet?', 'Yes, every evening.', 'We’ll check for heart or kidney issues.'),
('Do you have any trouble speaking?', 'Yes, I slur words sometimes.', 'We’ll assess for neurological causes.'),
('Are you experiencing chest discomfort?', 'Yes, after eating.', 'We’ll check for reflux or cardiac issues.'),
('Do you have any trouble hearing?', 'Yes, in one ear.', 'We’ll refer you to audiology.'),
('Are you experiencing tremors?', 'Yes, in my hands.', 'We’ll assess for Parkinson’s or essential tremor.'),
('Do you have any trouble with coordination?', 'Yes, I drop things often.', 'We’ll do a motor function test.'),
('Are you experiencing pressure in your head?', 'Yes, it feels tight.', 'We’ll assess for tension headaches.'),
('Do you have any trouble with vision?', 'Yes, I see double sometimes.', 'We’ll refer you to ophthalmology.'),
('Are you experiencing sensitivity to light?', 'Yes, especially in the morning.', 'We’ll assess for migraines.'),
('Do you have any trouble with digestion?', 'Yes, I feel bloated.', 'We’ll review your diet and run tests.'),
('Are you experiencing frequent urination?', 'Yes, every hour.', 'We’ll check for diabetes or UTI.'),
('Do you have any trouble with balance?', 'Yes, I wobble when I walk.', 'We’ll assess vestibular function.'),
('Are you experiencing ringing in your ears?', 'Yes, constantly.', 'We’ll assess for tinnitus.'),
('Do you have any trouble with speech?', 'Yes, I stutter.', 'We’ll refer you to speech therapy.'),
('Are you experiencing numbness in your face?', 'Yes, on the left side.', 'We’ll assess for stroke or nerve issues.'),
('Do you have any trouble with swallowing?', 'Yes, liquids go down wrong.', 'We’ll do a swallow study.'),
('Are you experiencing pain when breathing?', 'Yes, deep breaths hurt.', 'We’ll check for pleurisy or lung issues.'),
('Do you have any trouble with memory?', 'Yes, I forget names.', 'We’ll do a cognitive assessment.'),
('Are you experiencing burning sensations?', 'Yes, in my stomach.', 'We’ll assess for ulcers or reflux.'),
('Do you have any trouble with your hands?', 'Yes, they feel stiff.', 'We’ll check for arthritis