"""
Database Schema Modules

Organizes all Empirica database table schemas into logical groups.
Each module contains CREATE TABLE statements for related tables.
"""

from .codebase_model_schema import SCHEMAS as CODEBASE_MODEL_SCHEMAS
from .concept_graph_schema import SCHEMAS as CONCEPT_GRAPH_SCHEMAS
from .epistemic_schema import SCHEMAS as EPISTEMIC_SCHEMAS
from .extended_schema import SCHEMAS as EXTENDED_SCHEMAS
from .goals_schema import SCHEMAS as GOALS_SCHEMAS
from .projects_schema import SCHEMAS as PROJECTS_SCHEMAS
from .sessions_schema import SCHEMAS as SESSIONS_SCHEMAS
from .tracking_schema import SCHEMAS as TRACKING_SCHEMAS
from .trajectory_schema import SCHEMAS as TRAJECTORY_SCHEMAS
from .verification_schema import SCHEMAS as VERIFICATION_SCHEMAS

# All schemas in execution order
ALL_SCHEMAS = (
    SESSIONS_SCHEMAS +
    EPISTEMIC_SCHEMAS +
    GOALS_SCHEMAS +
    PROJECTS_SCHEMAS +
    TRACKING_SCHEMAS +
    TRAJECTORY_SCHEMAS +
    CONCEPT_GRAPH_SCHEMAS +
    EXTENDED_SCHEMAS +
    VERIFICATION_SCHEMAS +
    CODEBASE_MODEL_SCHEMAS
)

__all__ = [
    'ALL_SCHEMAS',
    'CODEBASE_MODEL_SCHEMAS',
    'CONCEPT_GRAPH_SCHEMAS',
    'EPISTEMIC_SCHEMAS',
    'EXTENDED_SCHEMAS',
    'GOALS_SCHEMAS',
    'PROJECTS_SCHEMAS',
    'SESSIONS_SCHEMAS',
    'TRACKING_SCHEMAS',
    'TRAJECTORY_SCHEMAS',
    'VERIFICATION_SCHEMAS',
]
