# Qmatic Data Connect schema ERD

Table and field reference for the Fivetran Qmatic Data Connect connector.

## Table & Field Reference

### visit_customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| visit_key | Unknown | FK |
| customer_id | Unknown |  |

### feedback_result

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| answer_key | Unknown | FK |
| branch_key | Unknown | FK |
| question_key | Unknown | FK |
| question_type_key | Unknown | FK |
| visit_key | Unknown | FK |
| date_key | Unknown |  |
| event_timestamp | Unknown |  |
| text_answer | Unknown |  |
| time_key | Unknown |  |
| time_seconds | Unknown |  |

### visit_call_type

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

### device_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| branch_key | Unknown | FK |
| date_key | Unknown | FK |
| device_key | Unknown | FK |
| unit_key | Unknown | FK |
| asf_device_status_key | Unknown |  |
| device_connect_duration | Unknown |  |
| device_disconnect_duration | Unknown |  |
| device_num_disconnects | Unknown |  |
| no_data | Unknown |  |

### mark_transaction_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### appointment_start_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### feedback_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### call_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### entry_point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| origin_id | Unknown |  |

### end_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_status_key | Unknown | FK |
| arrival_status_key | Unknown | FK |
| branch_key | Unknown | FK |
| origin_id | Unknown | FK |
| resource_key | Unknown | FK |
| service_key | Unknown | FK |
| cancelled_date_key | Unknown |  |
| client_key | Unknown |  |
| count_service | Unknown |  |
| created_date_key | Unknown |  |
| created_time_key | Unknown |  |
| date_key | Unknown |  |
| days_cancelled_before | Unknown |  |
| days_to_appointment | Unknown |  |
| duration | Unknown |  |
| end_time_key | Unknown |  |
| lateness | Unknown |  |
| start_time_key | Unknown |  |
| tardiness | Unknown |  |
| transaction_time | Unknown |  |
| updated_count | Unknown |  |
| waiting_time | Unknown |  |
| walking_time | Unknown |  |
| wrapup_time | Unknown |  |

### agent_device_controller_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| branch_key | Unknown | FK |
| device_controller_key | Unknown | FK |
| device_controller_status_key | Unknown | FK |
| last_device_controller_event_type_key | Unknown | FK |
| last_event_time | Unknown |  |
| last_status_time | Unknown |  |
| origin_id | Unknown |  |

### service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| origin_id | Unknown |  |

### visit_transaction_outcome

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

### device_controller_event_type

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

### daemon_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status | Unknown |  |

### staff_session_end_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### device_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status | Unknown |  |

### feedback_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| numeric_answer | Unknown |  |
| text_answer | Unknown |  |

### delivered_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_key | Unknown | FK |
| outcome_key | Unknown | FK |
| queue_key | Unknown | FK |
| queue_type_key | Unknown | FK |
| service_key | Unknown | FK |
| service_point_key | Unknown | FK |
| staff_key | Unknown | FK |
| visit_key | Unknown | FK |
| date_key | Unknown |  |
| delivered_service_key | Unknown |  |
| time_key | Unknown |  |
| time_seconds | Unknown |  |
| transaction_time | Unknown |  |
| waiting_time | Unknown |  |

### service_delivereds

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| origin_id | Unknown |  |
| service_delivered | Unknown |  |

### device_event_type

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

### mark_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_key | Unknown | FK |
| mark_key | Unknown | FK |
| mark_type_key | Unknown | FK |
| queue_key | Unknown | FK |
| queue_type_key | Unknown | FK |
| service_key | Unknown | FK |
| service_point_key | Unknown | FK |
| staff_key | Unknown | FK |
| visit_key | Unknown | FK |
| date_key | Unknown |  |
| time_key | Unknown |  |
| time_seconds | Unknown |  |
| transaction_time | Unknown |  |
| waiting_time | Unknown |  |

### jiql_event_type

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

### appointment_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status | Unknown |  |

### mark_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| origin_id | Unknown |  |

### daemon_event_type

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

### fact_agent_jiql_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| date_key | Unknown | FK |
| jiql_event_type_key | Unknown | FK |
| time_key | Unknown | FK |
| asf_agent_status_key | Unknown |  |
| event_timestamp | Unknown |  |
| time_seconds | Unknown |  |

### service_point

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| origin_id | Unknown |  |

