Kisi

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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