HospitalReservationSystem

테이블 (5)

병원 (hospitals)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR
  • Field2 (address) — VARCHAR
  • Field (created_at) — DATETIME

예약 (reservations)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (patient_id) — BIGINT — 외래 키 → 환자.Key — NOT NULL
  • Key (doctor_id) — BIGINT — 외래 키 → 의사.Key — NOT NULL
  • Field (appointment_time) — DATETIME — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

의사 (doctors)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (department_id) — BIGINT — 외래 키 → 진료과.Key — NOT NULL
  • Field (name) — VARCHAR
  • Field2 (phone_number) — VARCHAR
  • Field3 (career) — BIGINT
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL
  • Key (id2) — BIGINT — 외래 키 → 병원.Key — NOT NULL

진료과 (departments)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (hospital_id) — BIGINT — 외래 키 → 병원.Key — NOT NULL
  • Field (name) — VARCHAR
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME

환자 (patients)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 나이 (age) — INT — NOT NULL
  • 성별 (gender) — VARCHAR — NOT NULL
  • 이름 (name) — VARCHAR — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL