Function print_tables_info

crates/ccql/src/main.rs:364–459

(config: &Config)

}

fn print_tables_info(config: &Config) {
    let history_exists = config.history_file().exists();
    let jhistory_exists = config.jhistory_file().exists();
    let transcripts_exists = config.projects_dir().exists() || config.transcripts_dir().exists();
    let todos_exists = config.todos_dir().exists();

    println!("TABLES");
    println!("══════════════════════════════════════════════════════════════════════════════\n");

    // history
    let status = if history_exists { "✓" } else { "✗" };
    println!(
        "{} history                       {}",
        status,
        config.history_file().display()
    );
    println!("  ├── display        TEXT         The prompt text you typed");
    println!("  ├── timestamp      INTEGER      Unix timestamp (milliseconds)");
    println!("  ├── project        TEXT         Project directory path");
    println!("  └── pastedContents OBJECT       Pasted content (JSON)\n");

    // jhistory
    let status = if jhistory_exists { "✓" } else { "✗" };
    println!(
        "{} jhistory                     {}",
        status,
        config.jhistory_file().display()
    );
    println!("  ├── display        TEXT         Prompt text (normalized from text)");
    println!("  ├── timestamp      INTEGER      Unix timestamp (milliseconds)");
    println!("  ├── session_id     TEXT         Codex session id");
    println!("  ├── text           TEXT         Raw prompt text");
    println!("  └── ts             INTEGER      Raw Unix timestamp (seconds)\n");
    println!("  Alias: codex_history\n");

    // transcripts
    let status = if transcripts_exists { "✓" } else { "✗" };
    println!(
        "{} transcripts                   {}",
        status,
        config.projects_dir().display()
    );
    println!("  ├── _source_file   TEXT         Source file name");
    println!("  ├── _session_id    TEXT         Session ID (parent session for subagents)");
    println!("  ├── _project       TEXT         Project slug dir (NULL for legacy files)");
    println!("  ├── _agent_id      TEXT         Subagent file stem (NULL otherwise)");
    println!("  ├── type           TEXT         'user' | 'assistant' | 'tool_use' | …");
    println!("  ├── timestamp      TEXT         ISO 8601 timestamp");
    println!("  ├── message        OBJECT       Message incl. usage/cache tokens");
    println!("  ├── content        TEXT         Message text (type='user')");
    println!("  ├── tool_name      TEXT         Tool name (type='tool_*')");
    println!("  ├── tool_input     OBJECT       Tool parameters");
    println!("  ├── tool_output    OBJECT       Tool response (type='tool_result')");
    println!("  ├── model          TEXT         Model id (assistant rows)");
    println!("  └── usage_*        INTEGER/TEXT Flattened message.usage token columns\n");

    // sessions
    let status = if transcripts_exists { "✓" } else { "✗" };