# migrations

dir: embeddings_queue
filename: 00001-embeddings.sqlite.sql
hash: d3755dfd232be8e8301f4d7fcfb3a486
sql:
CREATE TABLE embeddings_queue (
    seq_id INTEGER PRIMARY KEY,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    operation INTEGER NOT NULL,
    topic TEXT NOT NULL,
    id TEXT NOT NULL,
    vector BLOB,
    encoding TEXT,
    metadata TEXT
);


dir: sysdb
filename: 00001-collections.sqlite.sql
hash: 38352d725ad1c16074fac420b22b4633
sql:
CREATE TABLE collections (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    topic TEXT NOT NULL,
    UNIQUE (name)
);

CREATE TABLE collection_metadata (
    collection_id TEXT REFERENCES collections(id) ON DELETE CASCADE,
    key TEXT NOT NULL,
    str_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (collection_id, key)
);


dir: sysdb
filename: 00002-segments.sqlite.sql
hash: 2913cb6a503055a95f625448037e8912
sql:
CREATE TABLE segments (
    id TEXT PRIMARY KEY,
    type TEXT NOT NULL,
    scope TEXT NOT NULL,
    topic TEXT,
    collection TEXT REFERENCES collection(id)
);

CREATE TABLE segment_metadata (
    segment_id TEXT  REFERENCES segments(id) ON DELETE CASCADE,
    key TEXT NOT NULL,
    str_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (segment_id, key)
);


dir: metadb
filename: 00001-embedding-metadata.sqlite.sql
hash: 2b4cf52c4bb2676e21d6860a4409f856
sql:
CREATE TABLE embeddings (
    id INTEGER PRIMARY KEY,
    segment_id TEXT NOT NULL,
    embedding_id TEXT NOT NULL,
    seq_id BLOB NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE (segment_id, embedding_id)
);

CREATE TABLE embedding_metadata (
    id INTEGER REFERENCES embeddings(id),
    key TEXT NOT NULL,
    string_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (id, key)
);

CREATE TABLE max_seq_id (
    segment_id TEXT PRIMARY KEY,
    seq_id BLOB NOT NULL
);

CREATE VIRTUAL TABLE embedding_fulltext USING fts5(id, string_value);


dir: metadb
filename: 00002-embedding-metadata.sqlite.sql
hash: 12a570f7121b3a8ce750a2a7c36da20f
sql:
-- SQLite does not support adding check with alter table, as a result, adding a check
-- involve creating a new table and copying the data over. It is over kill with adding
-- a boolean type column. The application write to the table needs to ensure the data
-- integrity.
ALTER TABLE embedding_metadata ADD COLUMN bool_value INTEGER


dir: metadb
filename: 00003-full-text-tokenize.sqlite.sql
hash: f97ad6334aeaa8f419f01110b648b97a
sql:
CREATE VIRTUAL TABLE embedding_fulltext_search USING fts5(string_value, tokenize='trigram');
INSERT INTO embedding_fulltext_search (rowid, string_value) SELECT rowid, string_value FROM embedding_metadata;
DROP TABLE embedding_fulltext;


# embeddings_queue

created_at: 2023-09-03 20:24:02
topic: persistent://default/default/87b864f1-6081-4d33-84b6-1c4edb3ede75
id: d1d280cc-4a97-11ee-876d-42010aa40002
encoding: FLOAT32
metadata:
{"chroma:document": "Profile details\n\nPayal Tandon\n\nFemale\n\netd\nSeen\n\nPatient details\n\nName\nSurname\nDate of Birth\ncity\n\nCountry\n\nShared profile\n\nRekha Singhn\nTviews\n\nEy\n\nPayal\nTandon\nLuly 16, 1990 (30y)\nMumbai\n\nIndia"}


created_at: 2023-09-04 07:37:01
topic: persistent://default/default/87b864f1-6081-4d33-84b6-1c4edb3ede75
id: d5b7ce64-4af5-11ee-b32d-42010aa40002
encoding: FLOAT32
metadata:
{"chroma:document": "ony) DR.NILESH CHINCHKAR\n$ MBBS, DTCD (Chest Diseases),\n\u201ca DNB ( Pulmonary & Sleep Medicine)\nCHEST CARE CENTRE\n\nPulmonologist, Intensivist\n\n \n\n15179 : Mrs.Yogini Rajshekhar Surve (56y, Female) - 9819522437\nHOM 148 cm: 02-Sep-2023\nNeh KeTTER: Dr. Tipnis\n\nDiagnosis:\n\n \n\n\u00b0 F/U C/O\n\n* HYPOXIC RESPIRATORY FAILURE\n\u00a2 LRTI\n\n\u00a2 BRONCHIOLITIS\n\nK\n\nMedicine Dose Timing - Freq. - Duration\n\n1 Fluticasone furoate 100 MCG + Vilanterol 25 MCG"}


created_at: 2023-09-04 07:37:01
topic: persistent://default/default/87b864f1-6081-4d33-84b6-1c4edb3ede75
id: d5b7cf36-4af5-11ee-b32d-42010aa40002
encoding: FLOAT32
metadata:
{"chroma:document": "K\n\nMedicine Dose Timing - Freq. - Duration\n\n1 Fluticasone furoate 100 MCG + Vilanterol 25 MCG\n\nODIHALE INHALER WITH SPACER 0-2-0 at\n2-eaet\n2 Prednisolone 10 MG\nWYSOLONE 10MG TABLET 1-0-0 waartat - ater - 7 fea\nLarger Aare\n\n \n\n3 Hydroxyzine 10 MG\n\nATARAX 10MG TABLET 1-0-1 anther - 3 fear\nLeaner 1278\n\n \n\nAdvice: PFT ON 2/9/23\nNext Visit : 02-Oct-2023 - Monday\n\n(Apa\n\nDr. Nilesh Chinchkar\nReg. no. 2005083272\nPulmonologist, Intensivist"}


