deciduous 0.15.0

// Deciduous schema - Decision graph tables for Diesel ORM

diesel::table! {
    schema_versions (id) {
        id -> Integer,
        version -> Text,
        name -> Text,
        features -> Text,
        introduced_at -> Text,
    }
}

diesel::table! {
    decision_nodes (id) {
        id -> Integer,
        change_id -> Text,
        node_type -> Text,
        title -> Text,
        description -> Nullable<Text>,
        status -> Text,
        created_at -> Text,
        updated_at -> Text,
        metadata_json -> Nullable<Text>,
    }
}

diesel::table! {
    decision_edges (id) {
        id -> Integer,
        from_node_id -> Integer,
        to_node_id -> Integer,
        from_change_id -> Nullable<Text>,
        to_change_id -> Nullable<Text>,
        edge_type -> Text,
        weight -> Nullable<Double>,
        rationale -> Nullable<Text>,
        created_at -> Text,
    }
}

diesel::table! {
    decision_context (id) {
        id -> Integer,
        node_id -> Integer,
        context_type -> Text,
        content_json -> Text,
        captured_at -> Text,
    }
}

diesel::table! {
    decision_sessions (id) {
        id -> Integer,
        name -> Nullable<Text>,
        started_at -> Text,
        ended_at -> Nullable<Text>,
        root_node_id -> Nullable<Integer>,
        summary -> Nullable<Text>,
    }
}

diesel::table! {
    session_nodes (session_id, node_id) {
        session_id -> Integer,
        node_id -> Integer,
        added_at -> Text,
    }
}

diesel::table! {
    command_log (id) {
        id -> Integer,
        command -> Text,
        description -> Nullable<Text>,
        working_dir -> Nullable<Text>,
        exit_code -> Nullable<Integer>,
        stdout -> Nullable<Text>,
        stderr -> Nullable<Text>,
        started_at -> Text,
        completed_at -> Nullable<Text>,
        duration_ms -> Nullable<Integer>,
        decision_node_id -> Nullable<Integer>,
    }
}

// ============================================================================
// Roadmap Board Tables
// ============================================================================

diesel::table! {
    roadmap_items (id) {
        id -> Integer,
        change_id -> Text,
        title -> Text,
        description -> Nullable<Text>,
        section -> Nullable<Text>,
        parent_id -> Nullable<Integer>,
        checkbox_state -> Text,
        github_issue_number -> Nullable<Integer>,
        github_issue_state -> Nullable<Text>,
        outcome_node_id -> Nullable<Integer>,
        outcome_change_id -> Nullable<Text>,
        markdown_line_start -> Nullable<Integer>,
        markdown_line_end -> Nullable<Integer>,
        content_hash -> Nullable<Text>,
        created_at -> Text,
        updated_at -> Text,
        last_synced_at -> Nullable<Text>,
    }
}

diesel::table! {
    roadmap_sync_state (id) {
        id -> Integer,
        roadmap_path -> Text,
        roadmap_content_hash -> Nullable<Text>,
        github_repo -> Nullable<Text>,
        last_github_sync -> Nullable<Text>,
        last_markdown_parse -> Nullable<Text>,
        conflict_count -> Integer,
    }
}

diesel::table! {
    roadmap_conflicts (id) {
        id -> Integer,
        item_change_id -> Text,
        conflict_type -> Text,
        local_value -> Nullable<Text>,
        remote_value -> Nullable<Text>,
        resolution -> Nullable<Text>,
        detected_at -> Text,
        resolved_at -> Nullable<Text>,
    }
}

// ============================================================================
// GitHub Issue Cache - Local cache for web display
// ============================================================================

diesel::table! {
    github_issue_cache (id) {
        id -> Integer,
        issue_number -> Integer,
        repo -> Text,
        title -> Text,
        body -> Nullable<Text>,
        state -> Text,
        html_url -> Text,
        created_at -> Text,
        updated_at -> Text,
        cached_at -> Text,
    }
}

// ============================================================================
// Q&A Interactions - User questions and Claude responses
// ============================================================================

diesel::table! {
    qa_interactions (id) {
        id -> Integer,
        user_prompt -> Text,
        total_prompt -> Text,
        response -> Text,
        context_json -> Nullable<Text>,
        inserted_at -> Text,
        deleted_at -> Nullable<Text>,
    }
}

// ============================================================================
// Node Documents - File attachments on decision nodes
// ============================================================================

diesel::table! {
    node_documents (id) {
        id -> Integer,
        change_id -> Text,
        node_id -> Integer,
        node_change_id -> Text,
        content_hash -> Text,
        original_filename -> Text,
        storage_filename -> Text,
        mime_type -> Text,
        file_size -> Integer,
        description -> Nullable<Text>,
        description_source -> Text,
        attached_at -> Text,
        attached_by -> Nullable<Text>,
        detached_at -> Nullable<Text>,
    }
}

// ============================================================================
// Themes - Tagging system for decision nodes
// ============================================================================

diesel::table! {
    themes (id) {
        id -> Integer,
        change_id -> Text,
        name -> Text,
        color -> Text,
        description -> Nullable<Text>,
        created_at -> Text,
        updated_at -> Text,
    }
}

diesel::table! {
    node_themes (node_id, theme_id) {
        node_id -> Integer,
        theme_id -> Integer,
        source -> Text,
        created_at -> Text,
    }
}