대학병원 진단서
테이블 (4)
Certificate (Untitled2)
- certificate_id (PK) — 기본 키 — NOT NULL
- doctor_id (Key) — 기본 키 — NOT NULL
- patient_id — 기본 키 — NOT NULL
- hospital_id (Key2) — 기본 키 — NOT NULL
- disease_name (Field)
- dianosis_date (Field2)
- issue_date (Field3)
- onset_date (Field4)
- purpose (Field5)
- patiend_id (PK2) — int — 외래 키 → Untitled.patiend_id — NOT NULL
- doctor_id (PK3) — 외래 키 → Untitled.doctor_id — NOT NULL
- hospital_id (PK4) — 외래 키 → Hospital.hospital_id — NOT NULL
Hospital (Untitled)
- hospital_id (PK) — 기본 키 — NOT NULL
- hospital_name (Field)
- fax_num (Field2)
- address (Field3)
- phone_num (Field4)
Untitled (Patient)
- patiend_id (PK) — int — 기본 키 — NOT NULL
- name (Field) — string
- birth_date (Field2) — string
- phone_num (Field3) — string
- address (Field4) — string
Untitled (Doctor)
- doctor_id (PK) — 기본 키 — NOT NULL
- name (Field)
- department (Field2)
- hospital_id (PK2) — 외래 키 → Hospital.hospital_id — NOT NULL