|
|
| Line 7: |
Line 7: |
| ---- | | ---- |
| <center> | | <center> |
| {| class="wikitable" | | |
| |+ TeltoHeart Wearable Device
| | == TeltoHeart Wearable Device == |
| | {| class="wikitable" style="border-radius: 10px; overflow: hidden; border-collapse: separate; border-spacing: 0;" |
| ! Data | | ! Data |
| ! Format | | ! Format |
| Line 28: |
Line 29: |
| |} | | |} |
|
| |
|
| {| class="wikitable" | | == TeltoHeart Mobile Application == |
| |+ TeltoHeart Mobile Application
| | {| class="wikitable" style="border-radius: 10px; overflow: hidden; border-collapse: separate; border-spacing: 0;" |
| ! Data | | ! Data |
| ! Format | | ! Format |
| Line 37: |
Line 38: |
| |} | | |} |
|
| |
|
| {| class="wikitable" | | == TeltoCare Web Application == |
| |+ TeltoCare Web Application - User Authentication
| | {| class="wikitable" style="border-radius: 10px; overflow: hidden; border-collapse: separate; border-spacing: 0;" |
| | ! Section |
| ! Data | | ! Data |
| ! Format | | ! Format / Data Type |
| |- | | |- |
| | | rowspan="7" | User Authentication |
| | Id | | | Id |
| | string | | | string |
| Line 62: |
Line 65: |
| | Date of birth | | | Date of birth |
| | string | | | string |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ TeltoCare Web Application - File Storage
| |
| ! Data
| |
| ! Format
| |
| |- | | |- |
| | | rowspan="4" | File Storage |
| | ECG processed data | | | ECG processed data |
| | json file | | | json file |
| Line 82: |
Line 80: |
| |} | | |} |
|
| |
|
| {| class="wikitable" | | == AWS DynamoDB Tables == |
| |+ AWS DynamoDB Tables - Information about events
| | {| class="wikitable" style="border-radius: 10px; overflow: hidden; border-collapse: separate; border-spacing: 0;" |
| | ! Table |
| ! Column Name | | ! Column Name |
| ! Data Type | | ! Data Type |
| |- | | |- |
| | | rowspan="6" | Information about events |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 104: |
Line 104: |
| | Updated | | | Updated |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Information about events
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="6" | HR data (events) |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 128: |
Line 123: |
| | ttl | | | ttl |
| | INTEGER | | | INTEGER |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Configured triggers for events
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="11" | Configured triggers for events |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 167: |
Line 157: |
| | Value | | | Value |
| | INTEGER | | | INTEGER |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Comments left on ECGs by doctors
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="6" | Comments left on ECGs by doctors |
| | ECG | | | ECG |
| | STRING | | | STRING |
| Line 191: |
Line 176: |
| | Patient_cognito_id | | | Patient_cognito_id |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Invitations sent to request to join a hospital
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="5" | Invitations sent to request to join a hospital |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 212: |
Line 192: |
| | Hospital_id | | | Hospital_id |
| | INTEGER | | | INTEGER |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - User login attempts
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="10" | User login attempts |
| | Cognito_id | | | Cognito_id |
| | STRING | | | STRING |
| Line 248: |
Line 223: |
| | Version | | | Version |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - User-requested logs
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="8" | User-requested logs |
| | Created_by_sub | | | Created_by_sub |
| | STRING | | | STRING |
| Line 278: |
Line 248: |
| | Serial_number | | | Serial_number |
| | INTEGER | | | INTEGER |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - PPG data information
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="4" | PPG data information |
| | Timestamp | | | Timestamp |
| | DATETIME | | | DATETIME |
| Line 296: |
Line 261: |
| | Fullpath | | | Fullpath |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - AFIB data information
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="12" | AFIB data information |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 338: |
Line 298: |
| | Timestamp | | | Timestamp |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - ECG data information
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="9" | ECG data information |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 371: |
Line 326: |
| | User | | | User |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - HR data information
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="8" | HR data information |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 401: |
Line 351: |
| | User | | | User |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Steps data information
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="7" | Steps data information |
| | Id | | | Id |
| | STRING | | | STRING |
| Line 428: |
Line 373: |
| | Steps | | | Steps |
| | INTEGER | | | INTEGER |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Timezones that a user selected
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="4" | Timezones that a user selected |
| | Cognito Id | | | Cognito Id |
| | STRING | | | STRING |
| Line 446: |
Line 386: |
| | Timezone | | | Timezone |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Roles assigned to users
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | Roles assigned to users |
| | Cognito Id | | | Cognito Id |
| | STRING | | | STRING |
| Line 461: |
Line 396: |
| | Roles_id | | | Roles_id |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - User’s firmware and legal agreement confirmation details
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="12" | User firmware and legal agreement confirmation details |
| | Cognito Id | | | Cognito Id |
| | STRING | | | STRING |
| Line 503: |
Line 433: |
| | Tc_available | | | Tc_available |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Babel
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | Babel |
| | Cognito Id | | | Cognito Id |
| | STRING | | | STRING |
| Line 518: |
Line 443: |
| | Email | | | Email |
| | STRING | | | STRING |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS DynamoDB Tables - Rest API endpoint usage logs
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="7" | Rest API endpoint usage logs |
| | Created_by_sub | | | Created_by_sub |
| | STRING | | | STRING |
| Line 547: |
Line 467: |
| |} | | |} |
|
| |
|
| {| class="wikitable" | | == AWS Aurora PostgreSQL Database == |
| |+ AWS Aurora PostgreSQL Database - tasks
| | {| class="wikitable" style="border-radius: 10px; overflow: hidden; border-collapse: separate; border-spacing: 0;" |
| | ! Table |
| ! Column Name | | ! Column Name |
| ! Data Type | | ! Data Type |
| |- | | |- |
| | | rowspan="7" | tasks |
| | id | | | id |
| | INT | | | INT |
| Line 572: |
Line 494: |
| | user_id | | | user_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - task_types_status
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="2" | task_types_status |
| | id | | | id |
| | INT | | | INT |
| Line 584: |
Line 501: |
| | name | | | name |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - patients_copy
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="13" | patients_copy |
| | id | | | id |
| | INT | | | INT |
| Line 629: |
Line 541: |
| | allergies | | | allergies |
| | TEXT | | | TEXT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - patients_status
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="4" | patients_status |
| | id | | | id |
| | INT | | | INT |
| Line 647: |
Line 554: |
| | status_date | | | status_date |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - distributors_copy
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | distributors_copy |
| | id | | | id |
| | INT | | | INT |
| Line 662: |
Line 564: |
| | user_id | | | user_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - statuses
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | statuses |
| | id | | | id |
| | INT | | | INT |
| Line 677: |
Line 574: |
| | status_code | | | status_code |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - doctors_copy
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | doctors_copy |
| | id | | | id |
| | INT | | | INT |
| Line 692: |
Line 584: |
| | user_id | | | user_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - watches
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="6" | watches |
| | id | | | id |
| | INT | | | INT |
| Line 716: |
Line 603: |
| | serial_number | | | serial_number |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - watch_subscription
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="8" | watch_subscription |
| | id | | | id |
| | INT | | | INT |
| Line 746: |
Line 628: |
| | updated_at | | | updated_at |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - subscription_models
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="5" | subscription_models |
| | id | | | id |
| | INT | | | INT |
| Line 767: |
Line 644: |
| | updated_at | | | updated_at |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - hospitals_copy
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="6" | hospitals_copy |
| | id | | | id |
| | INT | | | INT |
| Line 791: |
Line 663: |
| | delete_due_to | | | delete_due_to |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - subscription_functionalities
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="4" | subscription_functionalities |
| | id | | | id |
| | INT | | | INT |
| Line 809: |
Line 676: |
| | created_at | | | created_at |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - funcionalidades
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="5" | funcionalidades |
| | id | | | id |
| | INT | | | INT |
| Line 830: |
Line 692: |
| | updated_at | | | updated_at |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - firmwares
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="8" | firmwares |
| | id | | | id |
| | INT | | | INT |
| Line 860: |
Line 717: |
| | fw | | | fw |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - alerts
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="6" | alerts |
| | id | | | id |
| | INT | | | INT |
| Line 884: |
Line 736: |
| | updated | | | updated |
| | DATETIME | | | DATETIME |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - triggers
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="9" | triggers |
| | id | | | id |
| | INT | | | INT |
| Line 917: |
Line 764: |
| | priority_id | | | priority_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - priority_levels
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="2" | priority_levels |
| | id | | | id |
| | INT | | | INT |
| Line 929: |
Line 771: |
| | name | | | name |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - users
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="14" | users |
| | id | | | id |
| | INT | | | INT |
| Line 977: |
Line 814: |
| | tc_id | | | tc_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - user_permissions
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="2" | user_permissions |
| | user_id | | | user_id |
| | INT | | | INT |
| Line 989: |
Line 821: |
| | permission_id | | | permission_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - user_data_list
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="11" | user_data_list |
| | user_id | | | user_id |
| | INT | | | INT |
| Line 1,028: |
Line 855: |
| | afibburden_visible | | | afibburden_visible |
| | BOOLEAN | | | BOOLEAN |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - roles_permissions
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | roles_permissions |
| | role_id | | | role_id |
| | INT | | | INT |
| Line 1,043: |
Line 865: |
| | permission_priority | | | permission_priority |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - permissions
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | permissions |
| | id | | | id |
| | INT | | | INT |
| Line 1,058: |
Line 875: |
| | permission_name | | | permission_name |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - roles
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="3" | roles |
| | id | | | id |
| | INT | | | INT |
| Line 1,073: |
Line 885: |
| | ref_table | | | ref_table |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - permission_groups
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="2" | permission_groups |
| | id | | | id |
| | INT | | | INT |
| Line 1,085: |
Line 892: |
| | name | | | name |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - task_status
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="2" | task_status |
| | id | | | id |
| | INT | | | INT |
| Line 1,097: |
Line 899: |
| | name | | | name |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - task_types_requests
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="2" | task_types_requests |
| | id | | | id |
| | INT | | | INT |
| Line 1,109: |
Line 906: |
| | name | | | name |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - privacy_policies
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="8" | privacy_policies |
| | id | | | id |
| | INT | | | INT |
| Line 1,139: |
Line 931: |
| | is_valid | | | is_valid |
| | BOOLEAN | | | BOOLEAN |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - terms_conditions
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="8" | terms_conditions |
| | id | | | id |
| | INT | | | INT |
| Line 1,169: |
Line 956: |
| | is_valid | | | is_valid |
| | BOOLEAN | | | BOOLEAN |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - tokens
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="4" | tokens |
| | id | | | id |
| | INT | | | INT |
| Line 1,187: |
Line 969: |
| | token_type | | | token_type |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - user_options
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="6" | user_options |
| | id | | | id |
| | INT | | | INT |
| Line 1,211: |
Line 988: |
| | delete_due_to | | | delete_due_to |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - org_hospitals
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="15" | org_hospitals |
| | id | | | id |
| | INT | | | INT |
| Line 1,262: |
Line 1,034: |
| | notification_email | | | notification_email |
| | VARCHAR | | | VARCHAR |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - org_distributors
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="10" | org_distributors |
| | id | | | id |
| | INT | | | INT |
| Line 1,298: |
Line 1,065: |
| | main_admin_id | | | main_admin_id |
| | INT | | | INT |
| |}
| |
|
| |
| {| class="wikitable"
| |
| |+ AWS Aurora PostgreSQL Database - countries
| |
| ! Column Name
| |
| ! Data Type
| |
| |- | | |- |
| | | rowspan="5" | countries |
| | id | | | id |
| | INT | | | INT |
| Line 1,320: |
Line 1,082: |
| | VARCHAR | | | VARCHAR |
| |} | | |} |
| | |
| </center> | | </center> |
Introduction to EU Data Act
The EU Data Act (Regulation (EU) 2023/2854) establishes harmonised rules to ensure fair access to and use of data generated by connected products and related services. As a manufacturer of connected hardware and a provider of remote management and monitoring solutions, Teltonika Telemedic is directly subject to these requirements. This document explains what data is generated by Teltonika Telemedic devices and services, as well as the conditions under which it is collected or accessed.
Our Obligations under the Data Act
In accordance with Regulation (EU) 2023/2854, we affirm our commitment to respecting these principles. We will not use customer data to compete against them or to obtain unfair advantages, nor will we impose restrictions that prevent access to or transfer of their data. We will provide clear information on what data is available and the ways in which it can be accessed, and we will ensure the availability of interoperable interfaces—such as APIs or data export functions—to facilitate effective data portability.
TeltoHeart Wearable Device
| Data
|
Format
|
| ECG raw data
|
ecg binary file
|
| HR raw data
|
hr binary file
|
| Sys logs
|
rst binary file
|
| Pedometer raw data
|
ped binary file
|
| PQ (ppg quality) raw data
|
pq binary file
|
TeltoHeart Mobile Application
| Data
|
Format
|
| Sys logs
|
log text file
|
TeltoCare Web Application
| Section
|
Data
|
Format / Data Type
|
| User Authentication
|
Id
|
string
|
| Name
|
string
|
| Surname
|
string
|
| Email
|
string
|
| Phone number
|
string
|
| Gender
|
string
|
| Date of birth
|
string
|
| File Storage
|
ECG processed data
|
json file
|
| HR processed data
|
json file
|
| Pedometer processed data
|
json file
|
| PQ (ppg quality) processed data
|
json file
|
AWS DynamoDB Tables
| Table
|
Column Name
|
Data Type
|
| Information about events
|
Id
|
STRING
|
| Seen
|
BOOLEAN
|
| Started
|
DATETIME
|
| Active
|
BOOLEAN
|
| Trigger Id
|
INTEGER
|
| Updated
|
DATETIME
|
| HR data (events)
|
Id
|
STRING
|
| Timestamp
|
DATETIME
|
| Max
|
INTEGER
|
| Min
|
INTEGER
|
| Reference_key
|
STRING
|
| ttl
|
INTEGER
|
| Configured triggers for events
|
Id
|
STRING
|
| Cognito Id
|
STRING
|
| Alert_type
|
STRING
|
| Condition
|
STRING
|
| Duration
|
INTEGER
|
| Enabled
|
BOOLEAN
|
| Notifications
|
BOOLEAN
|
| Priority_id
|
INTEGER
|
| Priority_name
|
STRING
|
| Timestamp
|
DATETIME
|
| Value
|
INTEGER
|
| Comments left on ECGs by doctors
|
ECG
|
STRING
|
| Timestamp
|
DATETIME
|
| Comment
|
STRING
|
| First_name
|
STRING
|
| Last_name
|
STRING
|
| Patient_cognito_id
|
STRING
|
| Invitations sent to request to join a hospital
|
Id
|
STRING
|
| Cognito_Id
|
STRING
|
| Added_at
|
DATETIME
|
| Hospital_cognito_id
|
STRING
|
| Hospital_id
|
INTEGER
|
| User login attempts
|
Cognito_id
|
STRING
|
| Timestamp
|
DATETIME
|
| Email
|
STRING
|
| Email_verified
|
BOOLEAN
|
| Attempt_status
|
BOOLEAN
|
| User_not_found
|
BOOLEAN
|
| User_pool_id
|
STRING
|
| User_account_status
|
BOOLEAN
|
| Username
|
STRING
|
| Version
|
STRING
|
| User-requested logs
|
Created_by_sub
|
STRING
|
| Timestamp
|
DATETIME
|
| Added_at
|
DATETIME
|
| Created_by
|
BOOLEAN
|
| Created_by_email
|
STRING
|
| Log_type
|
BOOLEAN
|
| Path
|
STRING
|
| Serial_number
|
INTEGER
|
| PPG data information
|
Timestamp
|
DATETIME
|
| Data
|
STRING
|
| Duration
|
INTEGER
|
| Fullpath
|
STRING
|
| AFIB data information
|
Id
|
STRING
|
| User
|
STRING
|
| Avg
|
INTEGER
|
| Data
|
STRING
|
| Duration
|
INTEGER
|
| Firmware
|
STRING
|
| Fullpath
|
STRING
|
| Max
|
INTEGER
|
| Min
|
INTEGER
|
| Serial_number
|
INTEGER
|
| Termination_reason
|
BOOLEAN
|
| Timestamp
|
DATETIME
|
| ECG data information
|
Id
|
STRING
|
| Circumstances
|
STRING[]
|
| Data
|
STRING
|
| Filter information
|
STRING
|
| Firmware
|
STRING
|
| Frequency
|
INTEGER
|
| Fullpath
|
STRING
|
| Timestamp
|
DATETIME
|
| User
|
STRING
|
| HR data information
|
Id
|
STRING
|
| Data
|
STRING
|
| Firmware
|
STRING
|
| Fullpath
|
STRING
|
| Max
|
INTEGER
|
| Min
|
INTEGER
|
| Timestamp
|
DATETIME
|
| User
|
STRING
|
| Steps data information
|
Id
|
STRING
|
| Cognito Id
|
STRING
|
| Timestamp
|
DATETIME
|
| Added_at
|
DATETIME
|
| Device_timestamp
|
DATETIME
|
| Fullpath
|
STRING
|
| Steps
|
INTEGER
|
| Timezones that a user selected
|
Cognito Id
|
STRING
|
| Added_at
|
STRING
|
| Email
|
STRING
|
| Timezone
|
STRING
|
| Roles assigned to users
|
Cognito Id
|
STRING
|
| Added_at
|
STRING
|
| Roles_id
|
STRING
|
| User firmware and legal agreement confirmation details
|
Cognito Id
|
STRING
|
| Added_at
|
DATETIME
|
| Firmware
|
STRING
|
| Firmware_available
|
STRING
|
| Last_seen
|
DATETIME
|
| Pp_accepted_date
|
DATETIME
|
| Pp_actual
|
STRING
|
| Pp_available
|
STRING
|
| Serial_number
|
INTEGER
|
| Tc_accept_date
|
DATETIME
|
| Tc_actual
|
STRING
|
| Tc_available
|
STRING
|
| Babel
|
Cognito Id
|
STRING
|
| Device_token
|
STRING
|
| Email
|
STRING
|
| Rest API endpoint usage logs
|
Created_by_sub
|
STRING
|
| Timestamp
|
DATETIME
|
| Added_at
|
DATETIME
|
| Email
|
STRING
|
| Event
|
STRING
|
| Log type
|
STRING
|
| Source
|
STRING
|
AWS Aurora PostgreSQL Database
| Table
|
Column Name
|
Data Type
|
| tasks
|
id
|
INT
|
| created_by
|
INT
|
| task_type
|
INT
|
| date_created
|
DATETIME
|
| task_status
|
INT
|
| patient_id
|
INT
|
| user_id
|
INT
|
| task_types_status
|
id
|
INT
|
| name
|
VARCHAR
|
| patients_copy
|
id
|
INT
|
| hospital_id
|
INT
|
| user_id
|
INT
|
| doctor_id
|
INT
|
| blood_type
|
VARCHAR
|
| height
|
DECIMAL
|
| weight
|
DECIMAL
|
| fw
|
VARCHAR
|
| emergency_contact_person
|
VARCHAR
|
| emergency_contact_phone
|
VARCHAR
|
| languages
|
VARCHAR
|
| medical_conditions
|
TEXT
|
| allergies
|
TEXT
|
| patients_status
|
id
|
INT
|
| patient_id
|
INT
|
| reason
|
VARCHAR
|
| status_date
|
DATETIME
|
| distributors_copy
|
id
|
INT
|
| distributor_id
|
INT
|
| user_id
|
INT
|
| statuses
|
id
|
INT
|
| status_name
|
VARCHAR
|
| status_code
|
VARCHAR
|
| doctors_copy
|
id
|
INT
|
| hospital_id
|
INT
|
| user_id
|
INT
|
| watches
|
id
|
INT
|
| is_active
|
BOOLEAN
|
| hospital_id
|
INT
|
| watches_identifier
|
VARCHAR
|
| user_id
|
INT
|
| serial_number
|
VARCHAR
|
| watch_subscription
|
id
|
INT
|
| watch_id
|
INT
|
| subscription_model_id
|
INT
|
| default_subscription_id
|
INT
|
| sub_expiration
|
DATETIME
|
| config_status
|
VARCHAR
|
| created_at
|
DATETIME
|
| updated_at
|
DATETIME
|
| subscription_models
|
id
|
INT
|
| name
|
VARCHAR
|
| description
|
TEXT
|
| created_at
|
DATETIME
|
| updated_at
|
DATETIME
|
| hospitals_copy
|
id
|
INT
|
| distributor_id
|
INT
|
| hospital_id
|
INT
|
| user_id
|
INT
|
| is_active
|
BOOLEAN
|
| delete_due_to
|
VARCHAR
|
| subscription_functionalities
|
id
|
INT
|
| subscription_model_id
|
INT
|
| functionality_id
|
INT
|
| created_at
|
DATETIME
|
| funcionalidades
|
id
|
INT
|
| category
|
VARCHAR
|
| name
|
VARCHAR
|
| created_at
|
DATETIME
|
| updated_at
|
DATETIME
|
| firmwares
|
id
|
INT
|
| bucket
|
VARCHAR
|
| filename
|
VARCHAR
|
| description
|
TEXT
|
| release_notes
|
TEXT
|
| file_size
|
BIGINT
|
| date_created
|
DATETIME
|
| fw
|
VARCHAR
|
| alerts
|
id
|
INT
|
| started
|
DATETIME
|
| duration
|
INT
|
| marker
|
VARCHAR
|
| trigger_id
|
INT
|
| updated
|
DATETIME
|
| triggers
|
id
|
INT
|
| timestamp
|
DATETIME
|
| alert_type
|
VARCHAR
|
| condition
|
VARCHAR
|
| value
|
VARCHAR
|
| cognito_id
|
INT
|
| status
|
VARCHAR
|
| enabled
|
BOOLEAN
|
| priority_id
|
INT
|
| priority_levels
|
id
|
INT
|
| name
|
VARCHAR
|
| users
|
id
|
INT
|
| country_id
|
INT
|
| role_id
|
INT
|
| first_name
|
VARCHAR
|
| last_name
|
VARCHAR
|
| birth_date
|
DATE
|
| gender
|
VARCHAR
|
| email
|
VARCHAR
|
| phone
|
VARCHAR
|
| cognito_id
|
INT
|
| status
|
VARCHAR
|
| delete_date
|
DATETIME
|
| delete_date_to
|
DATETIME
|
| tc_id
|
INT
|
| user_permissions
|
user_id
|
INT
|
| permission_id
|
INT
|
| user_data_list
|
user_id
|
INT
|
| hr_order
|
INT
|
| hr_visible
|
BOOLEAN
|
| events_order
|
INT
|
| events_visible
|
BOOLEAN
|
| ecg_order
|
INT
|
| ecg_visible
|
BOOLEAN
|
| steps_order
|
INT
|
| steps_visible
|
BOOLEAN
|
| afibburden_order
|
INT
|
| afibburden_visible
|
BOOLEAN
|
| roles_permissions
|
role_id
|
INT
|
| permission_id
|
INT
|
| permission_priority
|
INT
|
| permissions
|
id
|
INT
|
| group_id
|
INT
|
| permission_name
|
VARCHAR
|
| roles
|
id
|
INT
|
| role_name
|
VARCHAR
|
| ref_table
|
VARCHAR
|
| permission_groups
|
id
|
INT
|
| name
|
VARCHAR
|
| task_status
|
id
|
INT
|
| name
|
VARCHAR
|
| task_types_requests
|
id
|
INT
|
| name
|
VARCHAR
|
| privacy_policies
|
id
|
INT
|
| version
|
VARCHAR
|
| content
|
TEXT
|
| author
|
VARCHAR
|
| date_created
|
DATETIME
|
| accepted
|
BOOLEAN
|
| not_accepted
|
BOOLEAN
|
| is_valid
|
BOOLEAN
|
| terms_conditions
|
id
|
INT
|
| version
|
VARCHAR
|
| content
|
TEXT
|
| author
|
VARCHAR
|
| date_created
|
DATETIME
|
| accepted
|
BOOLEAN
|
| not_accepted
|
BOOLEAN
|
| is_valid
|
BOOLEAN
|
| tokens
|
id
|
INT
|
| token
|
VARCHAR
|
| cognito_id
|
INT
|
| token_type
|
VARCHAR
|
| user_options
|
id
|
INT
|
| cognito_id
|
INT
|
| user_type
|
VARCHAR
|
| status
|
VARCHAR
|
| delete_date
|
DATETIME
|
| delete_due_to
|
VARCHAR
|
| org_hospitals
|
id
|
INT
|
| distributor_id
|
INT
|
| hospital_name
|
VARCHAR
|
| email
|
VARCHAR
|
| phone
|
VARCHAR
|
| address
|
VARCHAR
|
| country_id
|
INT
|
| is_active
|
BOOLEAN
|
| main_admin_id
|
INT
|
| status
|
VARCHAR
|
| delete_date
|
DATETIME
|
| delete_due_to
|
VARCHAR
|
| description
|
TEXT
|
| visibility
|
VARCHAR
|
| notification_email
|
VARCHAR
|
| org_distributors
|
id
|
INT
|
| distributor_name
|
VARCHAR
|
| email
|
VARCHAR
|
| phone
|
VARCHAR
|
| address
|
VARCHAR
|
| country_id
|
INT
|
| status
|
VARCHAR
|
| delete_date
|
DATETIME
|
| delete_due_to
|
VARCHAR
|
| main_admin_id
|
INT
|
| countries
|
id
|
INT
|
| name
|
VARCHAR
|
| code
|
VARCHAR
|
| code3
|
VARCHAR
|
| number
|
VARCHAR
|