hospital
Tables (14)
Cure (처치)
- cur_id (처치ID) — VARCHAR — Primary key — NOT NULL
- tre_id (진료ID) — VARCHAR — Foreign key → Treatment.tre_id — NOT NULL
- rec_id (접수ID) — VARCHAR — Foreign key → Treatment.rec_id — NOT NULL
- cur_content (처치내용) — VARCHAR
- cur_cost (처치비용) — INTEGER
Doctor (의사)
- doc_id (의사ID) — VARCHAR — Primary key — NOT NULL
- emp_id (근로자ID) — VARCHAR — Foreign key → Employees.emp_id — NOT NULL
Employees (근로자)
- emp_id (근로자ID) — VARCHAR — Primary key — NOT NULL
- emp_work (직무) — VARCHAR
- emp_name (이름) — VARCHAR — NOT NULL
- emp_gender (성별) — VARCHAR
- emp_phone (전화번호) — VARCHAR
Expense (지출)
- exp_id (지출ID) — VARCHAR — Primary key — NOT NULL
- work_id (업무ID) — VARCHAR — Foreign key → Work.work_id — NOT NULL
- exp_money (지출금액) — INTEGER
- exp_content (지출내용) — VARCHAR
- exp_date (지출날짜) — DATE
- wage_id (임금ID) — VARCHAR — Foreign key → Wage.wage_id — NOT NULL
- emp_id (근로자ID) — VARCHAR — Foreign key → Wage.emp_id
Facility (시설물)
- work_id (업무ID) — VARCHAR — Foreign key → Work.work_id — NOT NULL
- fac_name (시설물이름) — VARCHAR
Nurse (간호사)
- nur_id (간호사ID) — VARCHAR — Primary key — NOT NULL
- emp_id (근로자ID) — VARCHAR — Foreign key → Employees.emp_id — NOT NULL
Patient (환자)
- pat_id (환자ID) — VARCHAR — Primary key — NOT NULL
- pat_insurance (보험여부) — BOOLEAN
- pat_wound (아픈부분) — VARCHAR
- pat_name (이름) — VARCHAR
- pat_gender (성별) — VARCHAR
- pat_phone (전화번호) — VARCHAR
- pat_ownid (주민번호) — VARCHAR
- pat_age (나이) — INTEGER
- pat_birthday (생년월일) — VARCHAR
Prescription (처방)
- pre_id (처방ID) — VARCHAR — Primary key — NOT NULL
- tre_id (진료ID) — VARCHAR — Foreign key → Treatment.tre_id — NOT NULL
- rec_id (접수ID) — VARCHAR — Foreign key → Treatment.rec_id — NOT NULL
- pre_content (진료내용) — VARCHAR
- pre_cost (처방비용) — INTEGER
- pre_take (복용법) — VARCHAR
Receipt (수납)
- re_id (수납ID) — VARCHAR — Primary key — NOT NULL
- tre_id (진료ID) — VARCHAR — Foreign key → Treatment.tre_id — NOT NULL
- rec_id (접수ID) — VARCHAR — Foreign key → Treatment.rec_id — NOT NULL
Reception (접수)
- rec_id (접수ID) — VARCHAR — Primary key — NOT NULL
- rec_date (예약날짜) — DATE
- rec_check (예약여부) — BOOLEAN — NOT NULL
- doc_id (의사ID) — VARCHAR — Foreign key → Doctor.doc_id — NOT NULL
- pat_id (환자ID) — VARCHAR — Foreign key → Patient.pat_id — NOT NULL
- work_id (업무ID) — VARCHAR — Foreign key → Work.work_id — NOT NULL
Staff (직원)
- st_id (직원ID) — VARCHAR — Primary key — NOT NULL
- emp_id (근로자ID) — VARCHAR — Foreign key → Employees.emp_id — NOT NULL
Treatment (진료)
- tre_id (진료ID) — VARCHAR — Primary key — NOT NULL
- rec_id (접수ID) — VARCHAR — Foreign key → Reception.rec_id — NOT NULL
- tre_content (진료내용) — VARCHAR
- tre_cost (진료비) — INTEGER
- nur_id (간호사ID) — VARCHAR — Foreign key → Nurse.nur_id — NOT NULL
Wage (임금)
- wage_id (임금ID) — VARCHAR — Primary key — NOT NULL
- emp_id (근로자ID) — VARCHAR — Foreign key → Employees.emp_id — NOT NULL
- wage_money (금액) — INTEGER
Work (업무)
- work_id (업무ID) — VARCHAR — Primary key — NOT NULL
- work_content (업무내용) — VARCHAR
- st_id (직원ID) — VARCHAR — Foreign key → Staff.st_id — NOT NULL