# Google Tasks schema ERD

Table and field reference for the Fivetran Google Tasks connector.

## Table & Field Reference

### task_link

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_id | String | PK, FK |
| description | String |  |
| link | String |  |
| type | String |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| parent | String | FK |
| tasklist_id | String | FK |
| completed | Instant |  |
| deleted | Boolean |  |
| due | Instant |  |
| etag | String |  |
| hidden | Boolean |  |
| kind | String |  |
| notes | String |  |
| position | String |  |
| self_link | String |  |
| status | String |  |
| title | String |  |
| updated | Instant |  |

### tasklist

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| etag | String |  |
| kind | String |  |
| self_link | String |  |
| title | String |  |
| updated | Instant |  |

## Relationships

- task_link(task_id) → task(id)
- task(parent) → task(id)
- task(tasklist_id) → tasklist(id)