# Kisi schema ERD

Table and field reference for the Fivetran Kisi connector.

## Table & Field Reference

### group_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| issued_by_id | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| enabled | Unknown |  |
| last_used_at | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| quick_response_code_type | Unknown |  |
| updated_at | Unknown |  |
| valid_from | Unknown |  |
| valid_until | Unknown |  |

### role_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issued_by_id | Unknown | FK |
| organization_id | Unknown | FK |
| role_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| notify | Unknown |  |
| scope | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| elevator_stops_count | Unknown |  |
| geofence_restriction_enabled | Unknown |  |
| geofence_restriction_radius | Unknown |  |
| login_enabled | Unknown |  |
| name | Unknown |  |
| primary_device_restriction_enabled | Unknown |  |
| reader_restriction_enabled | Unknown |  |
| time_restriction_enabled | Unknown |  |
| updated_at | Unknown |  |

### controller_input

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | FK |
| controller_input_connection_id | Unknown | FK |
| channel | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### lock

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| floor_id | Unknown | FK |
| integration_id | Unknown | FK |
| place_id | Unknown | FK |
| configured | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| favorite | Unknown |  |
| first_to_arrive_required_until | Unknown |  |
| first_to_arrive_satisfied | Unknown |  |
| first_to_arrive_valid_until | Unknown |  |
| geofence_restriction_enabled | Unknown |  |
| geofence_restriction_radius | Unknown |  |
| is_open | Unknown |  |
| name | Unknown |  |
| on_scheduled_unlock | Unknown |  |
| online | Unknown |  |
| order_id | Unknown |  |
| reader_restriction_enabled | Unknown |  |
| time_restriction_enabled | Unknown |  |
| time_restriction_time_zone | Unknown |  |
| unlocked | Unknown |  |
| updated_at | Unknown |  |

### controller_wiegand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | FK |
| controller_wiegand_connection_id | Unknown | FK |
| channel | Unknown |  |

### elevator

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| integration_id | Unknown | FK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### elevator_stop

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| elevator_id | Unknown | FK |
| floor_id | Unknown | FK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| locked_down | Unknown |  |
| locked_down_since | Unknown |  |
| name | Unknown |  |
| on_scheduled_permit | Unknown |  |
| permitted | Unknown |  |
| time_restriction_enabled | Unknown |  |
| updated_at | Unknown |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| access_enabled | Unknown |  |
| card_assigned_by_id | Unknown |  |
| confirmed | Unknown |  |
| created_at | Unknown |  |
| image | Unknown |  |
| last_accessed_at | Unknown |  |
| login_last_used_at | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| password_flow_enabled | Unknown |  |
| scim_access_enabled | Unknown |  |
| shares_count | Unknown |  |
| updated_at | Unknown |  |
| user_email | Unknown |  |
| user_id | Unknown |  |
| user_name | Unknown |  |
| user_otp_required_for_login | Unknown |  |

