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)