-- Create Database
CREATE DATABASE IF NOT EXISTS healthcare_hospital;
USE healthcare_hospital;
-- Create Patients Table
CREATE TABLE IF NOT EXISTS patients (
id INT AUTO_INCREMENT PRIMARY KEY,
patient_id VARCHAR(50) UNIQUE NOT NULL,
name VARCHAR(100) NOT NULL,
age INT NOT NULL,
gender ENUM('Male', 'Female', 'Other') NOT NULL,
contact VARCHAR(20) NOT NULL,
department VARCHAR(50) NOT NULL,
doctor VARCHAR(100) NOT NULL,
admission_date DATE NOT NULL,
status ENUM('Admitted', 'Under Treatment', 'Discharged') NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
-- Create Index for faster searches
CREATE INDEX idx_patient_id ON patients(patient_id);
CREATE INDEX idx_name ON patients(name);
CREATE INDEX idx_department ON patients(department);
-- Insert Sample Data
INSERT INTO patients (patient_id, name, age, gender, contact, department, doctor, admission_date, status) VALUES
('PT001', 'Rajesh Kumar', 45, 'Male', '+91 98765-43210', 'Cardiology', 'Dr. Sharma', '2025-10-05', 'Admitted'),
('PT002', 'Priya Devi', 32, 'Female', '+91 98765-43211', 'Orthopedics', 'Dr. Patel', '2025-10-08', 'Discharged'),
('PT003', 'Arun Selvam', 28, 'Male', '+91 98765-43212', 'Neurology', 'Dr. Iyer', '2025-10-10', 'Under Treatment'),
('PT004', 'Lakshmi Menon', 55, 'Female', '+91 98765-43213', 'Cardiology', 'Dr. Sharma', '2025-10-09', 'Admitted'),
('PT005', 'Karthik Reddy', 38, 'Male', '+91 98765-43214', 'Pediatrics', 'Dr. Rao', '2025-10-11', 'Under Treatment');
-- Display all patients
SELECT * FROM patients;