HOSP

Tables (5)

appointments

  • appointment_id — INT
  • patient_id — INT
  • doctor_id — INT
  • appointment_date — DATETIME
  • status — ENUM('Scheduled', 'Completed', 'Cancelled')
  • reason — TEXT

billing

  • bill_id — INT
  • patient_id — INT
  • appointment_id — INT
  • total_amount — DECIMAL(10,2)
  • paid_amount — DECIMAL(10,2)
  • payment_status — ENUM('Pending', 'Partial', 'Paid')
  • bill_date — TIMESTAMP

doctors

  • doctor_id — INT
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • specialization — VARCHAR(100)
  • dept_id — INT
  • phone — VARCHAR(15)
  • email — VARCHAR(100)
  • salary — DECIMAL(10,2)
  • hire_date — DATE

medical_records

  • record_id — INT
  • patient_id — INT
  • doctor_id — INT
  • diagnosis — TEXT
  • prescription — TEXT
  • visit_date — DATE
  • follow_up_date — DATE

patients

  • patient_id — INT
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • date_of_birth — DATE
  • gender — ENUM('M', 'F', 'Other')
  • phone — VARCHAR(15)
  • email — VARCHAR(100)
  • address — TEXT
  • blood_group — VARCHAR(5)
  • registration_date — TIMESTAMP