# Kissmetrics schema ERD

Table and field reference for the Fivetran Kissmetrics connector.

## Table & Field Reference

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| name | Unknown |  |
| report_type | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |

### property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| first_sent_at | Unknown |  |
| first_used_at | Unknown |  |
| last_sent_at | Unknown |  |
| last_used_at | Unknown |  |
| name | Unknown |  |
| total | Unknown |  |
| visible | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| first_sent_at | Unknown |  |
| first_used_at | Unknown |  |
| last_sent_at | Unknown |  |
| last_used_at | Unknown |  |
| name | Unknown |  |
| total | Unknown |  |
| visible | Unknown |  |

## Relationships

- report(product_id) → product(id)
- property(product_id) → product(id)
- event(product_id) → product(id)