umc_toy_project

Tables (5)

Department (Untitled3)

  • Id (Key) — Long — Primary key — NOT NULL
  • Name (Field) — Long
  • PhoneNum (Field2) — Long
  • Hostipal (Key2) — Long — Foreign key → Hospital.Id — NOT NULL
  • Docter (Field3) — List<Long>
  • Field4

Docter (Untitled4)

  • Id (Key) — Long — Primary key — NOT NULL
  • Name (Field) — Long
  • Career (Field2) — Long
  • Reservation (Field5) — List<Long>
  • Hospital (Key2) — Long — Foreign key → Hospital.Id — NOT NULL
  • Department (Key3) — Long — Foreign key → Department.Id — NOT NULL

Hospital (Untitled2)

  • Id (Key) — Long — Primary key — NOT NULL
  • Name (Field) — String
  • Address (Field2) — String
  • Department (Field3) — List<Long>
  • Hospital (Field4) — List<Long>

Patient (Untitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • name (Field3) — Long
  • age (Field) — Long
  • gender (Field2) — Long
  • reservation (Field4) — List<Long>

Reservation (Untitled5)

  • Id (Key) — Long — Primary key — NOT NULL
  • Time (Field3) — LocalDateTime
  • Status (Field4) — Enum
  • Patient (Key2) — Long — Foreign key → Patient.Id — NOT NULL
  • Docter (Key3) — Long — Foreign key → Docter.Id — NOT NULL