# Cloudflare Analytics schema ERD

Table and field reference for the Fivetran Cloudflare Analytics connector.

## Table & Field Reference

### cpu_time

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| zone_id | Unknown | PK, FK |
| total_cpu_time | Unknown |  |

### request_group

| Column | Type | Keys |
| --- | --- | --- |
| client_country_name | Unknown | PK |
| date | Unknown | PK |
| zone_id | Unknown | PK |
| byte | Unknown |  |
| request | Unknown |  |

### cache_reserve

| Column | Type | Keys |
| --- | --- | --- |
| bucket_hash | Unknown | PK |
| date_time_fifteen_minute | Unknown | PK |
| zone_id | Unknown | PK |
| bucket_prefix | Unknown |  |
| max_stored_byte | Unknown |  |

### bytes_by_hostname

| Column | Type | Keys |
| --- | --- | --- |
| client_country_name | Unknown | PK |
| client_request_http_host | Unknown | PK |
| client_request_path | Unknown | PK |
| date_time_hour | Unknown | PK |
| zone_id | Unknown | PK |
| edge_response_byte_sum | Unknown |  |

### zone_name_server

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| name_server | Unknown |  |

### zone_original_name_server

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| original_name_server | Unknown |  |

### zone_vanity_name_server

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| zone_id | Unknown | PK, FK |
| vanity_name_server | Unknown |  |

### zone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| account_name | Unknown |  |
| activated_on | Unknown |  |
| created_on | Unknown |  |
| development_mode | Unknown |  |
| meta_cdn_only | Unknown |  |
| meta_custom_certificate_quota | Unknown |  |
| meta_dns_only | Unknown |  |
| meta_foundation_dns | Unknown |  |
| meta_page_rule_quota | Unknown |  |
| meta_phishing_detected | Unknown |  |
| meta_step | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| original_dnshost | Unknown |  |
| original_registrar | Unknown |  |
| owner_id | Unknown |  |
| owner_name | Unknown |  |
| owner_type | Unknown |  |
| paused | Unknown |  |
| plan_can_subscribe | Unknown |  |
| plan_currency | Unknown |  |
| plan_externally_managed | Unknown |  |
| plan_frequency | Unknown |  |
| plan_id | Unknown |  |
| plan_is_subscribed | Unknown |  |
| plan_legacy_discount | Unknown |  |
| plan_legacy_id | Unknown |  |
| plan_name | Unknown |  |
| plan_price | Unknown |  |
| status | Unknown |  |
| tenant_id | Unknown |  |
| tenant_name | Unknown |  |
| tenant_unit_id | Unknown |  |
| type | Unknown |  |
| vanity_name_servers_ips | Json |  |

### image_resize_request

| Column | Type | Keys |
| --- | --- | --- |
| content_type | Unknown | PK |
| date | Unknown | PK |
| zone_id | Unknown | PK, FK |
| sum_original_byte | Unknown |  |
| sum_request | Unknown |  |
| sum_resized_byte | Unknown |  |

## Relationships

- cpu_time(zone_id) → zone(id)
- zone_name_server(zone_id) → zone(id)
- zone_original_name_server(zone_id) → zone(id)
- zone_vanity_name_server(zone_id) → zone(id)
- image_resize_request(zone_id) → zone(id)