submission_id | string | Yes | Stable ID for the submission (e.g. response_id, ticket_id, order_id). Used for idempotent re-imports. |
collected_at | timestamp | Yes | When the feedback was originally collected. |
source_type | string | Yes | The kind of source (e.g. survey, csv, review). |
field_id | string | Yes | Stable identifier for the question/field. |
field_type | enum | Yes | One of text, categorical, nps, csat, ces, rating, number, boolean, date. |
tenant_id | string | No | Feedback Directory ID. Set automatically when ingesting. |
source_id | string | No | Reference to the survey/form/ticket/review ID. |
source_name | string | No | Human-readable source name for display. |
field_label | string | No | The question text or field label. |
field_group_id | string | No | Groups related fields (matrix, ranking, grid questions). |
field_group_label | string | No | Human-readable group label. |
value_text | string | No | Text responses. |
value_number | float64 | No | Numeric responses (ratings, NPS, CSAT). |
value_boolean | boolean | No | Yes/no responses. |
value_date | timestamp | No | Date responses. |
metadata | jsonb | No | Free-form context (device, campaign, custom fields). |
language | string | No | ISO 639-1 language code (en, de, fr, …). |
user_id | string | No | Anonymous user ID. Never store PII here. |