# Schema Information

## Tables/APIs 

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

* [Calls](#calls) 
* [Texts](#texts)

#### Calls 

This API retrieves calls associated with an account or tailors your call selection using various query parameters. For more information, see [JustCall- Calls](https://developer.justcall.io/reference/call_list).

{% hint style="info" %}
**Primary Key:** `id` - This is the unique identifier.
{% endhint %}

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>contact_number</td><td>STRING</td></tr><tr><td>contact_name</td><td>STRING</td></tr><tr><td>justcall_number</td><td>STRING</td></tr><tr><td>justcall_line_name</td><td>STRING</td></tr><tr><td>agent_id</td><td>NUMERIC</td></tr><tr><td>agent_name</td><td>STRING</td></tr><tr><td>agent_email</td><td>STRING</td></tr><tr><td>agent_active</td><td>STRING</td></tr><tr><td>call_date</td><td>DATE</td></tr><tr><td>call_time</td><td>TIME</td></tr><tr><td>call_user_date</td><td>DATE</td></tr><tr><td>call_user_time</td><td>TIME</td></tr><tr><td>cost_incurred</td><td>NUMERIC</td></tr><tr><td>call_info</td><td>RECORD</td></tr><tr><td>call_duration</td><td>RECORD</td></tr><tr><td>ivr_info</td><td>RECORD</td></tr></tbody></table>

#### Texts

This API retrieves all text messages associated with an account or fine-tunes your message selection by leveraging the diverse query parameter options. For more information, see [JustCall- Texts](https://developer.justcall.io/reference/texts_list).

{% hint style="info" %}
**Primary Key:** `id` - This is the unique identifier.
{% endhint %}

**FIELDS**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>contact_number</td><td>STRING</td></tr><tr><td>contact_name</td><td>STRING</td></tr><tr><td>justcall_number</td><td>STRING</td></tr><tr><td>justcall_line_name</td><td>STRING</td></tr><tr><td>agent_id</td><td>NUMERIC</td></tr><tr><td>agent_name</td><td>STRING</td></tr><tr><td>sms_date</td><td>DATE</td></tr><tr><td>sms_user_date</td><td>DATE</td></tr><tr><td>sms_time</td><td>TIME</td></tr><tr><td>sms_user_time</td><td>TIME</td></tr><tr><td>direction</td><td>STRING</td></tr><tr><td>sms_info</td><td>RECORD</td></tr><tr><td>delivery_status</td><td>STRING</td></tr><tr><td>is_deleted</td><td>BOOLEAN</td></tr></tbody></table>