> 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/ecommerce/bigcommerce-v2/schema-information.md).

# Schema Information

## Tables/APIs 

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

* [Banners](#banners) 
* [Brands](#brands) 
* [Catalog](#catalog) 
* [Categories](#categories) 
* [Coupons](#coupons) 
* [Orders](#orders) 
* [Pricelists](#pricelists) 
* [Product\_images](#product_images) 
* [Product\_reviews](#product_reviews) 
* [Product\_variants](#product_variants) 
* [Products](#products) 
* [Storecurrency](#storecurrency) 
* [Subscribers](#subscribers)

#### Banners 

Retrieves the list of drafted banners associated with the BigCommerce store. For more information on the API, see [BigCommerce v2- banners.](https://developer.bigcommerce.com/docs/rest-content/marketing/banners) 

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>content</td><td>STRING</td></tr><tr><td>page</td><td>STRING</td></tr><tr><td>item_id</td><td>STRING</td></tr><tr><td>location</td><td>STRING</td></tr><tr><td>date_created</td><td>STRING</td></tr><tr><td>date_type</td><td>STRING</td></tr><tr><td>date_from</td><td>STRING</td></tr><tr><td>date_to</td><td>STRING</td></tr><tr><td>visible</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Brands &#x20;

Allows you to create, modify, and delete individual brands linked with the products in your BigCommerce store. For more information on the API, see [BigCommerce v2- brands.](https://developer.bigcommerce.com/docs/rest-catalog/brands)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>page_title</td><td>STRING</td></tr><tr><td>meta_keywords</td><td>STRING</td></tr><tr><td>meta_description</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>search_keywords</td><td>STRING</td></tr><tr><td>custom_url</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Catalog&#x20;

Helps to retrieve details such as MPN, warranty, price, and images for each product. The Catalog encompasses a store's assortment of physical and digital products. For more information on the API, see [BigCommerce v2- catalog.](https://developer.bigcommerce.com/docs/rest-catalog#catalog-endpoints)&#x20;

**Fields**

<table><thead><tr><th width="198">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>cost_price</td><td>NUMERIC</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>sale_price</td><td>NUMERIC</td></tr><tr><td>retail_price</td><td>NUMERIC</td></tr><tr><td>weight</td><td>NUMERIC</td></tr><tr><td>width</td><td>NUMERIC</td></tr><tr><td>height</td><td>NUMERIC</td></tr><tr><td>depth</td><td>NUMERIC</td></tr><tr><td>is_free_shipping</td><td>BOOLEAN</td></tr><tr><td>fixed_cost_shipping_price</td><td>NUMERIC</td></tr><tr><td>purchasing_disabled</td><td>BOOLEAN</td></tr><tr><td>purchasing_disabled_message</td><td>STRING</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>inventory_level</td><td>NUMERIC</td></tr><tr><td>inventory_warning_level</td><td>NUMERIC</td></tr><tr><td>bin_picking_number</td><td>STRING</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>sku_id</td><td>NUMERIC</td></tr><tr><td>option_values</td><td>RECORD</td></tr><tr><td>calculated_price</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>map_price</td><td>NUMERIC</td></tr><tr><td>calculated_weight</td><td>NUMERIC</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>mpn</td><td>STRING</td></tr><tr><td>gtin</td><td>STRING</td></tr></tbody></table>

#### Categories&#x20;

Allows a BigCommerce store owner to create, modify, and delete categories. For more information on the API, see [BigCommerce v2- categories.](https://developer.bigcommerce.com/docs/rest-catalog/categories)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>parent_id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>views</td><td>NUMERIC</td></tr><tr><td>sort_order</td><td>NUMERIC</td></tr><tr><td>page_title</td><td>STRING</td></tr><tr><td>meta_keywords</td><td>STRING</td></tr><tr><td>meta_description</td><td>STRING</td></tr><tr><td>layout_file</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>is_visible</td><td>BOOLEAN</td></tr><tr><td>search_keywords</td><td>STRING</td></tr><tr><td>default_product_sort</td><td>STRING</td></tr><tr><td>custom_url</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Coupons&#x20;

Assists in retrieving data linked to a category or product discounts that can be applied to orders for consumers who input a specific code for a specific BigCommerce store. For more information on the API, see [BigCommerce v2- coupons.](https://developer.bigcommerce.com/docs/rest-content/marketing/coupons)&#x20;

**Fields**

<table><thead><tr><th width="164">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>amount</td><td>STRING</td></tr><tr><td>min_purchase</td><td>STRING</td></tr><tr><td>expires</td><td>STRING</td></tr><tr><td>enabled</td><td>BOOLEAN</td></tr><tr><td>code</td><td>STRING</td></tr><tr><td>applies_to</td><td>RECORD</td></tr><tr><td>num_uses</td><td>NUMERIC</td></tr><tr><td>max_uses</td><td>NUMERIC</td></tr><tr><td>max_uses_per_customer</td><td>NUMERIC</td></tr><tr><td>restricted_to</td><td>RECORD</td></tr><tr><td>shipping_methods</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Orders&#x20;

Retrieves the data of creating, updating, and deleting orders along with order shipments and order shipping addresses for a BigCommerce store. For more information on the API, see [BigCommerce v2- orders.](https://developer.bigcommerce.com/docs/rest-management/orders)&#x20;

**Fields**

<table><thead><tr><th width="304">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>customer_id</td><td>NUMERIC</td></tr><tr><td>date_created</td><td>DATETIME</td></tr><tr><td>date_modified</td><td>DATETIME</td></tr><tr><td>date_shipped</td><td>STRING</td></tr><tr><td>status_id</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>subtotal_ex_tax</td><td>STRING</td></tr><tr><td>subtotal_inc_tax</td><td>STRING</td></tr><tr><td>subtotal_tax</td><td>STRING</td></tr><tr><td>base_shipping_cost</td><td>STRING</td></tr><tr><td>shipping_cost_ex_tax</td><td>STRING</td></tr><tr><td>shipping_cost_inc_tax</td><td>STRING</td></tr><tr><td>shipping_cost_tax</td><td>STRING</td></tr><tr><td>shipping_cost_tax_class_id</td><td>NUMERIC</td></tr><tr><td>base_handling_cost</td><td>STRING</td></tr><tr><td>handling_cost_ex_tax</td><td>STRING</td></tr><tr><td>handling_cost_inc_tax</td><td>STRING</td></tr><tr><td>handling_cost_tax</td><td>STRING</td></tr><tr><td>handling_cost_tax_class_id</td><td>NUMERIC</td></tr><tr><td>base_wrapping_cost</td><td>STRING</td></tr><tr><td>wrapping_cost_ex_tax</td><td>STRING</td></tr><tr><td>wrapping_cost_inc_tax</td><td>STRING</td></tr><tr><td>wrapping_cost_tax</td><td>STRING</td></tr><tr><td>wrapping_cost_tax_class_id</td><td>NUMERIC</td></tr><tr><td>total_ex_tax</td><td>STRING</td></tr><tr><td>total_inc_tax</td><td>STRING</td></tr><tr><td>total_tax</td><td>STRING</td></tr><tr><td>items_total</td><td>NUMERIC</td></tr><tr><td>items_shipped</td><td>NUMERIC</td></tr><tr><td>payment_method</td><td>STRING</td></tr><tr><td>payment_status</td><td>STRING</td></tr><tr><td>refunded_amount</td><td>STRING</td></tr><tr><td>order_is_digital</td><td>BOOLEAN</td></tr><tr><td>store_credit_amount</td><td>STRING</td></tr><tr><td>gift_certificate_amount</td><td>STRING</td></tr><tr><td>ip_address</td><td>STRING</td></tr><tr><td>ip_address_v6</td><td>STRING</td></tr><tr><td>geoip_country</td><td>STRING</td></tr><tr><td>geoip_country_iso2</td><td>STRING</td></tr><tr><td>currency_id</td><td>NUMERIC</td></tr><tr><td>currency_code</td><td>STRING</td></tr><tr><td>currency_exchange_rate</td><td>STRING</td></tr><tr><td>default_currency_id</td><td>NUMERIC</td></tr><tr><td>default_currency_code</td><td>STRING</td></tr><tr><td>staff_notes</td><td>STRING</td></tr><tr><td>customer_message</td><td>STRING</td></tr><tr><td>discount_amount</td><td>STRING</td></tr><tr><td>coupon_discount</td><td>STRING</td></tr><tr><td>shipping_address_count</td><td>NUMERIC</td></tr><tr><td>is_deleted</td><td>BOOLEAN</td></tr><tr><td>ebay_order_id</td><td>STRING</td></tr><tr><td>billing_address</td><td>RECORD</td></tr><tr><td>is_email_opt_in</td><td>BOOLEAN</td></tr><tr><td>order_source</td><td>STRING</td></tr><tr><td>channel_id</td><td>NUMERIC</td></tr><tr><td>products</td><td>RECORD</td></tr><tr><td>shipping_addresses</td><td>RECORD</td></tr><tr><td>coupons</td><td>RECORD</td></tr><tr><td>tax_provider_id</td><td>STRING</td></tr><tr><td>customer_locale</td><td>STRING</td></tr><tr><td>external_order_id</td><td>STRING</td></tr><tr><td>store_default_currency_code</td><td>STRING</td></tr><tr><td>store_default_to_transactional_exchange_rate</td><td>STRING</td></tr><tr><td>custom_status</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Pricelists&#x20;

Retrieves the pricing list details assigned to a BigCommerce store's specific sales channel, customer group, or customer group. For more information on the API, see [BigCommerce v2- pricelists.](https://developer.bigcommerce.com/docs/rest-management/price-lists)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>active</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Product\_images&#x20;

Retrieves all the lists of product images associated with a BigCommerce store. For more information on the API, see [BigCommerce v2- product images.](https://developer.bigcommerce.com/docs/rest-catalog/products/images#get-all-product-images)

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>is_thumbnail</td><td>BOOLEAN</td></tr><tr><td>sort_order</td><td>NUMERIC</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>image_file</td><td>STRING</td></tr><tr><td>url_zoom</td><td>STRING</td></tr><tr><td>url_standard</td><td>STRING</td></tr><tr><td>url_thumbnail</td><td>STRING</td></tr><tr><td>url_tiny</td><td>STRING</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Product\_reviews&#x20;

Retrieves a list of all the reviews associated with a product for a given BigCommerce store. For more information on the API, see [BigCommerce v2- product reviews.](https://developer.bigcommerce.com/docs/rest-catalog/products/reviews#get-product-reviews)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>rating</td><td>NUMERIC</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>date_reviewed</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Product\_variants&#x20;

Retrieves arbitrary key-value attributes like variant images and their meta fields associated with a BigCommerce store product. For more information on the API, see [BigCommerce v2- product variants.](https://developer.bigcommerce.com/docs/rest-catalog/product-variants)&#x20;

**Fields**

<table><thead><tr><th width="198">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>calculated_price</td><td>NUMERIC</td></tr><tr><td>sale_price</td><td>NUMERIC</td></tr><tr><td>retail_price</td><td>NUMERIC</td></tr><tr><td>map_price</td><td>NUMERIC</td></tr><tr><td>weight</td><td>NUMERIC</td></tr><tr><td>width</td><td>NUMERIC</td></tr><tr><td>height</td><td>NUMERIC</td></tr><tr><td>depth</td><td>NUMERIC</td></tr><tr><td>is_free_shipping</td><td>BOOLEAN</td></tr><tr><td>fixed_cost_shipping_price</td><td>NUMERIC</td></tr><tr><td>calculated_weight</td><td>NUMERIC</td></tr><tr><td>purchasing_disabled</td><td>BOOLEAN</td></tr><tr><td>purchasing_disabled_message</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>cost_price</td><td>NUMERIC</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>mpn</td><td>STRING</td></tr><tr><td>gtin</td><td>STRING</td></tr><tr><td>inventory_level</td><td>NUMERIC</td></tr><tr><td>inventory_warning_level</td><td>NUMERIC</td></tr><tr><td>bin_picking_number</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>option_values</td><td>RECORD</td></tr><tr><td>sku_id</td><td>NUMERIC</td></tr></tbody></table>

#### Products&#x20;

Retrieves the list of product variants, variant options, pricing, reviews, images, and videos for a BigCommerce store product, in addition to complex rules, custom fields, and metafields data. For more information on the API, see [BigCommerce v2- products.](https://developer.bigcommerce.com/docs/rest-catalog/products)&#x20;

**Fields**

<table><thead><tr><th width="230">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>calculated_price</td><td>NUMERIC</td></tr><tr><td>categories</td><td>STRING</td></tr><tr><td>brand_id</td><td>NUMERIC</td></tr><tr><td>option_set_id</td><td>NUMERIC</td></tr><tr><td>option_set_display</td><td>STRING</td></tr><tr><td>inventory_level</td><td>NUMERIC</td></tr><tr><td>inventory_warning_level</td><td>NUMERIC</td></tr><tr><td>inventory_tracking</td><td>STRING</td></tr><tr><td>reviews_rating_sum</td><td>NUMERIC</td></tr><tr><td>reviews_count</td><td>NUMERIC</td></tr><tr><td>total_sold</td><td>NUMERIC</td></tr><tr><td>fixed_cost_shipping_price</td><td>NUMERIC</td></tr><tr><td>is_free_shipping</td><td>BOOLEAN</td></tr><tr><td>is_visible</td><td>BOOLEAN</td></tr><tr><td>is_featured</td><td>BOOLEAN</td></tr><tr><td>related_products</td><td>STRING</td></tr><tr><td>warranty</td><td>STRING</td></tr><tr><td>bin_picking_number</td><td>STRING</td></tr><tr><td>layout_file</td><td>STRING</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>mpn</td><td>STRING</td></tr><tr><td>gtin</td><td>STRING</td></tr><tr><td>search_keywords</td><td>STRING</td></tr><tr><td>availability</td><td>STRING</td></tr><tr><td>availability_description</td><td>STRING</td></tr><tr><td>gift_wrapping_options_type</td><td>STRING</td></tr><tr><td>sort_order</td><td>NUMERIC</td></tr><tr><td>condition</td><td>STRING</td></tr><tr><td>is_condition_shown</td><td>BOOLEAN</td></tr><tr><td>order_quantity_minimum</td><td>NUMERIC</td></tr><tr><td>order_quantity_maximum</td><td>NUMERIC</td></tr><tr><td>page_title</td><td>STRING</td></tr><tr><td>meta_description</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>view_count</td><td>NUMERIC</td></tr><tr><td>preorder_message</td><td>STRING</td></tr><tr><td>is_preorder_only</td><td>BOOLEAN</td></tr><tr><td>is_price_hidden</td><td>BOOLEAN</td></tr><tr><td>price_hidden_label</td><td>STRING</td></tr><tr><td>custom_url</td><td>RECORD</td></tr><tr><td>base_variant_id</td><td>NUMERIC</td></tr><tr><td>open_graph_type</td><td>STRING</td></tr><tr><td>open_graph_title</td><td>STRING</td></tr><tr><td>open_graph_description</td><td>STRING</td></tr><tr><td>open_graph_use_meta_description</td><td>BOOLEAN</td></tr><tr><td>open_graph_use_product_name</td><td>BOOLEAN</td></tr><tr><td>open_graph_use_image</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Storecurrency&#x20;

Retrieves the data related to the alternate currency display options on the storefront for a BigCommerce store. For more information on the API, see [BigCommerce v2- storecurrency](https://developer.bigcommerce.com/docs/rest-management/currencies).

**Fields**

<table><thead><tr><th width="177">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>is_default</td><td>BOOLEAN</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>country_iso2</td><td>STRING</td></tr><tr><td>currency_code</td><td>STRING</td></tr><tr><td>currency_exchange_rate</td><td>STRING</td></tr><tr><td>auto_update</td><td>BOOLEAN</td></tr><tr><td>token_location</td><td>STRING</td></tr><tr><td>token</td><td>STRING</td></tr><tr><td>decimal_token</td><td>STRING</td></tr><tr><td>thousands_token</td><td>STRING</td></tr><tr><td>decimal_places</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>enabled</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>default_for_country_codes</td><td>STRING</td></tr><tr><td>is_transactional</td><td>BOOLEAN</td></tr><tr><td>use_default_name</td><td>BOOLEAN</td></tr></tbody></table>

#### Subscribers&#x20;

Retrieves the data related to subscribers for a BigCommerce store. For more information on the API, see [BigCommerce v2- subscribers.](https://developer.bigcommerce.com/docs/rest-management/subscribers)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>email</td><td>STRING</td></tr><tr><td>first_name</td><td>STRING</td></tr><tr><td>last_name</td><td>STRING</td></tr><tr><td>source</td><td>STRING</td></tr><tr><td>order_id</td><td>NUMERIC</td></tr><tr><td>channel_id</td><td>NUMERIC</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>consents</td><td>STRING</td></tr></tbody></table>