created_at: 2023-09-04 07:42:03
topic: persistent://default/default/87b864f1-6081-4d33-84b6-1c4edb3ede75
id: 89b1f85e-4af6-11ee-ba3e-42010aa40002
encoding: FLOAT32
metadata:
{"chroma:document": "23 (1650x2220x16M jpeg)\n\n== VADAMALAYAN DIAGNOSTIC CENTRE\n\n10 9001 : 2000 & 14001 : 200\u00a2 Certteg\n\nBLOOD REPORT\n\n \n\n \n\nPt,NAME \u00a9 MR.M.RAMESH\nAGE / SEX 33/M\nREF BY DR M.A.SARAVANAN.,BHMS.,\nRECEIVED ON : 1.12.08\nREPORTED ON : 2.12.08\nREQ NO 33545\n| __ INVESTIGATION PT VALUE _ _REFERANGE VALUE(ng/ml)\nMALES :\nPrepubertal (late) - 0.1-0.2ng/ml\n| TESTOSTERONE | 6.8 ngimi | Adult ~ 3.0-10.0 ng/ml\n| |EEMALES :"}


created_at: 2023-09-04 07:42:03
topic: persistent://default/default/87b864f1-6081-4d33-84b6-1c4edb3ede75
id: 89b1f980-4af6-11ee-ba3e-42010aa40002
encoding: FLOAT32
metadata:
{"chroma:document": "Prepubertal_(late) - 0.1 \u2014 0.2 ng/ml\nFollicular phase .- 0.2 - 0.8 ng/ml\nLuteal phase + 0.2 \u2014 0.8 ng/mi\n\nPost menopausal - 0.08- 0.35ng/m!\n\n \n\n \n\nWiroc- 15\n\nA Wlra- = oe\nVerified By Sign of Techifician\n\nRound the Clock Service / Computerized Auto Analyser RA 50 / Elisa System\n\nHAEMATOLOGY Analyzer / Blood Gas Analyzer & Electrolyte Analyzer - Hb AIC Assay"}


# embedding_metadata

key: chroma:document
string_value:
Profile details

Payal Tandon

Female

etd
Seen

Patient details

Name
Surname
Date of Birth
city

Country

Shared profile

Rekha Singhn
Tviews

Ey

Payal
Tandon
Luly 16, 1990 (30y)
Mumbai

India


key: chroma:document
string_value:
ony) DR.NILESH CHINCHKAR
$ MBBS, DTCD (Chest Diseases),
“a DNB ( Pulmonary & Sleep Medicine)
CHEST CARE CENTRE

Pulmonologist, Intensivist

 

15179 : Mrs.Yogini Rajshekhar Surve (56y, Female) - 9819522437
HOM 148 cm: 02-Sep-2023
Neh KeTTER: Dr. Tipnis

Diagnosis:

 

° F/U C/O

* HYPOXIC RESPIRATORY FAILURE
¢ LRTI

¢ BRONCHIOLITIS

K

Medicine Dose Timing - Freq. - Duration

1 Fluticasone furoate 100 MCG + Vilanterol 25 MCG


key: chroma:document
string_value:
K

Medicine Dose Timing - Freq. - Duration

1 Fluticasone furoate 100 MCG + Vilanterol 25 MCG

ODIHALE INHALER WITH SPACER 0-2-0 at
2-eaet
2 Prednisolone 10 MG
WYSOLONE 10MG TABLET 1-0-0 waartat - ater - 7 fea
Larger Aare

 

3 Hydroxyzine 10 MG

ATARAX 10MG TABLET 1-0-1 anther - 3 fear
Leaner 1278

 

Advice: PFT ON 2/9/23
Next Visit : 02-Oct-2023 - Monday

(Apa

Dr. Nilesh Chinchkar
Reg. no. 2005083272
Pulmonologist, Intensivist


key: chroma:document
string_value:
23 (1650x2220x16M jpeg)

== VADAMALAYAN DIAGNOSTIC CENTRE

10 9001 : 2000 & 14001 : 200¢ Certteg

BLOOD REPORT

 

 

Pt,NAME © MR.M.RAMESH
AGE / SEX 33/M
REF BY DR M.A.SARAVANAN.,BHMS.,
RECEIVED ON : 1.12.08
REPORTED ON : 2.12.08
REQ NO 33545
| __ INVESTIGATION PT VALUE _ _REFERANGE VALUE(ng/ml)
MALES :
Prepubertal (late) - 0.1-0.2ng/ml
| TESTOSTERONE | 6.8 ngimi | Adult ~ 3.0-10.0 ng/ml
| |EEMALES :


key: chroma:document
string_value:
Prepubertal_(late) - 0.1 — 0.2 ng/ml
Follicular phase .- 0.2 - 0.8 ng/ml
Luteal phase + 0.2 — 0.8 ng/mi

Post menopausal - 0.08- 0.35ng/m!

 

 

Wiroc- 15

A Wlra- = oe
Verified By Sign of Techifician

Round the Clock Service / Computerized Auto Analyser RA 50 / Elisa System

HAEMATOLOGY Analyzer / Blood Gas Analyzer & Electrolyte Analyzer - Hb AIC Assay


