search

Swasth-Digital-Health-Foundation / C19CareAssist

Chatbot based triaging, self care, care discovery and informational assistant
MIT License
0 stars 0 forks source link

Index columns #4

Closed nithindv closed 3 years ago

nithindv commented 3 years ago

List out columns to be indexed. All columns on which searches are being made should be indexed

rushang7 commented 3 years ago

Person:

  1. mobile_hash
  2. created_at
  3. uuid

C19_triage:

  1. person_id
  2. subscribe
  3. created_at For anticipated queries:
  4. comorbidities
  5. spo2
  6. symptoms
  7. rt_pcr_status

C19_vitals:

  1. person_id
  2. created_at Anticipated queries
  3. temperature
  4. spo2
nithindv commented 3 years ago

Added indices, yet to commit hasura migrations will update PR

Migration files added