디비 플젝

테이블 (9)

Doctor

  • doctor_id — BIGINT — 기본 키 — NOT NULL
  • Field (name)
  • Field (address)
  • Field2 (phone_number)
  • Field (password)
  • Field (status) — 1
  • Key (department_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MedicalSpecialty)

  • Key (department_id) — 기본 키 — NOT NULL
  • Field (department_name)
  • Field2 (phone_number)

Untitled (Nurse)

  • Key (nurse_id) — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (address)
  • Field3 (phone_number)
  • Field (password)
  • Field (status) — 2
  • Key (department_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Patient)

  • Key (patient_id) — 기본 키 — NOT NULL
  • Field (name)
  • Field2 (ssn)
  • Field3 (gender)
  • Field4 (address)
  • Field5 (blood_type)
  • Field6 (height)
  • Field (weight)
  • Field2 (phone_number)
  • Field (password)
  • Field (status) — 3
  • doctor_id — BIGINT — 외래 키 → Doctor.doctor_id — NOT NULL
  • Key (nurse_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Inpatient)

  • Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL
  • Field (room_information)
  • Field2 (admission_date_time)
  • Field3 (discharge_date_time)

Untitled (Reservation)

  • Key (reservation_number) — 기본 키 — NOT NULL
  • Field (reservation_date_time)
  • Key (department_id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Examination)

  • Key — 기본 키 — NOT NULL
  • Field (examination_date_time)
  • Field2 (examination_details)
  • doctor_id — BIGINT — 외래 키 → Doctor.doctor_id — NOT NULL
  • Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Treatment)

  • Key — 기본 키 — NOT NULL
  • Field (treatment_date_time)
  • Field2 (treatment_details)
  • Key (nurse_id) — 외래 키 → Untitled.Key — NOT NULL
  • Key (patient_id) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Manager)

  • Key (manager_id) — 기본 키 — NOT NULL
  • Field (name)
  • Field (password)
  • Field (status) — 0
  • Field