# Device Magic schema ERD

Table and field reference for the Fivetran Device Magic connector.

## Table & Field Reference

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| groups | Unknown |  |
| identifier | Unknown |  |
| organization_id | Unknown |  |
| owner | Unknown |  |
| pending_approval | Unknown |  |
| custom_** |  |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| groups | Unknown |  |
| name | Unknown |  |
| namespace | Unknown |  |
| organization_id | Unknown |  |
| version | Unknown |  |

### device_magic_database

| Column | Type | Keys |
| --- | --- | --- |
| submission_id | Unknown | PK |
| form_id | Unknown | PK, FK |
| author_identifier | Unknown |  |
| device_identifier | Unknown |  |
| device_submission_identifier | Unknown |  |
| received_at | Unknown |  |
| submission | Json |  |
| submission_counter | Unknown |  |
| submitted_at | Unknown |  |
| user_id | Unknown |  |
| username | Unknown |  |

### form_definition

| Column | Type | Keys |
| --- | --- | --- |
| identifier | Unknown | PK |
| form_id | Unknown | PK, FK |
| auto_identifier | Unknown |  |
| calculate_expr | Unknown |  |
| children | Json |  |
| hidden | Unknown |  |
| hint | Unknown |  |
| initial_answer | Unknown |  |
| max_occurrence | Unknown |  |
| min_occurrence | Unknown |  |
| options | Json |  |
| options_identifier_column | Unknown |  |
| options_resource | Unknown |  |
| options_table | Unknown |  |
| options_text_column | Unknown |  |
| readonly_rule | Unknown |  |
| required_rule | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| type_derived | Unknown |  |
| validate_expr | Unknown |  |
| validate_msg | Unknown |  |
| visible_expr | Unknown |  |
| visible_rule | Unknown |  |

## Relationships

- device_magic_database(form_id) → form(id)
- form_definition(form_id) → form(id)