MSS fake data - remove

Tables (7)

Booking (CopyOfUntitled3)

  • ID (Key) — Primary key — NOT NULL
  • Hospital_ID (Key2) — Foreign key → Hospital_booking.ID — NOT NULL
  • hospitalCode (Field)
  • Department (Field4)
  • Modality (Modality code)
  • BodyPart (Body code)
  • BookingStartTime (Field2)
  • BookingEndTime (Field3)

Holiday (Untitled5)

  • Name
  • HolidayDate (yyyy-mm-dd) — Date
  • Field

Hospital_booking (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • Code (Field) — Varchar
  • Name (NameKeyCode)
  • Address (AddressKeyCode)
  • ... (..) — Varchar
  • facilityConnectId (facilityConnectId on MSS)

Hospital_schedule (Untitled4)

  • Key — Primary key — NOT NULL
  • hospitalCode (code) — Foreign key → Hospital_booking.ID — NOT NULL
  • Date (yyyy-mm-dd) — Date
  • StartTimeAM (hhmm)
  • CloseTimeAM (hhmm2)
  • StartTimePM (hhmm3)
  • CloseTimePM (hhmm4)

Procedure (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • HospitalCode (Key2) — Foreign key → Hospital_booking.ID — NOT NULL
  • code (Field)
  • Name (Field2)
  • Modality (Modality code)
  • BodyPart (Body code)
  • Device_ID (Field3)
  • Duration (Field4)

hospital_department (Untitled2)

  • hospitalCode (Key) — Foreign key → Hospital_booking.ID — NOT NULL
  • department (Key2) — Foreign key → item_language.ID — NOT NULL

item_language (Language)

  • ID (Key) — Primary key — NOT NULL
  • KeyCode (Field)
  • en (Field2)
  • ko (Field3)
  • vi (Field5)
  • ImageName (image)
  • default (default en)