33 lines
858 B
SQL
33 lines
858 B
SQL
CREATE TABLE IF NOT EXISTS ref_med_administration (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
name TEXT NOT NULL UNIQUE,
|
|
accro TEXT,
|
|
notes TEXT
|
|
);
|
|
|
|
INSERT OR IGNORE INTO ref_med_administration (name, accro) VALUES
|
|
('Prise orale', 'PO'),
|
|
('Sous-cutané', 'SC'),
|
|
('Intramusculaire', 'IM'),
|
|
('Intraveineux', 'IV'),
|
|
('Intra-péritonéal', 'IP'),
|
|
('Intradermique', 'ID'),
|
|
('Topique', 'TOP'),
|
|
('Oculaire', 'OC'),
|
|
('Auriculaire', 'AUR'),
|
|
('Intra-nasal', 'IN'),
|
|
('Rectale', 'PR'),
|
|
('Sublinguale', 'SL'),
|
|
('Transdermique', 'TD'),
|
|
('Inhalation', 'INH');
|
|
|
|
CREATE TABLE IF NOT EXISTS icad_cache (
|
|
animal_id INTEGER PRIMARY KEY,
|
|
chip_id TEXT,
|
|
data_json TEXT,
|
|
fetched_at TEXT,
|
|
status TEXT,
|
|
error_msg TEXT
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_icad_cache_chip ON icad_cache(chip_id);
|