umc_toyproject

Tables (5)

Department (Untitled3)

  • departmentId (UUID) — Primary key — NOT NULL
  • hospitalId (UUID2) — Foreign key → Hospital.hospitalId — NOT NULL
  • departmentName (VARCHAR(50))
  • phone (VARCHAR(20))

Doctor (Untitled4)

  • doctorId (UUID) — Primary key — NOT NULL
  • hospitalId (UUID2) — Foreign key → Hospital.hospitalId — NOT NULL
  • departmentId (UUID3) — Foreign key → Department.departmentId — NOT NULL
  • doctorName (VARCHAR(50))
  • experienceYears (INT)

Hospital (Untitled2)

  • hospitalId (UUID) — Primary key — NOT NULL
  • hospitalName (VARCHAR(100))
  • address (VARCHAR(255))

Patient (Untitled)

  • patientId (UUID) — Primary key — NOT NULL
  • patientName (VARCHAR(50))
  • age (INT)
  • gender (VARCHAR(10))

Reservation (Untitled5)

  • reservationId (UUID) — Primary key — NOT NULL
  • patientId (UUID2) — Foreign key → Patient.patientId — NOT NULL
  • hospitalId (UUID3) — Foreign key → Hospital.hospitalId — NOT NULL
  • departmentId (UUID4) — Foreign key → Department.departmentId — NOT NULL
  • doctorId (UUID5) — Foreign key → Doctor.doctorId — NOT NULL
  • reservationTime (DATETIME)
  • isCompleted (BOOLEAN)