### card

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned | Unknown |  |
| card_id | Unknown |  |
| color | Unknown |  |
| facility_code | Unknown |  |
| form_factor | Unknown |  |
| frequency | Unknown |  |
| model | Unknown |  |
| number | Unknown |  |
| oem | Unknown |  |
| scanned_at | Unknown |  |
| send_two_factor_pin_notification | Unknown |  |
| sub_type | Unknown |  |
| third_party | Unknown |  |
| token | Unknown |  |
| two_factor_pin | Unknown |  |
| type | Unknown |  |
| uid | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transfer_to_id | Unknown | FK |
| user_id | Unknown | FK |
| address | Unknown |  |
| description | Unknown |  |
| domain | Unknown |  |
| logo | Unknown |  |
| metadata | Unknown |  |
| name | Unknown |  |
| places_count | Unknown |  |
| scim_enabled | Unknown |  |
| send_emails | Unknown |  |
| sso_expiration_override | Unknown |  |
| sso_expiration_override_enabled | Unknown |  |
| sso_flow_enabled | Unknown |  |
| time_zone | Unknown |  |
| web_authentication_api_enabled | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| permissions_alert_policy_read | Unknown |  |
| permissions_alert_policy_write | Unknown |  |
| permissions_analytic_read | Unknown |  |
| permissions_camera_read | Unknown |  |
| permissions_camera_snapshot_read | Unknown |  |
| permissions_camera_snapshot_write | Unknown |  |
| permissions_camera_write | Unknown |  |
| permissions_capacity_read | Unknown |  |
| permissions_capacity_write | Unknown |  |
| permissions_card_activate | Unknown |  |
| permissions_card_read | Unknown |  |
| permissions_card_write | Unknown |  |
| permissions_csv_card_import_read | Unknown |  |
| permissions_csv_card_import_write | Unknown |  |
| permissions_csv_user_import_read | Unknown |  |
| permissions_csv_user_import_write | Unknown |  |
| permissions_dashboards_read | Unknown |  |
| permissions_elevator_read | Unknown |  |
| permissions_elevator_stop_read | Unknown |  |
| permissions_elevator_stop_write | Unknown |  |
| permissions_elevator_write | Unknown |  |
| permissions_event_export_reporter_read | Unknown |  |
| permissions_event_export_reporter_write | Unknown |  |
| permissions_event_read | Unknown |  |
| permissions_floor_read | Unknown |  |
| permissions_floor_write | Unknown |  |
| permissions_group_elevator_stop_read | Unknown |  |
| permissions_group_elevator_stop_write | Unknown |  |
| permissions_group_link_read | Unknown |  |
| permissions_group_link_write | Unknown |  |
| permissions_group_lock_read | Unknown |  |
| permissions_group_lock_write | Unknown |  |
| permissions_group_read | Unknown |  |
| permissions_group_write | Unknown |  |
| permissions_hardware_read | Unknown |  |
| permissions_hardware_write | Unknown |  |
| permissions_integration_read | Unknown |  |
| permissions_integration_write | Unknown |  |
| permissions_lock_read | Unknown |  |
| permissions_lock_unlock | Unknown |  |
| permissions_lock_write | Unknown |  |
| permissions_marketplace_installation_read | Unknown |  |
| permissions_marketplace_installation_write | Unknown |  |
| permissions_member_export_reporter_read | Unknown |  |
| permissions_member_export_reporter_write | Unknown |  |
| permissions_member_read | Unknown |  |
| permissions_member_write | Unknown |  |
| permissions_place_analytics_reporter_read | Unknown |  |
| permissions_place_analytics_reporter_write | Unknown |  |
| permissions_place_read | Unknown |  |
| permissions_place_write | Unknown |  |
| permissions_presence_export_reporter_read | Unknown |  |
| permissions_presence_export_reporter_write | Unknown |  |
| permissions_report_read | Unknown |  |
| permissions_report_write | Unknown |  |
| permissions_role_assignment_read | Unknown |  |
| permissions_role_assignment_write | Unknown |  |
| permissions_scanned_card_read | Unknown |  |
| permissions_schedule_read | Unknown |  |
| permissions_schedule_write | Unknown |  |
| permissions_scheduled_report_read | Unknown |  |
| permissions_scheduled_report_write | Unknown |  |
| permissions_share_read | Unknown |  |
| permissions_share_write | Unknown |  |
| permissions_subscription_status_read | Unknown |  |
| permissions_unlock_export_reporter_read | Unknown |  |
| permissions_unlock_export_reporter_write | Unknown |  |
| permissions_zone_read | Unknown |  |
| permissions_zone_reset | Unknown |  |
| permissions_zone_write | Unknown |  |
| scope | Unknown |  |

### group_lock

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| lock_id | Unknown | FK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### floor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| updated_at | Unknown |  |

### login

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| expire | Unknown |  |
| is_primary | Unknown |  |
| last_reauthenticated_at | Unknown |  |
| last_used_at | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### reader

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| elevator_id | Unknown | FK |
| lock_id | Unknown | FK |
| place_id | Unknown | FK |
| buzzer_enabled | Unknown |  |
| cards_enabled | Unknown |  |
| checkout | Unknown |  |
| configured | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| device_id | Unknown |  |
| device_unlock_restriction_enabled | Unknown |  |
| ethernet_mac | Unknown |  |
| held_open_alarm_enabled | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| online | Unknown |  |
| revision | Unknown |  |
| tamper_enabled | Unknown |  |
| tampered | Unknown |  |
| token | Unknown |  |
| updated_at | Unknown |  |
| wave_to_unlock_enabled | Unknown |  |
| wifi_mac | Unknown |  |

### schedule_holiday

