EN
Español
English
Português
    AFLS_USERS_SPECIALISTS

    Table for user registration in AFLS of the specialist type

    Data model

    Fields

    Field Type Description
    grou_id INT Field to identify the headquarters or winery associated with the specialist.
    posi_id* INT A field that serves to identify the position (name of the position) of the specialist.
    spc_initial_address NVARCHAR (400) Field for Specialist Initial Address Registration
    spc_initial_latitude DECIMAL Field for latitude recording
    spc_initial_longitude DECIMAL Field for Length Recording
    spc_last_availability_mod DATETIME Date of last modification of the Specialist skill.
    spc_last_service_request DATETIME Field for last date of service request.
    spc_platform NVARCHAR (100) Field for platform registration associated with the specialist user (Android, IOS)
    spc_provider_id INT Field to identify the group of specialists to which the specialist belongs.
    spc_push_id NVARCHAR (1000) Field for registration of the push id, this in order to know which push was sent to the different platforms (Android, iOS)
    user_id* INT Primary Table Key with Specscialist User ID
    vehi_id* INT Field to identify if the specialist user has any vehicle associated with it.

    Primary Key

    PK_AFLS_USERS_SPECIALISTS
    user_id

    References

    Column Referenced Table Referenced column Name
    grou_id dbo.AFLS_INVENTORY_LOCATION_INFO grou_id FK05_AFLS_USERS_SPECIALISTS
    posi_id* dbo.AFLS_WORK_POSITIONS posi_id FK03_AFLS_USERS_SPECIALISTS
    spc_provider_id dbo.AFLS_PROVIDERS providerid FK04_AFLS_USERS_SPECIALISTS
    user_id* dbo.AFW_USERS user_id FK01_AFLS_USERS_SPECIALISTS
    vehi_id* dbo.AFLS_VEHICLE_TYPE vehi_id FK02_AFLS_USERS_SPECIALISTS