---
description: >-
  This subtopic provides a structured reference to assist you in working with
  Daton's Fairing connector and the associated fields and tables.
---

# Schema Information

## Tables/APIs&#x20;

The following is the list of tables or APIs associated with the Fairing connector:

* [Questions](#questions)&#x20;
* [Responses](#responses)

#### Questions&#x20;

Allows you to programmatically retrieve your questions and response data.&#x20;

For more information, see [Fairing - Questions](https://docs.fairing.co/reference/question-object).

**FIELDS**

<table><thead><tr><th width="391.27816091954026">Field Name</th><th width="404">Data Type</th></tr></thead><tbody><tr><td>allow_other</td><td>BOOLEAN</td></tr><tr><td>customer_type</td><td>STRING</td></tr><tr><td>frequency_type</td><td>STRING</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>inserted_at</td><td>TIMESTAMP</td></tr><tr><td>other_placeholder</td><td>STRING</td></tr><tr><td>prompt</td><td>STRING</td></tr><tr><td>published_at</td><td>TIMESTAMP</td></tr><tr><td>randomize_responses</td><td>BOOLEAN</td></tr><tr><td>responses</td><td>RECORD</td></tr><tr><td>submit_text</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>updated_at</td><td>TIMESTAMP</td></tr></tbody></table>

#### Responses

The Fairing API Responses asks survey questions after purchase to collect information directly from the user. This helps to avoid the issue of lost or missing attribution.

For more information, see [Fairing - Responses](https://docs.fairing.co/reference/the-response-object).

**FIELDS**

<table><thead><tr><th width="403.3835616438356">Field Name</th><th width="382">Data Type</th></tr></thead><tbody><tr><td>utm_source</td><td>STRING</td></tr><tr><td>customer_id</td><td>STRING</td></tr><tr><td>inserted_at</td><td>TIMESTAMP</td></tr><tr><td>order_currency_code</td><td>STRING</td></tr><tr><td>response</td><td>STRING</td></tr><tr><td>order_total</td><td>STRING</td></tr><tr><td>order_id</td><td>STRING</td></tr><tr><td>clarification_question</td><td>BOOLEAN</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>order_platform</td><td>STRING</td></tr><tr><td>response_id</td><td>NUMERIC</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>other</td><td>BOOLEAN</td></tr><tr><td>order_total_usd</td><td>STRING</td></tr><tr><td>utm_medium</td><td>STRING</td></tr><tr><td>order_source</td><td>STRING</td></tr><tr><td>customer_order_count</td><td>NUMERIC</td></tr><tr><td>order_number</td><td>STRING</td></tr><tr><td>available_responses</td><td>STRING</td></tr><tr><td>referring_site</td><td>STRING</td></tr><tr><td>updated_at</td><td>TIMESTAMP</td></tr><tr><td>question_type</td><td>STRING</td></tr><tr><td>submit_delta</td><td>NUMERIC</td></tr><tr><td>response_provided_at</td><td>TIMESTAMP</td></tr><tr><td>question_id</td><td>NUMERIC</td></tr><tr><td>question</td><td>STRING</td></tr><tr><td>response_position</td><td>NUMERIC</td></tr><tr><td>referring_question</td><td>STRING</td></tr><tr><td>referring_question_response</td><td>STRING</td></tr><tr><td>referring_question_response_id</td><td>NUMERIC</td></tr><tr><td>referring_question_id</td><td>NUMERIC</td></tr><tr><td>coupon_amount</td><td>STRING</td></tr><tr><td>coupon_type</td><td>STRING</td></tr><tr><td>coupon_code</td><td>STRING</td></tr><tr><td>other_response</td><td>STRING</td></tr></tbody></table>
