database/README.md

Database Module

This module contains the schemas, configuration models, and migration scripts for the Cognitive Voice Intelligence Platform relational database.

---

📁 Folder Structure

database/
├── README.md               # This documentation
├── schema.sql              # Raw SQL definitions of tables and indices
├── alembic.ini             # Alembic migration settings (future tool configuration)
└── models/                 # SQLAlchemy models
    ├── __init__.py         # Package exports
    ├── session.py          # Session and workflow tables
    ├── audio.py            # Audio metadata file tracking
    ├── analytics.py        # Temporal & Linguistic analytics
    └── risk.py             # Calculated Cognitive Risk scores

---

🛠️ Schema Initialization

For local testing, you can execute the raw schema.sql directly:

psql -U postgres -d cognitive_voice_db -f database/schema.sql

For SQLAlchemy ORM applications, tables can be initialized programmatically using the developer helper script:

python scripts/db_init.py

For production environments, database updates must be managed using Alembic.