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