> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/surveys/fairing/schema-information.md).

# Schema Information

## Tables/APIs 

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

* [Questions](#questions) 
* [Responses](#responses)

#### Questions 

Allows you to programmatically retrieve your questions and response data. 

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>