-- SIMRS Tipe C v0.4: jalankan hanya SETELAH schema-full.sql v0.3, pada database UJI.
ALTER TABLE users MODIFY role ENUM('admin','registrasi','perawat','dokter','farmasi','laboratorium','admisi','kasir','manajemen','igd','radiologi') NOT NULL;
CREATE TABLE emergency_visits (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, patient_id BIGINT UNSIGNED NOT NULL, arrival_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, triage_level ENUM('resusitasi','emergensi','urgent','less_urgent','non_urgent') NOT NULL, chief_complaint TEXT NOT NULL, vital_summary TEXT NULL, status ENUM('active','referred','admitted','discharged') NOT NULL DEFAULT 'active', disposition_note TEXT NULL, created_by BIGINT UNSIGNED NOT NULL, closed_by BIGINT UNSIGNED NULL, closed_at DATETIME NULL, FOREIGN KEY(patient_id) REFERENCES patients(id), FOREIGN KEY(created_by) REFERENCES users(id), FOREIGN KEY(closed_by) REFERENCES users(id), INDEX(status,arrival_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE radiology_orders (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, patient_id BIGINT UNSIGNED NOT NULL, visit_id BIGINT UNSIGNED NULL, admission_id BIGINT UNSIGNED NULL, modality VARCHAR(80) NOT NULL, exam_name VARCHAR(160) NOT NULL, clinical_indication TEXT NOT NULL, status ENUM('requested','reported') NOT NULL DEFAULT 'requested', report_text TEXT NULL, ordered_by BIGINT UNSIGNED NOT NULL, reported_by BIGINT UNSIGNED NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, reported_at DATETIME NULL, FOREIGN KEY(patient_id) REFERENCES patients(id), FOREIGN KEY(visit_id) REFERENCES visits(id), FOREIGN KEY(admission_id) REFERENCES admissions(id), FOREIGN KEY(ordered_by) REFERENCES users(id), FOREIGN KEY(reported_by) REFERENCES users(id), INDEX(status,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE satusehat_outbox (id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, resource_type VARCHAR(60) NOT NULL, local_type VARCHAR(60) NOT NULL, local_id BIGINT UNSIGNED NOT NULL, status ENUM('draft','ready','sent','failed') NOT NULL DEFAULT 'draft', payload_json JSON NULL, external_id VARCHAR(120) NULL, last_error VARCHAR(500) NULL, created_by BIGINT UNSIGNED NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY(created_by) REFERENCES users(id), UNIQUE KEY uq_resource (resource_type,local_type,local_id), INDEX(status,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
