# Guidewire Cloud Data Access schema ERD

Table and field reference for the Fivetran Guidewire Cloud Data Access connector.

## Table & Field Reference

### source_table

| Column | Type | Keys |
| --- | --- | --- |
| gwcbi_operation | Int | PK |
| gwcbi_seqval_hex | String | PK |
| id | Long | PK |
| deployment_id | Long | PK, FK |
| batch_timestamp | Long | FK |
| schema_fingerprint | String | FK |
| gwcbi_lsn | Long |  |
| gwcbi_payload_ts_ms | Long |  |

### rollback

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| deployment_id | String | PK, FK |
| lsn_lower | Long |  |
| lsn_upper | Long |  |
| time | String |  |
| time_range_end | Long |  |
| time_range_start | Long |  |

### batch_metrics

| Column | Type | Keys |
| --- | --- | --- |
| batch_timestamp | String | PK |
| schema_fingerprint | String | PK |
| table_name | String | PK |
| deployment_id | String | PK, FK |
| num_records_dropped | Long |  |
| num_records_read | Long |  |
| num_records_written | Long |  |

### deployment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activated_at | String |  |
| superseded_at | String |  |

### manifest

| Column | Type | Keys |
| --- | --- | --- |
| last_successful_write_timestamp | String | PK |
| table_name | String | PK |
| deployment_id | String | PK, FK |
| schema_history | Json |  |
| total_processed_records_count | Long |  |

## Relationships

- source_table(deployment_id) → deployment(id)
- source_table(schema_fingerprint) → batch_metrics(schema_fingerprint)
- source_table(batch_timestamp) → batch_metrics(batch_timestamp)
- rollback(deployment_id) → deployment(id)
- batch_metrics(deployment_id) → deployment(id)
- manifest(deployment_id) → deployment(id)