nccis

Tables (15)

AuthRole (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • description (Field2) — String

AuthToken (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • token (Field) — String
  • type (Field2) — TokenType
  • issuedAt (Field3) — LocalDateTime
  • expiresAt (Field4) — LocalDateTime
  • user_id (Key2) — Long — Foreign key → AuthUser.id — NOT NULL

AuthUser (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • loginId (Field) — String
  • name (Field2) — String
  • email (Field3) — String
  • password (Field4) — String
  • status (Field5) — String
  • enabled (Field6) — boolean
  • createdAt (Field7) — LocalDateTime
  • role_id (Key2) — Long — Foreign key → AuthRole.id — NOT NULL
  • org_id (Key4) — UUID — Foreign key → Organazation.id — NOT NULL

BedFlag (Untitled15)

  • id (Key) — Long — Primary key — NOT NULL
  • timestamp (Field) — LocalDateTime
  • org_id (Key2) — UUID — Foreign key → Organazation.id — NOT NULL

BedStatus (Untitled10)

  • id (Key) — Long — Primary key — NOT NULL
  • licensed (Field) — Integer
  • occupied (Field2) — Integer
  • reserved (Field3) — Integer
  • negativePressureLicensed (Field7) — Integer
  • negativePressureOccupied (Field8) — Integer
  • lifeSustainingPatients (Field9) — Integer
  • singleLicensed (Field4) — Integer
  • singleOccupied (Field5) — Integer
  • note (Field6) — String
  • bedType (Key2) — String — Foreign key → BedType.code — NOT NULL
  • bed_flag_id (Key3) — Long — Foreign key → BedFlag.id — NOT NULL

BedType (Untitled11)

  • code (Key) — String — Primary key — NOT NULL
  • name (Field) — String

Designation (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • org_id (Key2) — UUID — Foreign key → Organazation.id — NOT NULL

EquipmentFlag (Untitled14)

  • id (Key) — Long — Primary key — NOT NULL
  • timestamp (Field) — LocalDateTime
  • orgid (Key2) — UUID — Foreign key → Organazation.id — NOT NULL

EquipmentStatus (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • capturedAt (Field) — LocalDateTime
  • model (Field2) — String
  • total (Field3) — int
  • inService (Field4) — int
  • underRepair (Field5) — int
  • manufacturer (Field6) — String
  • code (Key3) — String — Foreign key → EquipmentType.code — NOT NULL
  • equip_flag_id (Key2) — Long — Foreign key → EquipmentFlag.id — NOT NULL

EquipmentType (Untitled9)

  • code (Key) — String — Primary key — NOT NULL
  • name (Field2) — String

Flag (Untitled13)

  • code (Key) — String — Primary key — NOT NULL
  • type (Field) — String
  • description (Field2) — String

HospitalFlag (Untitled12)

  • id (Key) — Long — Primary key — NOT NULL
  • capturedAt (Field) — LocalDateTime
  • code (Field2) — String
  • valBool (Field3) — bool
  • valNumber (Field4) — Integer
  • valText (Field5) — text
  • flag (Key2) — String — Foreign key → Flag.code — NOT NULL
  • org_id (Key3) — UUID — Foreign key → Organazation.id — NOT NULL

Organazation (Untitled4)

  • id (Key) — UUID — Primary key — NOT NULL
  • code (Field) — String
  • type (Field2) — String
  • name (Field3) — String
  • address (Field4) — json
  • geo (Field14) — json
  • tel (Field5) — String
  • website (Field10) — String
  • email (Field11) — String
  • centralMonitoringSystem (Field15) — bool
  • lifeSustainingCapability (Field16) — bool
  • specializedIcuNurse (Field17) — bool
  • icuDedicatedIntensivistDay (Field18) — bool
  • criticalCareSubspecialistPresent (Field19) — bool
  • strokeIcuPresent (Field20) — bool
  • multidisciplinaryStaff (Field21) — bool
  • icuBedRatio (Field22) — int
  • admitDischargePolicy (Field23) — String
  • ehrNote (Field8) — text
  • description (Field12) — String
  • createdAt (Field13) — LocalDateTime

UnitContact (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • position (Field2) — String
  • mobile (Field3) — String
  • email (Field4) — String
  • org_id (Key2) — UUID — Foreign key → Organazation.id — NOT NULL

Verification (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • code (Field2) — String
  • active (Field3) — boolean
  • verified (Field4) — boolean
  • createdAt (Field5) — LocalDateTime
  • expiresAte (Field6) — LocalDateTime