Skip to content

Instantly share code, notes, and snippets.

@wabzqem

wabzqem/covidsafe sqlite schema

Last active April 27, 2020 16:15
Show Gist options
  • Save wabzqem/830af6e739ba772638175e722dda124b to your computer and use it in GitHub Desktop.
Save wabzqem/830af6e739ba772638175e722dda124b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
covidsafe sqlite schema
sqlite> .schema ZENCOUNTER
CREATE TABLE ZENCOUNTER (
Z_PK INTEGER PRIMARY KEY, Z_ENT INTEGER,
Z_OPT INTEGER, ZV INTEGER, ZRSSI FLOAT,
ZTIMESTAMP TIMESTAMP, ZTXPOWER FLOAT,
ZMODELC VARCHAR, ZMODELP VARCHAR,
ZMSG VARCHAR, ZORG VARCHAR
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment