erd for hms

Tables (11)

DEPARTMENT (department)

  • Dep id (dep_id) — VARCHAR(255) — Primary key — NOT NULL
  • Dep Name (dep_name) — VARCHAR(255)
  • Dep loc (dep_loc) — VARCHAR(255)
  • Fac avail (fac_avail) — CHAR(1)

DOC ON CALL (doc_on_call)

  • Doc id (doc_id) — VARCHAR(255) — Foreign key → DOCTORS.Doc id — NOT NULL
  • Doc Name (doc_name) — VARCHAR(255)
  • Qualification (qualification) — VARCHAR(255)
  • Address (address) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Date of joining (data_of_joining) — VARCHAR(11)
  • Fees per call (fees_per_call) — VARCHAR(255)
  • Payment due (payment_due) — VARCHAR(255)

DOC REG (doc_reg)

  • Doc id (doc_id) — VARCHAR(255) — Foreign key → DOCTORS.Doc id — NOT NULL
  • Doc Name (doc_name) — VARCHAR(255)
  • Qualification (qualification) — VARCHAR(255)
  • Address (address) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Date of joining (data_of_joining) — VARCHAR(11)
  • Salary (salary) — VARCHAR(255)

DOCTORS (doctors)

  • Doc id (doc_id) — VARCHAR(255) — Primary key — NOT NULL
  • Dep id (dep_id) — VARCHAR(255) — Foreign key → DEPARTMENT.Dep id — NOT NULL
  • Doc Name (doc_name) — VARCHAR(255)

Matching Dep (matching_dep)

  • Patient id (patient_id) — VARCHAR(255) — Foreign key → PATIENT.Patient id — NOT NULL — Patient id는 prefix PT가 붙고 그 다음 id 번호가 나온다.
  • Dep id (dep_id) — VARCHAR(255) — Foreign key → DEPARTMENT.Dep id — NOT NULL
  • Time of matching dep (time_of_matching_dep) — VARCHAR(255)

Matching Doc (matching_doc)

  • Patient id (patient_id) — VARCHAR(255) — Foreign key → PATIENT.Patient id — NOT NULL — Patient id는 prefix PT가 붙고 그 다음 id 번호가 나온다.
  • Doc id (doc_id) — VARCHAR(255) — Foreign key → DOCTORS.Doc id — NOT NULL
  • Time of matching doc (time_of_matching_doc) — VARCHAR(255)

PAT ADMIT (pat_admit)

  • Patient id (patient_id) — VARCHAR(255) — Foreign key → PATIENT.Patient id — NOT NULL — Patient id는 prefix PT가 붙고 그 다음 id 번호가 나온다.
  • Room number (room_number) — VARCHAR(255) — Foreign key → ROOM DETAILS.Room number — NOT NULL
  • Qualification (qualification) — VARCHAR(255)
  • Date of admission (data_of_admission) — VARCHAR(11)
  • Advance payment (advance_payment) — VARCHAR(255)
  • Mode of payment (mode_of_payment) — VARCHAR(255)
  • Initial condition (initial_condition) — VARCHAR(255)
  • Treatment (treatment) — VARCHAR(255)
  • Number of doctor (number_of_doctor) — INT(11)
  • Attendant name (attendant_name) — VARCHAR(255)

PAT OPT (pat_opt)

  • Patient id (patient_id) — VARCHAR(255) — Foreign key → PATIENT.Patient id — NOT NULL — Patient id는 prefix PT가 붙고 그 다음 id 번호가 나온다.
  • Qualification (qualification) — VARCHAR(255)
  • Date of addimission (data_of_visit) — VARCHAR(11)
  • Treatment advice (treatment_advice) — VARCHAR(255)
  • Type of operation (treatment) — VARCHAR(255)
  • Status of treatment (status_of_treatment) — VARCHAR(255)
  • Date of operation (date_of_operation) — VARCHAR(11)
  • Number of doctor (number_of_doctor) — INT(11)
  • Number of operation (number_of_operation) — INT(11)
  • Condition before op (condition_before_op) — VARCHAR(255)
  • Condition after op (condition_after_op) — VARCHAR(255)

PAT REG (pat_reg)

  • Patient id (patient_id2) — VARCHAR(255) — Foreign key → PATIENT.Patient id — NOT NULL — Patient id는 prefix PT가 붙고 그 다음 id 번호가 나온다.
  • Qualification (qualification) — VARCHAR(255)
  • Date of visit (data_of_visit) — VARCHAR(11)
  • Medicine recommended (medicine_recommended) — VARCHAR(255)
  • Treatment (treatment) — VARCHAR(255)
  • Status of treatment (status_of_treatment) — VARCHAR(255)

PATIENT (patient)

  • Patient id (patient_id) — VARCHAR(255) — Primary key — NOT NULL — Patient id는 prefix PT가 붙고 그 다음 id 번호가 나온다.
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Age (age) — INT(3)
  • Sex (sex) — CHAR(1)
  • Address (address) — VARCHAR(255)
  • City (city) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Entry Date (entry_date) — VARCHAR(11)
  • Doctor Referred (doctor_referred) — VARCHAR(255)
  • Diagnosis (diagnosis) — VARCHAR(255)

ROOM DETAILS (room_details)

  • Room number (room_number) — VARCHAR(255) — Primary key — NOT NULL
  • Room type (room_type) — CHAR(1)
  • Status (status) — CHAR(1)
  • Charges (charges) — VARCHAR(255)