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)