| Column | Type | Keys |
| --- | --- | --- |
| date | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| name | Unknown |  |

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| integration_id | Unknown | FK |
| place_id | Unknown | FK |
| consequence | Unknown |  |
| created_at | Unknown |  |
| enabled | Unknown |  |
| ends_at_date | Unknown |  |
| ignored_holiday | Json |  |
| name | Unknown |  |
| next_occurence_ends_at | Unknown |  |
| next_occurence_starts_at | Unknown |  |
| observed | Unknown |  |
| override | Unknown |  |
| region | Unknown |  |
| scheduleable_id | Unknown |  |
| scheduleable_name | Unknown |  |
| scheduleable_type | Unknown |  |
| starts_at_date | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### controller_wiegand_connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | PK, FK |
| controller_wiegand_id | Unknown | FK |
| elevator_id | Unknown | FK |
| lock_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### group_elevator_stop

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| elevator_id | Unknown | FK |
| elevator_stop_id | Unknown | FK |
| floor_id | Unknown | FK |
| group_id | Unknown | FK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### camera

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| integration_id | Unknown | FK |
| lock_id | Unknown | FK |
| place_id | Unknown | FK |
| clip_duration | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| enabled | Unknown |  |
| name | Unknown |  |
| number_of_snapshot | Unknown |  |
| remote_id | Unknown |  |
| remote_organization_id | Unknown |  |
| snapshot_offset | Unknown |  |
| supports_clip | Unknown |  |
| supports_image | Unknown |  |
| supports_thumbnail | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### place

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| transfer_to_id | Unknown | FK |
| user_id | Unknown | FK |
| address | Unknown |  |
| brand_color | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| current_user_permissions_manage | Unknown |  |
| current_user_permissions_share | Unknown |  |
| description | Unknown |  |
| favorite | Unknown |  |
| geofence_restriction_enabled | Unknown |  |
| geofence_restriction_radius | Unknown |  |
| header_image | Unknown |  |
| header_image_url | Unknown |  |
| image | Unknown |  |
| latitude | Unknown |  |
| locked_down | Unknown |  |
| locked_down_since | Unknown |  |
| logo | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| occupancy_rate | Unknown |  |
| primary_device_restriction_enabled | Unknown |  |
| reader_restriction_enabled | Unknown |  |
| restriction_enabled | Unknown |  |
| restriction_time_slots | Unknown |  |
| restriction_time_zone | Unknown |  |
| time_zone | Unknown |  |
| tz_time_zone | Unknown |  |
| updated_at | Unknown |  |

### controller_relay

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | FK |
| controller_input_connection_id | Unknown | FK |
| aux | Unknown |  |
| channel | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### integration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| place_id | Unknown | FK |
| created_at | Unknown |  |
| disabled_due_to_error | Unknown |  |
| disabled_due_to_error_at | Unknown |  |
| enabled | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### controller

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| place_id | Unknown | FK |
| configured | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| device_id | Unknown |  |
| ethernet_mac | Unknown |  |
| model | Unknown |  |
| name | Unknown |  |
| online | Unknown |  |
| revision | Unknown |  |
| tamper_enabled | Unknown |  |
| token | Unknown |  |
| updated_at | Unknown |  |
| wifi_mac | Unknown |  |
| zone | Unknown |  |

### presence

| Column | Type | Keys |
| --- | --- | --- |
| actor_id | Unknown | PK |
| place_id | Unknown | PK, FK |
| actor_email | Unknown |  |
| actor_name | Unknown |  |
| actor_type | Unknown |  |
| date | Unknown |  |
| first_unlock_at | Unknown |  |
| last_unlock_at | Unknown |  |
| last_unlocked_lock_id | Unknown |  |
| last_unlocked_lock_name | Unknown |  |
| status | Unknown |  |

### controller_relay_connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | PK, FK |
| controller_relay_id | Unknown | FK |
| lock_id | Unknown | FK |
| created_at | Unknown |  |
| duration | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### wireless_locks

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | FK |
| lock_id | Unknown | FK |
| address | Unknown |  |
| battery_level | Unknown |  |
| channel | Unknown |  |
| created_at | Unknown |  |
| firmware_version | Unknown |  |
| gateway_id | Unknown |  |
| loss_of_rf | Unknown |  |
| loss_of_rs_485 | Unknown |  |
| model | Unknown |  |
| motor_stall | Unknown |  |
| name | Unknown |  |
| online | Unknown |  |
| opened | Unknown |  |
| serial_number | Unknown |  |
| unlocked | Unknown |  |
| updated_at | Unknown |  |
| wireless_lock_connection_id | Unknown |  |

