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