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)