backend/docs/SQLITE_SCHEMA_REPORT.md

🗄️ AEGISLM SQLITE DATABASE SCHEMA REPORT

Generated: 1217482.4338763

📊 TABLE SUMMARY

📋 analytics

• Records: 0
• Columns: 10
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• user_id INTEGER NULL
• event_type TEXT NOT NULL
• event_data TEXT NULL
• session_id TEXT NULL
• ip_address TEXT NULL
• user_agent TEXT NULL
• timestamp DATETIME NULL
• metadata TEXT NULL

📋 api_keys

• Records: 0
• Columns: 13
• Schema:
• id INTEGER NULL PRIMARY KEY
• key_name VARCHAR(255) NOT NULL
• key_prefix VARCHAR(255) NOT NULL
• user_id INTEGER NOT NULL
• is_active BOOLEAN NOT NULL
• expires_at TIMESTAMP NULL
• last_used_at TIMESTAMP NULL
• usage_count INTEGER NOT NULL
• rate_limit_per_minute INTEGER NOT NULL
• permissions TEXT NULL
• scope VARCHAR(255) NOT NULL
• created_at TIMESTAMP NOT NULL
• updated_at TIMESTAMP NOT NULL

📋 audit_trails

• Records: 0
• Columns: 17
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• experiment_id TEXT NULL
• user_id INTEGER NULL
• action TEXT NOT NULL
• entity_type TEXT NULL
• entity_id TEXT NULL
• old_values TEXT NULL
• new_values TEXT NULL
• config_hash TEXT NULL
• result_checksum TEXT NULL
• deterministic_seed INTEGER NULL
• timestamp DATETIME NULL
• ip_address TEXT NULL
• user_agent TEXT NULL
• session_id TEXT NULL
• metadata TEXT NULL

📋 benchmarks

• Records: 0
• Columns: 17
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• name TEXT NOT NULL
• description TEXT NULL
• dataset_type TEXT NULL
• dataset_version TEXT NULL
• models TEXT NOT NULL
• metrics TEXT NULL
• results TEXT NULL
• created_by INTEGER NULL
• created_at DATETIME NULL
• updated_at DATETIME NULL
• is_public BOOLEAN NULL
• status TEXT NULL
• tags TEXT NULL
• metadata TEXT NULL
• leaderboard TEXT NULL

📋 datasets

• Records: 0
• Columns: 21
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• name TEXT NOT NULL
• description TEXT NULL
• type TEXT NOT NULL
• version TEXT NOT NULL
• file_path TEXT NULL
• file_size INTEGER NULL
• file_hash TEXT NULL
• format TEXT NULL
• schema TEXT NULL
• statistics TEXT NULL
• created_by INTEGER NULL
• created_at DATETIME NULL
• updated_at DATETIME NULL
• is_public BOOLEAN NULL
• download_count INTEGER NULL
• tags TEXT NULL
• metadata TEXT NULL
• quality_score REAL NULL
• validation_status TEXT NULL

📋 evaluations

• Records: 0
• Columns: 18
• Schema:
• id INTEGER NULL PRIMARY KEY
• user_id INTEGER NOT NULL
• job_id VARCHAR(255) NOT NULL
• status VARCHAR(50) NOT NULL
• model_config TEXT NOT NULL
• pipeline_config TEXT NOT NULL
• result_json TEXT NULL
• error_message TEXT NULL
• experiment_run_id VARCHAR(255) NULL
• total_attacks INTEGER NOT NULL
• successful_attacks INTEGER NOT NULL
• success_rate VARCHAR(50) NOT NULL
• execution_time_ms INTEGER NULL
• progress TEXT NULL
• created_at TIMESTAMP NOT NULL
• updated_at TIMESTAMP NOT NULL
• started_at TIMESTAMP NULL
• completed_at TIMESTAMP NULL

📋 experiments

• Records: 2
• Columns: 25
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• run_id TEXT NOT NULL
• experiment_name TEXT NOT NULL
• description TEXT NULL
• config_snapshot TEXT NOT NULL
• status TEXT NULL
• priority INTEGER NULL
• created_by INTEGER NULL
• created_at DATETIME NULL
• updated_at DATETIME NULL
• started_at DATETIME NULL
• completed_at DATETIME NULL
• dataset_type TEXT NULL
• dataset_version TEXT NULL
• model_name TEXT NULL
• parameters TEXT NULL
• results TEXT NULL
• metrics TEXT NULL
• error_message TEXT NULL
• retry_count INTEGER NULL
• max_retries INTEGER NULL
• tags TEXT NULL
• is_public BOOLEAN NULL
• archived_at DATETIME NULL

📋 invoices