### staff_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_key | Unknown | FK |
| session_outcome_key | Unknown | FK |
| staff_key | Unknown | FK |
| date_key | Unknown |  |
| end_time_key | Unknown |  |
| end_timestamp | Unknown |  |
| idle_time | Unknown |  |
| served_count | Unknown |  |
| serving_time | Unknown |  |
| start_timestamp | Unknown |  |
| store_next_time | Unknown |  |
| time_key | Unknown |  |
| time_seconds | Unknown |  |
| total_time | Unknown |  |
| visits_served | Unknown |  |
| wrapup_time | Unknown |  |

### agent_device_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| branch_key | Unknown | FK |
| device_key | Unknown | FK |
| device_status_key | Unknown | FK |
| last_device_event_type_key | Unknown | FK |
| unit_key | Unknown | FK |
| device_event_time | Unknown |  |
| device_status_time | Unknown |  |
| origin_id | Unknown |  |

### dim_unit_type

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

### appointment_service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| service_key | Unknown | FK |
| served | Unknown |  |

### daemon_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| version | Unknown |  |

### staff_session_start_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### dim_device_type

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

### appointment_customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| customer_id | Unknown | FK |
| booked | Unknown |  |
| served | Unknown |  |

### appointment_end_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### delivered_service_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_origin_id | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |

### branch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| city | Unknown |  |
| country | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| time_zone | Unknown |  |

### question_type

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

### appointment_created_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### staff_session_outcome

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

### jiql_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status | Unknown |  |

### time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### queue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| origin_id | Unknown |  |

### mark

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| mark_type_key | Unknown | FK |
| name | Unknown |  |
| origin_id | Unknown |  |

### queue_type

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

### device_controller_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| branch_key | Unknown | FK |
| date_key | Unknown | FK |
| device_controller_key | Unknown | FK |
| asf_dc_status_key | Unknown |  |
| connect_duration | Unknown |  |
| disconnect_duration | Unknown |  |
| no_data | Unknown |  |
| num_disconnects | Unknown |  |

### entered_queue_time

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| am_pm | Unknown |  |
| hour | Unknown |  |
| hour_24 | Unknown |  |
| interval_10_min | Unknown |  |
| interval_10_min_24 | Unknown |  |
| interval_15_min | Unknown |  |
| interval_15_min_24 | Unknown |  |
| interval_30_min | Unknown |  |
| interval_30_min_24 | Unknown |  |
| interval_5_min | Unknown |  |
| interval_5_min_24 | Unknown |  |
| minute | Unknown |  |
| time | Unknown |  |

### staff

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| first_name | Unknown |  |
| full_name | Unknown |  |
| last_name | Unknown |  |
| origin_id | Unknown |  |
| user_name | Unknown |  |

### appointment_arrival_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| arrival_status | Unknown |  |

### device_controller_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| status | Unknown |  |

### jiql_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| version | Unknown |  |

### feedback_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question | Unknown |  |
| start_date | Unknown |  |

### appointment_cancelled_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| day_of_month | Unknown |  |
| day_of_week | Unknown |  |
| day_of_week_name | Unknown |  |
| day_of_week_name_en | Unknown |  |
| full_date | Unknown |  |
| month | Unknown |  |
| month_name | Unknown |  |
| month_name_en | Unknown |  |
| quarter | Unknown |  |
| week_number | Unknown |  |
| week_number_iso | Unknown |  |
| year | Unknown |  |

### agent_daemon_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| daemon_event_type_key | Unknown | FK |
| date_key | Unknown | FK |
| time_key | Unknown | FK |
| asf_agent_status_key | Unknown |  |
| event_timestamp | Unknown |  |
| time_seconds | Unknown |  |

### mark_transaction_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| day_of_month | Unknown |  |
| day_of_week | Unknown |  |
| day_of_week_name | Unknown |  |
| day_of_week_name_en | Unknown |  |
| full_date | Unknown |  |
| month | Unknown |  |
| month_name | Unknown |  |
| month_name_en | Unknown |  |
| quarter | Unknown |  |
| week_number_iso | Unknown |  |
| year | Unknown |  |

### device_controller_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| branch_key | Unknown | FK |
| date_key | Unknown | FK |
| dc_event_type_key | Unknown | FK |
| device_controller_key | Unknown | FK |
| time_key | Unknown | FK |
| asf_dc_status_key | Unknown |  |
| event_timestamp | Unknown |  |
| time_seconds | Unknown |  |

### unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_key | Unknown |  |
| device_controller_key | Unknown |  |
| end_date | Unknown |  |
| logic_id | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| start_date | Unknown |  |
| unit_id | Unknown |  |
| unit_template | Unknown |  |
| unit_type_key | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| unit_key | Unknown | FK |
| device_type_key | Unknown |  |
| end_date | Unknown |  |
| firmware_version | Unknown |  |
| ip | Unknown |  |
| logic_id | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| start_date | Unknown |  |

