EN
Español
English
Português
    ASDK_IMPORTS

    Contains bulk upload information

    Data model

    Fields

    Field Type Description
    bulk_batch_size INT Determines the size to use in database transactions when creating projects
    date_end DATETIME Upload end date
    date_import* DATETIME Date on which the upload is carried out
    date_scheduled_execution DATETIME Scheduled execution date of an upload
    file VARBINARY Binary file
    file_name* VARCHAR (255) Name of the uploaded file
    has_exception_model BIT Indicates if the model file has errors
    has_exception_project BIT Indicates if the project file has errors
    id* INT Unique Upload Identifier
    json_models_details VARCHAR (MAX) Represents a json object that contains the errors of the models
    json_projects_details VARCHAR (MAX) Represents a json object that contains project errors
    number_files TINYINT Indicates the number of files in the upload
    project_id INT Identifier of the project to which the upload belongs, references the table ASMS_PROJECTS.proj_id
    scheduled_exec_prevalidation BIT Indicates if an upload with a schedule date has already been validated
    state BIT Current Upload Status
    type_id INT Upload type identifier, reference the ASMS_TYPES.id table
    user_id INT Identifier of the user performing the upload, reference the table AFW_USERS.user_id

    Primary Key

    PK_ASDK_IMPORTS
    id

    References

    Column Referenced Table Referenced column Name
    project_id dbo.ASMS_PROJECTS proj_id FK03_ASDK_IMPORTS
    type_id dbo.ASMS_TYPES id FK02_ASDK_IMPORTS
    user_id dbo.AFW_USERS user_id FK01_ASDK_IMPORTS