```json { "classifications": [ { "column": "dataset_id", "label": "foreign_key", "confidence": 0.85, "reason": "References a dataset entity; naming convention (d_ prefix) and low cardinality suggest foreign key to datasets table" }, { "column": "batch_id", "label": "foreign_key", "confidence": 0.8, "reason": "References a batch entity; naming convention (batch_ prefix) suggests foreign key to batches table" }, { "column": "bundle_hash", "label": "primary_key", "confidence": 0.7, "reason": "Hash value appears to uniquely identify briefs; 100% distinct with no nulls in sample, though only 1 row limits certainty" }, { "column": "brief_json", "label": "none", "confidence": 0.95, "reason": "JSON payload containing brief content; data attribute, not a key" }, { "column": "model", "label": "none", "confidence": 0.95, "reason": "Model name attribute; descriptive field, not a key" }, { "column": "generated_at", "label": "none", "confidence": 0.95, "reason": "Timestamp attribute; temporal metadata, not a key" } ] } ```