SQLite format 3@  .K‘ W ‚Ëžq ¹ ‚n C„U %%ˆmtabletransactionstransactionsCREATE TABLE transactions ( id INTEGER PRIMARY KEY, trans_type TEXT NOT NULL, asset_id INTEGER, cash_amount REAL NOT NULL, cash_currency TEXT NOT NULL, cash_date TEXT NOT NULL, related_trans INTEGER, position REAL, note TEXT, time_stamp INTEGER NOT NULL, FOREIGN KEY(asset_id) REFERENCES assets(id), FOREIGN KEY(related_trans) REFERENCES transactions(id) )R++‚[tablerounding_digitsrounding_digits CREATE TABLE rounding_digits ( id INTEGER PRIMARY KEY, currency TEXT NOT NULL UNIQUE, digits INT NOT NULL )= Q+indexsqlite_autoindex_rounding_digits_1rounding_digits ‚4„CtablequotesquotesCREATE TABLE quotes ( id INTEGER PRIMARY KEY, ticker_id INTEGER NOT NULL, price REAL NOT NULL, time TEXT NOT NULL, volume REAL, FOREIGN KEY(ticker_id) REFERENCES ticker(id) )ƒ†tabletickertickerCREATE TABLE ticker ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, asset_id INTEGER NOT NULL, source TEXT NOT NULL, priority INTEGER NOT NULL, currency TEXT NOT NULL, factor REAL NOT NULL DEFAULT 1.0, FOREIGN KEY(asset_id) REFERENCES assets(id) )ø+lƒ3tableassetsassetsCREATE TABLE assets ( id INTEGER PRIMARY KEY, name TEXT NOT NULL UNIQUE, wkn TEXT UNIQUE, isin TEXT UNIQUE, note TEXT )+?indexsqlite_autoindex_assets_3assets+?indexsqlite_autoindex_assets_2assets+?indexsqlite_autoindex_assets_1assets