EN
Español
English
Português
    AMDM_DEVICEMODELS

    Store mobile device models

    Data model

    Fields

    Field Type Description
    battery_tech NVARCHAR (100) Battery Technology
    battery_voltage NVARCHAR (40) Battery voltage
    commercialname VARCHAR (64) Commercial name of the model (e.g. iPhone 13 Pro)
    cpu_cores INT CPU cores
    cpu_frequency BIGINT CPU Frequency
    cpu_name NVARCHAR (200) CPU Name
    id* INT Unique device model identifier
    manufacturer_id INT Device manufacturer (reference to AMDM_MOBILEMANUFACTURERS)
    name VARCHAR (64) Internal model identifier (e.g. iPhone14.2)
    platform_id* INT Device Platform (Reference to AMDM_DEVICEPLATFORM)
    screen_resolution NVARCHAR (40) Screen Resolution
    screen_size NVARCHAR (20) Screen size

    Primary Key

    PK_AMDMDEVICEMODELS
    id

    References

    Column Referenced Table Referenced column Name
    manufacturer_id dbo.AMDM_MOBILEMANUFACTURERS mobman_id FK02_AMDMDEVICEMODELS
    platform_id* dbo.AMDM_DEVICEPLATFORM platf_id FK01_AMDMDEVICEMODELS