### controller_input_connection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| controller_id | Unknown | PK, FK |
| controller_input_id | Unknown | FK |
| lock_id | Unknown | FK |
| created_at | Unknown |  |
| duration | Unknown |  |
| enabled | Unknown |  |
| end_of_line_main_resistor | Unknown |  |
| end_of_line_second_resistor | Unknown |  |
| end_of_line_type | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| actor_id | Unknown | FK |
| organization_id | Unknown | FK |
| place_id | Unknown | FK |
| actor_email | Unknown |  |
| actor_name | Unknown |  |
| actor_type | Unknown |  |
| authenticated_by_id | Unknown |  |
| authenticated_by_type | Unknown |  |
| camera_snapshots | Unknown |  |
| created_at | Unknown |  |
| error_code | Unknown |  |
| error_message | Unknown |  |
| object_id | Unknown |  |
| object_name | Unknown |  |
| object_type | Unknown |  |
| sequence | Unknown |  |
| success | Unknown |  |
| type | Unknown |  |
| via | Json |  |

## Relationships

- group_link(issued_by_id) → member(user_id)
- group_link(group_id) → groups(id)
- role_assignment(user_id) → member(user_id)
- role_assignment(issued_by_id) → member(user_id)
- role_assignment(organization_id) → organization(id)
- role_assignment(role_id) → role(id)
- groups(place_id) → place(id)
- controller_input(controller_input_connection_id) → controller_input_connection(id)
- controller_input(controller_id) → controller(id)
- lock(place_id) → place(id)
- lock(floor_id) → floor(id)
- lock(integration_id) → integration(id)
- controller_wiegand(controller_id) → controller(id)
- controller_wiegand(controller_wiegand_connection_id) → controller_wiegand_connection(id)
- elevator(integration_id) → integration(id)
- elevator(place_id) → place(id)
- elevator_stop(place_id) → place(id)
- elevator_stop(floor_id) → floor(id)
- elevator_stop(elevator_id) → elevator(id)
- member(organization_id) → organization(id)
- organization(user_id) → member(user_id)
- organization(transfer_to_id) → member(user_id)
- group_lock(group_id) → groups(id)
- group_lock(lock_id) → lock(id)
- group_lock(place_id) → place(id)
- floor(place_id) → place(id)
- login(user_id) → member(user_id)
- reader(place_id) → place(id)
- reader(elevator_id) → elevator(id)
- reader(lock_id) → lock(id)
- schedule_holiday(schedule_id) → schedule(id)
- schedule(place_id) → place(id)
- schedule(integration_id) → integration(id)
- controller_wiegand_connection(lock_id) → lock(id)
- controller_wiegand_connection(controller_wiegand_id) → controller_wiegand(id)
- controller_wiegand_connection(elevator_id) → elevator(id)
- controller_wiegand_connection(controller_id) → controller(id)
- group_elevator_stop(group_id) → groups(id)
- group_elevator_stop(elevator_id) → elevator(id)
- group_elevator_stop(elevator_stop_id) → elevator_stop(id)
- group_elevator_stop(floor_id) → floor(id)
- group_elevator_stop(place_id) → place(id)
- camera(place_id) → place(id)
- camera(integration_id) → integration(id)
- camera(lock_id) → lock(id)
- place(user_id) → member(user_id)
- place(organization_id) → organization(id)
- place(transfer_to_id) → member(user_id)
- controller_relay(controller_input_connection_id) → controller_input_connection(id)
- controller_relay(controller_id) → controller(id)
- integration(place_id) → place(id)
- integration(organization_id) → organization(id)
- controller(place_id) → place(id)
- presence(place_id) → place(id)
- controller_relay_connection(controller_relay_id) → controller_relay(id)
- controller_relay_connection(lock_id) → lock(id)
- controller_relay_connection(controller_id) → controller(id)
- wireless_locks(controller_id) → controller(id)
- wireless_locks(lock_id) → lock(id)
- controller_input_connection(controller_input_id) → controller_input(id)
- controller_input_connection(lock_id) → lock(id)
- controller_input_connection(controller_id) → controller(id)
- event(place_id) → place(id)
- event(actor_id) → presence(actor_id)
- event(organization_id) → organization(id)