ONEDeFi MCP Server

SQLite format 3

@  
.� � �_��} A � ���\ //
�gtableprotocol_positionprotocol_position CREATE TABLE protocol_position ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, wallet_id INTEGER NOT NULL, protocol VARCHAR(64) NOT NULL, position_type VARCHAR(32) NOT NULL, token_address VARCHAR(256) NOT NULL, token_symbol VARCHAR(32) NOT NULL, amount VARCHAR(64) NOT NULL, apy FLOAT, rewards_earned VARCHAR(64), blockchain VARCHAR(32) NOT NULL, position_metadata JSON, created_at DATETIME, last_updated DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES user (id), FOREIGN KEY(wallet_id) REFERENCES wallet (id) )�5
�9tableportfolioportfolio CREATE TABLE portfolio ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, wallet_id INTEGER NOT NULL, token_address VARCHAR(256) NOT NULL, token_symbol VARCHAR(32) NOT NULL, balance VARCHAR(64) NOT NULL, usd_value FLOAT, blockchain VARCHAR(32) NOT NULL, last_updated DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES user (id), FOREIGN KEY(wallet_id) REFERENCES wallet (id) )�R##
�ktabletransactiontransactionCREATE TABLE "transaction" ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, wallet_id INTEGER NOT NULL, tx_hash VARCHAR(256) NOT NULL, blockchain VARCHAR(32) NOT NULL, operation_type VARCHAR(64) NOT NULL, protocol VARCHAR(64), amount VARCHAR(64), token_in VARCHAR(64), token_out VARCHAR(64), gas_used VARCHAR(64), status VARCHAR(32), tx_metadata JSON, created_at DATETIME, confirmed_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES user (id), FOREIGN KEY(wallet_id) REFERENCES wallet (id), UNIQUE (tx_hash) )5I#
indexsqlite_autoindex_transaction_1transaction�
�tablewalletwalletCREATE TABLE wallet ( id INTEGER NOT NULL, user_id INTEGER NOT NULL, address VARCHAR(256) NOT NULL, blockchain VARCHAR(32) NOT NULL, private_key_encrypted TEXT, created_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(user_id) REFERENCES user (id) )�

�tableuseruserCREATE TABLE user ( id INTEGER NOT NULL, username VARCHAR(64) NOT NULL, email VARCHAR(120) NOT NULL, api_key VARCHAR(256) NOT NULL, created_at DATETIME, is_active BOOLEAN, PRIMARY KEY (id), UNIQUE (username), UNIQUE (email), UNIQUE (api_key) )';
indexsqlite_autoindex_user_3user';
indexsqlite_autoindex_user_2user';
indexsqlite_autoindex_user_1user