Device Magic
Explore the interactive ERD
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 | PKFK |
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 | PKFK |
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 |