```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 with 100% distinct, zero nulls; likely uniquely identifies each brief generation bundle" }, { "column": "brief_json", "label": "none", "confidence": 0.95, "reason": "JSON payload containing analysis results; data content, not a key" }, { "column": "model", "label": "none", "confidence": 0.9, "reason": "Attribute indicating which AI model generated the brief; descriptive metadata, not a key" }, { "column": "generated_at", "label": "none", "confidence": 0.95, "reason": "Timestamp of generation; temporal attribute, not a key" } ] } ```