### date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| day_of_month | Unknown |  |
| day_of_week | Unknown |  |
| day_of_week_name | Unknown |  |
| day_of_week_name_en | Unknown |  |
| full_date | Unknown |  |
| month | Unknown |  |
| month_name | Unknown |  |
| month_name_en | Unknown |  |
| quarter | Unknown |  |
| week_number_iso | Unknown |  |
| year | Unknown |  |

### work_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_origin_id | Unknown |  |
| client_key | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| start_date | Unknown |  |

### appointment_created_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| day_of_month | Unknown |  |
| day_of_week | Unknown |  |
| day_of_week_name | Unknown |  |
| day_of_week_name_en | Unknown |  |
| full_date | Unknown |  |
| month | Unknown |  |
| month_name | Unknown |  |
| month_name_en | Unknown |  |
| quarter | Unknown |  |
| week_number | Unknown |  |
| week_number_iso | Unknown |  |
| year | Unknown |  |

### device_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_key | Unknown | FK |
| branch_key | Unknown | FK |
| date_key | Unknown | FK |
| device_event_type_key | Unknown | FK |
| device_key | Unknown | FK |
| time_key | Unknown | FK |
| unit_key | Unknown | FK |
| asf_device_status_key | Unknown |  |
| event_timestamp | Unknown |  |
| time_seconds | Unknown |  |

### visit_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_key | Unknown | FK |
| entry_point_key | Unknown | FK |
| outcome_key | Unknown | FK |
| queue_key | Unknown | FK |
| queue_type_key | Unknown | FK |
| service_key | Unknown | FK |
| service_point_key | Unknown | FK |
| staff_key | Unknown | FK |
| visit_call_type_key | Unknown | FK |
| visit_key | Unknown | FK |
| visit_outcome_key | Unknown | FK |
| work_profile_key | Unknown | FK |
| call_time_key | Unknown |  |
| call_time_of_day | Unknown |  |
| call_timestamp | Unknown |  |
| date_key | Unknown |  |
| end_time_key | Unknown |  |
| end_time_of_day | Unknown |  |
| enter_queue_time_of_day | Unknown |  |
| entered_queue_time_key | Unknown |  |
| entered_queue_timestamp | Unknown |  |
| is_appointment | Unknown |  |
| recycle_count | Unknown |  |
| service_transaction_time_level | Unknown |  |
| staff_transaction_time | Unknown |  |
| time_seconds | Unknown |  |
| transaction_time | Unknown |  |
| transaction_time_vs_service_level | Unknown |  |
| vertical_message_key | Unknown |  |
| waiting_time | Unknown |  |
| waiting_time_service_level | Unknown |  |
| waiting_time_vs_service_level | Unknown |  |
| walking_time | Unknown |  |
| wrapup_time | Unknown |  |

### agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| daemon_version_key | Unknown | FK |
| jiql_version_key | Unknown | FK |
| end_date | Unknown |  |
| host | Unknown |  |
| name | Unknown |  |
| original_id | Unknown |  |
| start_date | Unknown |  |

### outcome

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_origin_id | Unknown |  |
| client_key | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| start_date | Unknown |  |

### feedback_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| day_of_month | Unknown |  |
| day_of_week | Unknown |  |
| day_of_week_name | Unknown |  |
| day_of_week_name_en | Unknown |  |
| full_date | Unknown |  |
| month | Unknown |  |
| month_name | Unknown |  |
| month_name_en | Unknown |  |
| quarter | Unknown |  |
| week_number_iso | Unknown |  |
| year | Unknown |  |

### device_controller

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_key | Unknown | FK |
| end_date | Unknown |  |
| name | Unknown |  |
| origin_id | Unknown |  |
| start_date | Unknown |  |
| unit_id | Unknown |  |
| unit_template | Unknown |  |

### visit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| created_timestamp | Unknown |  |
| custom_1 | Unknown |  |
| custom_2 | Unknown |  |
| custom_3 | Unknown |  |
| custom_4 | Unknown |  |
| custom_5 | Unknown |  |
| ticket_id | Unknown |  |
| vip_level | Unknown |  |
| visit_type | Unknown |  |

## Relationships

