title

Tables (4)

departments (Untitled2)

  • 진료과_ID (department_id) — PRIMARY KEY — Primary key — NOT NULL
  • 진료과_name (department_name)

disease (Untitled)

  • 질병_ID (disease_id) — PRIMARY KEY — Primary key — NOT NULL
  • 질병_name (disease_name)

disease_department (Untitled3)

  • 질병_ID (disease_id) — FOREIGN KEY — Primary key — NOT NULL
  • 진료과_ID (department_id) — FOREIGN KEY — Primary key

hospital_info (Untitled5)

  • 병원_ID (hospital_id) — PRIMARY KEY — Primary key — NOT NULL
  • 진료과_ID (department_id) — FOREIGN KEY
  • 병원_name (hospital_name)
  • 휴무일 (off_days)
  • 전화번호 (phone)
  • 전문의 정보 (specialist_info)
  • 주소 (address)
  • 운영시간 (operation_hours)
  • 점심시간 (lunch_time)