| # 🗄️ 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 | |