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