UMC Week10

Tables (6)

BaseEntity (Untitled2)

  • createdAt (생성 시간) — datetime
  • updatedAt (수정 시간) — datetime

Department (진료과)

  • id (진료과id) — bigint — Primary key — NOT NULL
  • hospital_id (병원 id) — bigint — Foreign key → Hospital.id — NOT NULL
  • name (진료과 이름) — varchar(50)

Doctor (의사)

  • id (의사 id) — bigint — Primary key — NOT NULL
  • department_id (진료과id) — bigint — Foreign key → Department.id — NOT NULL
  • hospital_id (병원 id) — bigint — Foreign key → Department.hospital_id — NOT NULL
  • name (이름) — varchar(10)
  • career (경력) — int

Hospital (병원)

  • id (병원 id) — bigint — Primary key — NOT NULL
  • name (병원 이름) — varchar(20)
  • address (병원 주소) — varchar(100)

Patient (Untitled)

  • id (환자 id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(10) — NOT NULL
  • gender (성별) — varchar(10) — NOT NULL
  • age (나이) — int — NOT NULL

Reservation (예약 정보)

  • id (예약 id) — bigint — Primary key — NOT NULL
  • patient_id (환자 id) — bigint — Foreign key → Patient.id — NOT NULL
  • doctor_id (의사 id) — bigint — Foreign key → Doctor.id — NOT NULL
  • id (진료과id) — bigint — Foreign key → Doctor.department_id — NOT NULL
  • hospital_id (병원 id) — bigint — Foreign key → Doctor.hospital_id — NOT NULL
  • time (예약 시간) — datetime — NOT NULL
  • status (예약 상태) — varchar(10) — NOT NULL
  • fee (병원비) — int