Imported from oyi77/AlgoExpertHub (main/database/AGENTS.md). Install upstream with npx skills add oyi77/AlgoExpertHub --skill database. Copyright stays with the author.

Database

Purpose

All database schema definitions, test/demo data, and raw SQL scripts. Contains 80 migrations spanning the full application schema (users, signals, plans, payments, trading, analytics, addons), 44 seeders for populating demo and configuration data, and factories for test data generation.

Key Files

Subdirectories

For AI Agents

Working In This Directory

• Always check seeder dependency order in DatabaseSeeder.php before adding new seeders
• Addon seeders use conditional loading: class_exists() + AddonRegistry::active() wrapped in try/catch
• Migration timestamps span 2021-2025 -- new migrations should use current timestamp
• Factories follow Laravel convention: ModelNameFactory::class with states for variants
• The factories/Addons/ subdirectory contains addon-specific factory classes

Common Patterns

• Migrations use Schema::create() with id(), timestamps(), softDeletes() where applicable
• Foreign keys use ->constrained()->cascadeOnDelete() pattern
• Seeders extend Illuminate\Database\Seeder and use $this->call() for chaining
• Factories use HasFactory trait on models, invoked via Model::factory()->create()
• JSON columns used for flexible metadata fields (signal data, configuration values)

Dependencies

Internal

• app/Models/ -- Every migration corresponds to a model; factories reference models
• app/Support/AddonRegistry.php -- Conditional addon seeder activation
• addons/*/database/ -- Addon-specific migrations and seeders

External

• laravel/framework -- Migration, seeder, factory base classes
• spatie/laravel-permission -- Permission tables migration
• Database engine: MySQL/MariaDB (based on JSON column usage and engine-specific features)