metadata.db•28.7 kB
SQLite format 3 @ .�)
� �
F�
t � �&9+�uindexidx_operations_sessiondata_operationsCREATE INDEX idx_operations_session
ON data_operations (session_id, timestamp)
� --�oindexidx_sessions_apistorage_sessionsCREATE INDEX idx_sessions_api
ON storage_sessions (api_name, endpoint_name)
�o++�tabledata_operationsdata_operationsCREATE TABLE data_operations (
operation_id TEXT PRIMARY KEY,
session_id TEXT,
operation_type TEXT,
timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
records_affected INTEGER,
operation_details TEXT,
FOREIGN KEY (session_id) REFERENCES storage_sessions (session_id)
)=Q+ indexsqlite_autoindex_data_operations_1data_operations�n--�tablestorage_sessionsstorage_sessionsCREATE TABLE storage_sessions (
session_id TEXT PRIMARY KEY,
session_name TEXT NOT NULL,
description TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
api_name TEXT,
endpoint_name TEXT,
total_records INTEGER DEFAULT 0,
file_path TEXT,
status TEXT DEFAULT 'active'
)?S- indexsqlite_autoindex_storage_sessions_1storage_sessions