• Records: 0
• Columns: 18
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• user_id INTEGER NULL
• subscription_id INTEGER NULL
• stripe_invoice_id TEXT NULL
• number TEXT NULL
• status TEXT NULL
• amount REAL NOT NULL
• currency TEXT NULL
• due_date DATETIME NULL
• paid_at DATETIME NULL
• created_at DATETIME NULL
• updated_at DATETIME NULL
• description TEXT NULL
• line_items TEXT NULL
• metadata TEXT NULL
• attempt_count INTEGER NULL
• next_payment_attempt DATETIME NULL

📋 notifications

• Records: 0
• Columns: 13
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• user_id INTEGER NULL
• type TEXT NOT NULL
• title TEXT NOT NULL
• message TEXT NOT NULL
• data TEXT NULL
• is_read BOOLEAN NULL
• created_at DATETIME NULL
• read_at DATETIME NULL
• expires_at DATETIME NULL
• priority TEXT NULL
• channels TEXT NULL

📋 payment_methods

• Records: 0
• Columns: 13
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• user_id INTEGER NULL
• stripe_payment_method_id TEXT NULL
• type TEXT NOT NULL
• brand TEXT NULL
• last4 TEXT NULL
• exp_month INTEGER NULL
• exp_year INTEGER NULL
• is_default BOOLEAN NULL
• created_at DATETIME NULL
• updated_at DATETIME NULL
• metadata TEXT NULL

📋 permissions

• Records: 0
• Columns: 9
• Schema:
• id INTEGER NULL PRIMARY KEY
• name VARCHAR(255) NOT NULL
• slug VARCHAR(255) NOT NULL
• description TEXT NULL
• resource VARCHAR(255) NOT NULL
• action VARCHAR(255) NOT NULL
• is_active BOOLEAN NOT NULL
• created_at TIMESTAMP NOT NULL
• updated_at TIMESTAMP NOT NULL

📋 role_permissions

• Records: 0
• Columns: 3
• Schema:
• role_id INTEGER NOT NULL PRIMARY KEY
• permission_id INTEGER NOT NULL
• created_at DATETIME NOT NULL

📋 roles

• Records: 0
• Columns: 9
• Schema:
• id INTEGER NULL PRIMARY KEY
• name VARCHAR(255) NOT NULL
• slug VARCHAR(255) NOT NULL
• description TEXT NULL
• level INTEGER NOT NULL
• is_active BOOLEAN NOT NULL
• is_system BOOLEAN NOT NULL
• created_at TIMESTAMP NOT NULL
• updated_at TIMESTAMP NOT NULL

📋 subscriptions

• Records: 0
• Columns: 18
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• user_id INTEGER NULL
• plan_name TEXT NOT NULL
• stripe_subscription_id TEXT NULL
• status TEXT NULL
• current_period_start DATETIME NULL
• current_period_end DATETIME NULL
• trial_end DATETIME NULL
• canceled_at DATETIME NULL
• created_at DATETIME NULL
• updated_at DATETIME NULL
• amount REAL NULL
• currency TEXT NULL
• interval TEXT NULL
• interval_count INTEGER NULL
• metadata TEXT NULL
• auto_renew BOOLEAN NULL

📋 system_logs

• Records: 0
• Columns: 14
• Schema:
• id INTEGER NULL PRIMARY KEY
• uuid TEXT NOT NULL
• level TEXT NOT NULL
• message TEXT NOT NULL
• module TEXT NULL
• function TEXT NULL
• line_number INTEGER NULL
• stack_trace TEXT NULL
• user_id INTEGER NULL
• session_id TEXT NULL
• ip_address TEXT NULL
• user_agent TEXT NULL
• timestamp DATETIME NULL
• metadata TEXT NULL

📋 user_roles

• Records: 0
• Columns: 2
• Schema:
• user_id INTEGER NOT NULL PRIMARY KEY
• role_id INTEGER NOT NULL

📋 users

• Records: 2
• Columns: 19
• Schema:
• id INTEGER NULL PRIMARY KEY
• email VARCHAR(255) NOT NULL
• password_hash VARCHAR(255) NOT NULL
• full_name VARCHAR(255) NULL
• company VARCHAR(255) NULL
• is_active BOOLEAN NOT NULL
• is_verified BOOLEAN NOT NULL
• is_superuser BOOLEAN NOT NULL
• verified_at TIMESTAMP NULL
• created_at TIMESTAMP NOT NULL
• updated_at TIMESTAMP NOT NULL
• last_login_at TIMESTAMP NULL
• stripe_customer_id TEXT NULL
• phone TEXT NULL
• avatar_url TEXT NULL
• preferences TEXT NULL
• metadata TEXT NULL
• subscription_id INTEGER NULL
• is_premium BOOLEAN NULL

📈 SUMMARY

• Total Tables: 17
• Total Records: 4
• Database Engine: SQLite
• Status: ✅ Integrated and Functional