# Cabcharge schema ERD

Table and field reference for the Fivetran Cabcharge connector.

## Table & Field Reference

### statement_enriched_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| statement_account_id | Unknown | PK, FK |
| statement_period | Unknown | PK, FK |
| assignee | Unknown |  |
| product_tag | Json |  |
| transaction_aust_amount | Unknown |  |
| transaction_aust_charge | Unknown |  |
| transaction_aust_extra | Unknown |  |
| transaction_booking_ref | Unknown |  |
| transaction_card_name | Unknown |  |
| transaction_card_number | Unknown |  |
| transaction_date | Unknown |  |
| transaction_docket | Unknown |  |
| transaction_driver_abn | Unknown |  |
| transaction_driver_id | Unknown |  |
| transaction_fare | Unknown |  |
| transaction_from_address | Unknown |  |
| transaction_gst | Unknown |  |
| transaction_levy_amount | Unknown |  |
| transaction_levy_authority | Unknown |  |
| transaction_local_amount | Unknown |  |
| transaction_local_fare | Unknown |  |
| transaction_merchant | Unknown |  |
| transaction_product | Unknown |  |
| transaction_rate_type | Unknown |  |
| transaction_rrn | Unknown |  |
| transaction_service_fee | Unknown |  |
| transaction_service_fee_rate | Unknown |  |
| transaction_taxi | Unknown |  |
| transaction_time | Unknown |  |
| transaction_to_address | Unknown |  |
| transaction_total_amount | Unknown |  |
| transaction_trans_number | Unknown |  |
| transaction_trip_uid | Unknown |  |
| trip_comment | Unknown |  |
| trip_tag | Json |  |

### statement

| Column | Type | Keys |
| --- | --- | --- |
| period | Unknown | PK |
| account_id | Unknown | PK, FK |
| account_fee | Unknown |  |
| balance_brought_forward | Unknown |  |
| credit_adjustment | Unknown |  |
| debit_adjustment | Unknown |  |
| due_date | Unknown |  |
| enriched_order | Json |  |
| from_date | Unknown |  |
| gov_levy | Unknown |  |
| gst_amount | Unknown |  |
| invoice_number | Unknown |  |
| issue_date | Unknown |  |
| overdue | Unknown |  |
| payment_received | Unknown |  |
| period_total | Unknown |  |
| previous_balance | Unknown |  |
| service_fee | Unknown |  |
| statement_period | Unknown |  |
| taxi_fare | Unknown |  |
| to_date | Unknown |  |
| trip_number | Unknown |  |

### traveller_role

| Column | Type | Keys |
| --- | --- | --- |
| role | Unknown | PK |
| traveller_id | Unknown | PK, FK |

### traveller_tag_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| traveller_id | Unknown | PK, FK |
| category_id | Unknown | FK |

### traveller

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| pay_on_account_permission | Unknown |  |
| phone_number | Unknown |  |
| user_id | Unknown |  |

### digital_fast_card_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| assignee | Unknown |  |
| cancelled_trip | Unknown |  |
| delivery_address | Unknown |  |
| delivery_method | Unknown |  |
| expiry | Unknown |  |
| order_date | Unknown |  |
| order_user_id | Unknown |  |
| original_trip | Unknown |  |
| pan | Unknown |  |
| seq | Unknown |  |
| spending_limit | Unknown |  |
| spending_limit_frequency | Unknown |  |
| status | Unknown |  |
| tags | Unknown |  |
| used_trip | Unknown |  |
| valid_from | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| billing_period | Unknown |  |
| drop_off_address | Unknown |  |
| drop_off_date_time | Unknown |  |
| fare | Unknown |  |
| gst | Unknown |  |
| kilometre | Unknown |  |
| order_id | Unknown |  |
| pickup_address | Unknown |  |
| pickup_date_time | Unknown |  |
| product_type | Unknown |  |
| receipt_number | Unknown |  |
| route | Json |  |
| service_fee | Unknown |  |
| taxi | Unknown |  |
| ticket_number | Unknown |  |
| transaction_date | Unknown |  |
| trip_tag | Json |  |
| extra_** |  |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_status | Unknown |  |
| billing_period | Json |  |
| dfc_max_fare_limit | Unknown |  |
| name | Unknown |  |
| tag_visible | Unknown |  |
| trip_tag_config_allow_new_tag_addition | Unknown |  |
| trip_tag_config_categories_required | Unknown |  |
| trip_tag_config_comments_required | Unknown |  |
| trip_tag_config_traveller_trip_tagging_enabled | Unknown |  |

### digital_pass_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| assignee | Unknown |  |
| cancelled_by | Unknown |  |
| cancelled_date | Unknown |  |
| cancelled_trip | Unknown |  |
| created_by | Unknown |  |
| delivery_address | Unknown |  |
| delivery_method | Unknown |  |
| expiry | Unknown |  |
| fare_limit | Unknown |  |
| original_trip | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| ticket_number | Unknown |  |
| used_trip | Unknown |  |
| valid_from | Unknown |  |

### inventory_fastcard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| assignee_email | Unknown |  |
| assignee_name | Unknown |  |
| expiry_date | Unknown |  |
| name_on_card | Unknown |  |
| receipt_email | Unknown |  |
| valid_from | Unknown |  |

### category_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| category_id | Unknown | PK, FK |
| description | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| name | Unknown |  |

### inventory_flexi_fastcard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| assignee_email | Unknown |  |
| assignee_name | Unknown |  |
| expiry_date | Unknown |  |
| name_on_card | Unknown |  |
| receipt_email | Unknown |  |
| valid_from | Unknown |  |

### inventory_eticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| assignee_email | Unknown |  |
| assignee_name | Unknown |  |
| expiry_date | Unknown |  |
| name_on_card | Unknown |  |
| receipt_email | Unknown |  |
| valid_from | Unknown |  |

## Relationships

- statement_enriched_item(statement_account_id) → statement(account_id)
- statement_enriched_item(statement_period) → statement(period)
- statement(account_id) → account(id)
- traveller_role(traveller_id) → traveller(id)
- traveller_tag_profile(category_id) → category(id)
- traveller_tag_profile(traveller_id) → traveller(id)
- traveller(account_id) → account(id)
- digital_fast_card_order(account_id) → account(id)
- transaction(account_id) → account(id)
- digital_pass_order(account_id) → account(id)
- inventory_fastcard(account_id) → account(id)
- category_tag(category_id) → category(id)
- category_tag(account_id) → category(account_id)
- category(account_id) → account(id)
- inventory_flexi_fastcard(account_id) → account(id)
- inventory_eticket(account_id) → account(id)