MukeshKapoor25's picture
refactor(database): reorganize database scripts and examples into docs directory
f24ee1d
# Documentation Organization
This directory contains the documentation for the Cuatrolabs SCM Microservice, organized by topic.
## Structure
- **api-guides/**: Contains API reference guides, integration workflows, and endpoint documentation.
- **database/**: Contains database schema definitions, migration guides, SQL scripts, and migration tools.
- `migrations/`: Python and SQL migration scripts.
- `sql/`: Stored procedures and raw SQL files.
- **examples/**: Contains example scripts, data generation tools, test scripts, and usage examples.
- **implementation-summaries/**: Contains general implementation summaries, architectural overviews, and feature documentation.
- **security/**: Contains all JWT, authentication, and security-related documentation.
- **testing/**: Contains test results, reports, and testing documentation.
## Directory Contents Highlights
### API Guides
- `CATALOGUE_API_QUICK_REFERENCE.md`
- `EMPLOYEE_API_ENDPOINTS.md`
- `MERCHANT_KYC_WORKFLOW.md`
### Database
- `POSTGRES_DB.md`: Database schema documentation.
- `DATA_MIGRATION_SUMMARY.md`: Summary of data migration efforts.
- `SCHEMA_MIGRATION_SUMMARY.md`: Schema changes summary.
- `FOREIGN_KEY_FIXES_SUMMARY.md`: FK fixes documentation.
### Implementation Summaries
- `IMPLEMENTATION_SUMMARY.md`: End-to-end implementation summary.
- `INVENTORY_CONTROL_IMPLEMENTATION.md`
- `PRICING_LEVELS_COMPLETE_SOLUTION.md`
- `TRADE_SALES_IMPLEMENTATION.md`
### Examples
- Data generation scripts (`create_*.py`)
- Verification scripts (`verify_*.py`)
- Test scripts (`test_*.py`)
- Sample data (`*.json`)
### Security
- `ACCESS_ROLES_README.md`
- `API_STANDARDS.md`
- `AUTH_MIGRATION.md`
### Testing
- `MERCHANT_CATALOGUE_TEST_RESULTS.md`
- `PO_CREATION_TEST_REPORT.md`