Given an LLM output and a list of sources, return the count of matches for each source.
Use output_id = 1 for the requested LLM output. Include every source associated with that output, including sources with no matches.
source_id, source_name, and match_count.source_id ascending.| Column | Type | Description |
|---|---|---|
| output_idPK | INT | Identifier of the LLM output |
| output_text | TEXT | Generated LLM response text |
| Column | Type | Description |
|---|---|---|
| source_idPK | INT | Identifier of the source |
| output_id | INT | LLM output whose source list contains this source |
| source_name | VARCHAR(150) | Display name of the source |
| locator | VARCHAR(255) | URL, document path, or citation locator |
| Column | Type | Description |
|---|---|---|
| match_idPK | INT | Identifier of a detected source match |
| output_id | INT | LLM output containing the match |
| source_id | INT | Source associated with the match |
| match_excerpt | TEXT | Excerpt showing the detected match |