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)