- visit_customer(visit_key) → visit(id)
- feedback_result(question_type_key) → question_type(id)
- feedback_result(question_key) → feedback_question(id)
- feedback_result(visit_key) → visit(id)
- feedback_result(answer_key) → feedback_answer(id)
- feedback_result(branch_key) → branch(id)
- device_time(device_key) → device(id)
- device_time(unit_key) → unit(id)
- device_time(agent_key) → agent(id)
- device_time(date_key) → date(id)
- device_time(branch_key) → branch(id)
- appointment(resource_key) → resource(id)
- appointment(service_key) → service(id)
- appointment(appointment_status_key) → appointment_status(id)
- appointment(origin_id) → appointment(id)
- appointment(branch_key) → branch(id)
- appointment(arrival_status_key) → appointment_arrival_status(id)
- agent_device_controller_status(last_device_controller_event_type_key) → device_controller_event_type(id)
- agent_device_controller_status(agent_key) → agent(id)
- agent_device_controller_status(device_controller_status_key) → device_controller_status(id)
- agent_device_controller_status(branch_key) → branch(id)
- agent_device_controller_status(device_controller_key) → device_controller(id)
- delivered_service(service_point_key) → service_point(id)
- delivered_service(service_key) → service(id)
- delivered_service(outcome_key) → outcome(id)
- delivered_service(visit_key) → visit(id)
- delivered_service(staff_key) → staff(id)
- delivered_service(queue_key) → queue(id)
- delivered_service(branch_key) → branch(id)
- delivered_service(queue_type_key) → queue_type(id)
- mark_transaction(service_point_key) → service_point(id)
- mark_transaction(mark_key) → mark(id)
- mark_transaction(service_key) → service(id)
- mark_transaction(visit_key) → visit(id)
- mark_transaction(staff_key) → staff(id)
- mark_transaction(queue_key) → queue(id)
- mark_transaction(branch_key) → branch(id)
- mark_transaction(mark_type_key) → mark_type(id)
- mark_transaction(queue_type_key) → queue_type(id)
- fact_agent_jiql_event(jiql_event_type_key) → jiql_event_type(id)
- fact_agent_jiql_event(date_key) → date(id)
- fact_agent_jiql_event(agent_key) → agent(id)
- fact_agent_jiql_event(time_key) → time(id)
- staff_session(session_outcome_key) → staff_session_outcome(id)
- staff_session(staff_key) → staff(id)
- staff_session(branch_key) → branch(id)
- agent_device_status(last_device_event_type_key) → device_event_type(id)
- agent_device_status(device_status_key) → device_status(id)
- agent_device_status(device_key) → device(id)
- agent_device_status(unit_key) → unit(id)
- agent_device_status(agent_key) → agent(id)
- agent_device_status(branch_key) → branch(id)
- appointment_service(appointment_id) → appointment(id)
- appointment_service(service_key) → service(id)
- appointment_customer(appointment_id) → appointment(id)
- appointment_customer(customer_id) → visit_customer(id)
- mark(mark_type_key) → mark_type(id)
- device_controller_time(agent_key) → agent(id)
- device_controller_time(date_key) → date(id)
- device_controller_time(branch_key) → branch(id)
- device_controller_time(device_controller_key) → device_controller(id)
- agent_daemon_event(daemon_event_type_key) → daemon_event_type(id)
- agent_daemon_event(date_key) → date(id)
- agent_daemon_event(agent_key) → agent(id)
- agent_daemon_event(time_key) → time(id)
- device_controller_event(dc_event_type_key) → device_event_type(id)
- device_controller_event(agent_key) → agent(id)
- device_controller_event(date_key) → date(id)
- device_controller_event(branch_key) → branch(id)
- device_controller_event(device_controller_key) → device_controller(id)
- device_controller_event(time_key) → time(id)
- device(unit_key) → unit(id)
- device_event(device_key) → device(id)
- device_event(unit_key) → unit(id)
- device_event(agent_key) → agent(id)
- device_event(date_key) → date(id)
- device_event(branch_key) → branch(id)
- device_event(time_key) → time(id)
- device_event(device_event_type_key) → device_event_type(id)
- visit_transaction(entry_point_key) → entry_point(id)
- visit_transaction(service_point_key) → service_point(id)
- visit_transaction(visit_outcome_key) → visit_transaction_outcome(id)
- visit_transaction(service_key) → service(id)
- visit_transaction(visit_call_type_key) → visit_call_type(id)
- visit_transaction(work_profile_key) → work_profile(id)
- visit_transaction(outcome_key) → outcome(id)
- visit_transaction(visit_key) → visit(id)
- visit_transaction(staff_key) → staff(id)
- visit_transaction(queue_key) → queue(id)
- visit_transaction(branch_key) → branch(id)
- visit_transaction(queue_type_key) → queue_type(id)
- agent(jiql_version_key) → jiql_version(id)
- agent(daemon_version_key) → daemon_version(id)
- device_controller(branch_key) → branch(id)
- visit(appointment_id) → appointment(id)