-- Seed file for vital signs
-- This file creates vital signs measurements for patient visits

INSERT INTO vital_signs (
    uuid,
    patient_uuid,
    visit_uuid,
    heart_rate,
    systolic_bp,
    diastolic_bp,
    temperature,
    respiratory_rate,
    oxygen_saturation,
    recorded_at,
    created_at,
    updated_at
) VALUES 
-- Cardiovascular Patient CARDIO-001-001 Vital Signs
('840e8400-e29b-41d4-a716-446655440001', '990e8400-e29b-41d4-a716-446655440001', '830e8400-e29b-41d4-a716-446655440001', 78, 142, 88, 36.7, 16, 98.5, '2025-01-22 09:30:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440002', '990e8400-e29b-41d4-a716-446655440001', '830e8400-e29b-41d4-a716-446655440002', 72, 138, 85, 36.8, 14, 99.0, '2025-02-05 10:15:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440003', '990e8400-e29b-41d4-a716-446655440001', '830e8400-e29b-41d4-a716-446655440003', 75, 135, 82, 36.6, 15, 98.8, '2025-02-19 11:00:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Cardiovascular Patient CARDIO-001-002 Vital Signs  
('840e8400-e29b-41d4-a716-446655440004', '990e8400-e29b-41d4-a716-446655440002', '830e8400-e29b-41d4-a716-446655440005', 82, 155, 95, 36.9, 18, 97.8, '2025-01-24 14:20:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440005', '990e8400-e29b-41d4-a716-446655440002', '830e8400-e29b-41d4-a716-446655440006', 76, 148, 90, 36.5, 16, 98.2, '2025-02-07 09:45:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Oncology Patient ONCO-001-001 Vital Signs
('840e8400-e29b-41d4-a716-446655440006', '990e8400-e29b-41d4-a716-446655440010', '830e8400-e29b-41d4-a716-446655440007', 88, 125, 78, 37.1, 20, 96.5, '2024-09-17 13:30:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440007', '990e8400-e29b-41d4-a716-446655440010', '830e8400-e29b-41d4-a716-446655440008', 85, 122, 75, 36.8, 18, 97.2, '2024-10-01 10:20:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440008', '990e8400-e29b-41d4-a716-446655440010', '830e8400-e29b-41d4-a716-446655440009', 92, 118, 72, 37.0, 22, 95.8, '2024-10-15 08:45:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Neurological Patient NEURO-001-001 Vital Signs
('840e8400-e29b-41d4-a716-446655440009', '990e8400-e29b-41d4-a716-446655440017', '830e8400-e29b-41d4-a716-446655440010', 68, 132, 79, 36.4, 14, 99.1, '2024-11-17 15:10:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440010', '990e8400-e29b-41d4-a716-446655440017', '830e8400-e29b-41d4-a716-446655440011', 70, 130, 77, 36.6, 15, 98.9, '2024-12-01 11:30:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- Respiratory Patient BREATHE-001-001 Vital Signs
('840e8400-e29b-41d4-a716-446655440011', '990e8400-e29b-41d4-a716-446655440022', '830e8400-e29b-41d4-a716-446655440012', 74, 145, 92, 36.7, 16, 98.3, '2023-06-17 09:15:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440012', '990e8400-e29b-41d4-a716-446655440022', '830e8400-e29b-41d4-a716-446655440013', 72, 142, 89, 36.8, 15, 98.7, '2023-07-01 10:45:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('840e8400-e29b-41d4-a716-446655440013', '990e8400-e29b-41d4-a716-446655440022', '830e8400-e29b-41d4-a716-446655440014', 69, 138, 85, 36.5, 14, 99.0, '2023-07-15 14:20:00+00', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)

ON CONFLICT (uuid) DO NOTHING;
