대학병원 진단서

테이블 (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