# Brightflag schema ERD

Table and field reference for the Fivetran Brightflag connector.

## Table & Field Reference

### allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| name | Unknown |  |
| order_number | Unknown |  |

### resource

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| attributes | Json |  |
| endpoint | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |
| schema | Unknown |  |

### trading_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| city | Unknown |  |
| code | Unknown |  |
| country | Unknown |  |
| enabled | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| tax_id | Unknown |  |
| zip | Unknown |  |

### matter_custom_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| matter_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### matter_internal_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| matter_id | Unknown | PK, FK |
| internal_matter_user | Unknown |  |

### matter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| budget | Unknown |  |
| category | Unknown |  |
| change_timestamp | Unknown |  |
| closed_date | Unknown |  |
| country | Unknown |  |
| country_name | Unknown |  |
| currency | Unknown |  |
| department | Unknown |  |
| description | Unknown |  |
| entity | Unknown |  |
| internal_matter_lead_user | Unknown |  |
| is_open | Unknown |  |
| iso_code | Unknown |  |
| lead_outside_counsel_username | Unknown |  |
| open_date | Unknown |  |
| ref | Unknown |  |
| region_name | Unknown |  |
| remove_excluded_internal_matter_participants | Unknown |  |
| remove_excluded_vendors | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| role | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| employee_level | Unknown |  |
| employee_number | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| last_name | Unknown |  |
| manager | Unknown |  |
| schema | Json |  |
| username | Unknown |  |

### tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| code | Unknown |  |
| jurisdiction_iso_code | Unknown |  |
| percentage | Unknown |  |
| type_name | Unknown |  |

### allocation_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allocation_id | Unknown | PK, FK |
| active | Unknown |  |
| ap_code | Unknown |  |
| name | Unknown |  |

### paysite

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_ref | Unknown | FK |
| active | Unknown |  |
| billing_legal_entity | Unknown |  |
| billing_legal_entity_code | Unknown |  |
| code | Unknown |  |
| currency | Unknown |  |
| vendor_office_ref | Unknown |  |

### invoice_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_ref | Unknown | FK |
| adjustments | Unknown |  |
| approved_gross_total | Unknown |  |
| blended_tax_rate | Unknown |  |
| currency_details_customer_default_currency_fx_rate | Unknown |  |
| currency_details_customer_default_currency_iso_code | Unknown |  |
| currency_details_matter_currency_fx_rate | Unknown |  |
| currency_details_matter_currency_iso_code | Unknown |  |
| currency_iso_code | Unknown |  |
| date | LocalDateTime |  |
| discount | Unknown |  |
| expenses | Unknown |  |
| exposure_percentage | Unknown |  |
| fees_total | Unknown |  |
| group_id | Unknown |  |
| matter_ref | Unknown |  |
| number | Unknown |  |
| original_gross_total | Unknown |  |
| po_number | Unknown |  |
| status | Unknown |  |
| status_change_timestamp | Unknown |  |
| tax_total | Unknown |  |

### account_payable_batch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| creator_email | Unknown |  |
| creator_id | Unknown |  |
| customer_batch_id | Unknown |  |
| customer_id | Unknown |  |
| recipient_email | Unknown |  |
| recipient_id | Unknown |  |
| text | Unknown |  |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ref | Unknown | PK |
| contact_email | Unknown |  |
| firm_name | Unknown |  |
| name | Unknown |  |
| payment_method | Unknown |  |
| preferred_flag | Unknown |  |

### vendor_office

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_ref | Unknown | FK |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| address_street_and_building | Unknown |  |
| admin_user_email | Unknown |  |
| admin_user_forename | Unknown |  |
| admin_user_surname | Unknown |  |
| bank_account_name | Unknown |  |
| bank_account_no | Unknown |  |
| bank_address | Unknown |  |
| bank_iban | Unknown |  |
| bank_name | Unknown |  |
| bank_sort_code | Unknown |  |
| bank_swift_or_bic | Unknown |  |
| country | Unknown |  |
| country_iso_code | Unknown |  |
| name | Unknown |  |
| office_vendor_id | Unknown |  |
| payment_method | Unknown |  |
| ref | Unknown |  |
| tax_id | Unknown |  |

## Relationships

- matter_custom_attribute(matter_id) → matter(id)
- matter_internal_user(matter_id) → matter(id)
- user_role(user_id) → users(id)
- allocation_option(allocation_id) → allocation(id)
- paysite(vendor_ref) → vendor(ref)
- invoice_summary(vendor_ref) → vendor(ref)
- vendor_office(vendor_ref) → vendor(ref)