# Brivo schema ERD

Table and field reference for the Fivetran Brivo connector.

## Table & Field Reference

### access_point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site_id | Unknown | FK |
| activation_enabled | Unknown |  |
| control_panel_id | Unknown |  |
| name | Unknown |  |
| report_live_status | Unknown |  |
| two_factor_enabled | Unknown |  |
| type | Unknown |  |

### event_subscription_criteria

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_subscription_id | Unknown | PK, FK |
| operation_type | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### event_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| error_email | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### access_event

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| site_id | Unknown | FK |
| actor_id | Unknown |  |
| actor_identity_type | Unknown |  |
| actor_name | Unknown |  |
| event_action_allowed | Unknown |  |
| event_credential_object_id | Unknown |  |
| event_detail | Unknown |  |
| event_object_device_type_id | Unknown |  |
| event_object_device_type_name | Unknown |  |
| event_object_group_name | Unknown |  |
| event_object_id | Unknown |  |
| event_object_name | Unknown |  |
| event_object_subtype_id | Unknown |  |
| event_object_type_id | Unknown |  |
| event_user_type_id | Unknown |  |
| object_type | Unknown |  |
| occurred | Unknown |  |
| processed | Unknown |  |
| security_action | Unknown |  |
| security_action_exception | Unknown |  |
| security_action_id | Unknown |  |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| field_name | Unknown |  |
| field_type | Unknown |  |
| value | Unknown |  |

### control_panel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activated | Unknown |  |
| firmware_version | Unknown |  |
| last_contact | Unknown |  |
| name | Unknown |  |
| panel_type | Unknown |  |
| serial_number | Unknown |  |
| status | Unknown |  |
| updated | Unknown |  |

### holiday

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| end_date | Unknown |  |
| name | Unknown |  |
| site_name | Unknown |  |
| start | Unknown |  |

### user_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| address | Unknown |  |
| type | Unknown |  |

### user_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| number | Unknown |  |
| type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ble_two_factor_exempt | Unknown |  |
| created | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| suspended | Unknown |  |
| updated | Unknown |  |

### schedule_holiday

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| end_date | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |

### schedule_exception

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| enabling | Unknown |  |
| end_time | Unknown |  |
| recurrence_day | Unknown |  |
| recurrence_type | Unknown |  |
| recurrence_week_of_month | Unknown |  |
| start_time | Unknown |  |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site_id | Unknown | FK |
| editable | Unknown |  |
| enabling_group_id | Unknown |  |
| enabling_group_name | Unknown |  |
| grace_period | Unknown |  |
| name | Unknown |  |
| schedule_block_friday | Json |  |
| schedule_block_holiday | Json |  |
| schedule_block_monday | Json |  |
| schedule_block_saturday | Json |  |
| schedule_block_sunday | Json |  |
| schedule_block_thursday | Json |  |
| schedule_block_tuesday | Json |  |
| schedule_block_wednesday | Json |  |

### audit_event_property_change

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| audit_event_uuid | Unknown | PK, FK |
| current_value | Unknown |  |
| previous_value | Unknown |  |
| property | Unknown |  |

### audit_event

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| actor_id | Unknown |  |
| actor_identity_type | Unknown |  |
| actor_name | Unknown |  |
| event_action_allowed | Unknown |  |
| event_actor_user_type_id | Unknown |  |
| event_credential_label | Unknown |  |
| event_credential_object_id | Unknown |  |
| event_detail | Unknown |  |
| event_object_id | Unknown |  |
| event_object_identity_type | Unknown |  |
| event_object_name | Unknown |  |
| event_object_subtype_id | Unknown |  |
| event_object_type_id | Unknown |  |
| event_user_group_name | Unknown |  |
| event_user_type_id | Unknown |  |
| object_type | Unknown |  |
| occurred | Unknown |  |
| processed | Unknown |  |
| security_action | Unknown |  |
| security_action_exception | Unknown |  |
| security_action_id | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| city | Unknown |  |
| country | Unknown |  |
| geolocation_accuracy | Unknown |  |
| geolocation_center | Unknown |  |
| geolocation_coordinate | Unknown |  |
| geolocation_relevance | Unknown |  |
| geolocation_valid_address | Unknown |  |
| name | Unknown |  |
| owner_object_id | Unknown |  |
| parent_id | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| street_address_1 | Unknown |  |
| street_address_2 | Unknown |  |
| time_zone | Unknown |  |

### user_credential

| Column | Type | Keys |
| --- | --- | --- |
| credential_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| effective_from | Unknown |  |
| effective_to | Unknown |  |

### credential_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credential_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### credential

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| credential_format_id | Unknown |  |
| credential_format_name | Unknown |  |
| credential_format_supported_dormakaba_card | Unknown |  |
| credential_used_with_offline_locks | Unknown |  |
| encoded_credential | Unknown |  |
| reference_id | Unknown |  |
| size | Unknown |  |

### camera

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| site_id | Unknown | FK |
| name | Unknown |  |
| video_provider_type | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| master_admin_email | Unknown |  |
| master_admin_first_name | Unknown |  |
| master_admin_last_name | Unknown |  |
| master_admin_username | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |

## Relationships

- access_point(site_id) → site(id)
- event_subscription_criteria(event_subscription_id) → event_subscription(id)
- access_event(site_id) → site(id)
- user_custom_field(user_id) → users(id)
- user_email(user_id) → users(id)
- user_phone_number(user_id) → users(id)
- schedule_holiday(schedule_id) → schedule(id)
- schedule_exception(schedule_id) → schedule(id)
- schedule(site_id) → site(id)
- audit_event_property_change(audit_event_uuid) → audit_event(uuid)
- user_credential(credential_id) → credential(id)
- user_credential(user_id) → users(id)
- credential_field_value(credential_id) → credential(id)
- credential(account_id) → account(id)
- camera(site_id) → site(id)