device


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INTEGER 2000000000 √ √ null
api_import_strategy_source.device_id R
api_session.device_id C
csv_import_metadata.device_id R
csv_import_strategy_source.device_id R
entity_source.device_id R
import_directory.device_id N
import_directory_source.device_id R
qif_import_metadata.device_id R
platform_id INTEGER 2000000000 null
platform.id R
os_id INTEGER 2000000000 √ null
os.id R
machine_id INTEGER 2000000000 √ null
machine.id R
device_make_id INTEGER 2000000000 √ null
device_make.id R
device_model_id INTEGER 2000000000 √ null
device_model.id R

Indexes

Constraint Name Type Sort Column(s)
device_s_pk Primary key Asc id
idx_device_lookup Performance Asc/Asc/Asc/Asc/Asc platform_id + os_id + machine_id + device_make_id + device_model_id
idx_device_platform Performance Asc platform_id
sqlite_autoindex_device_1 Must be unique Asc/Asc/Asc/Asc/Asc platform_id + os_id + machine_id + device_make_id + device_model_id

Relationships

Close relationships within degrees of separation