Fivetran documentation

Search the docs

/

Brivo

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`address`	Unknown
`type`	Unknown

user_phone_number

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`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	PKFK
`end_date`	Unknown
`name`	Unknown
`start_date`	Unknown

schedule_exception

Column	Type	Keys
`index`	Unknown	PK
`schedule_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`user_id`	Unknown	PKFK
`effective_from`	Unknown
`effective_to`	Unknown

credential_field_value

Column	Type	Keys
`id`	Unknown	PK
`credential_id`	Unknown	PKFK
`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