Database

Data Types

Reference Data

• Static lookup values that rarely change
• Examples: Countries, currencies, units of measure, status codes
• Should be in versioned Flyway migrations (V__)

Seed Data

• Minimal data needed for application to function
• Examples: Admin user, default settings, initial categories
• Should be in versioned Flyway migrations (V__)

Test Data

• Sample data for development/testing purposes only
• Examples: Test users, sample products, fake transactions
• Should be in repeatable migrations (R__) or separate scripts

Transactional/Business Data

• Day-to-day data created during normal operation
• Examples: Customer orders, user-generated content, logs
• Should NOT be in Flyway migrations (use separate processes)

Flyway

• Repeatable migrations (R__)
• Versioned migrations (V__)
• Seed migrations (S__)