Documentation/EHI_Export/docs/tables/comlink_telehealth_auth.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
| | | username | VARCHAR | 64 | | | null |
|
|
Username used for external access
| | user_id | BIGINT | 19 | √ | | NULL |
|
|
Foreign key reference to users.id
| | patient_id | BIGINT | 19 | √ | | NULL |
|
|
Foreign key reference to patient_data.id
| | auth_token | TEXT | 65535 | | | null |
|
|
external authorization token to use telehealth api
| | date_registered | DATETIME | 19 | √ | | NULL |
|
|
The date the user or patient registered with the api
| | date_created | DATETIME | 19 | | | current_timestamp() |
|
|
Date the record was created
| | date_updated | DATETIME | 19 | | | current_timestamp() |
|
|
Date the record was created
| | active | BOOLEAN | 3 | | | 1 |
|
|
If the record is currently activated or not
| | app_registration_code | TEXT | 65535 | √ | | NULL |
|
|
mobile app registration code
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |