Skip to content

Latest commit

 

History

History
50 lines (41 loc) · 1.51 KB

db_folders.md

File metadata and controls

50 lines (41 loc) · 1.51 KB

Database Folders Structure

database/
├── migrations/
├── seeds/
├── procedures/
│   ├── validation/
│   ├── backup/
│   └── monitoring/
├── functions/
├── views/
├── triggers/
├── backups/
│   ├── full/
│   └── incremental/
└── scripts/

  1. migrations/ Contains numbered SQL scripts for database schema changes. Helps track database version and changes over time. Makes it easy to upgrade or rollback database changes.

  2. seeds/ Contains initial data for the database. Includes default settings, test data, and required initial records. Helps quickly set up a new instance of the database.

  3. procedures/ Organized by function (validation, backup, monitoring). Contains all stored procedures. Separated into logical groups for better maintenance.

  4. functions/ Contains MySQL functions. Focused on reusable database operations. Helps maintain consistent business logic.

  5. views/ Contains database views for commonly used queries. Helps simplify complex queries. Provides consistent data access patterns.

  6. triggers/ Contains database triggers. Handles automated actions on data changes. Maintains data integrity and consistency.

  7. backups/ Organized structure for database backups. Separates full and incremental backups. Includes README files with backup procedures.

  8. scripts/ Contains shell scripts for database operations. Helps automate common tasks. Provides consistent maintenance procedures.