EN
Español
English
Português
    ADM_COMPONENT_REQUEST_DETAIL

    Stores the detail and execution status of requests

    Data model

    Fields

    Field Type Description
    detail_id* UNIQUEIDENTIFIER Unique identifier of the request detail
    details NVARCHAR (MAX) Additional information or application details
    document_id INT Identifier of the document associated with the request
    download_date DATETIME2 Date of download of the document associated with the application
    modified_date* DATETIME2 Date of last modification of the application
    request_date* DATETIME2 Date of application
    status* TINYINT Current Application Status (In Progress, Completed, Downloaded, Failed, Deleted)
    target_id* INT Identifier of the general information associated with the request
    user_id* INT Identifier of the user who created or modified the record

    Primary Key

    PK_ADM_COMPONENT_REQUEST_DETAIL
    detail_id

    References

    Column Referenced Table Referenced column Name
    document_id dbo.AFW_DOCUMENT docu_id FK02_ADM_COMPONENT_REQUEST_DETAIL
    status* dbo.ADM_COMPONENT_REQUEST_STATUS id FK04_ADM_COMPONENT_REQUEST_DETAIL
    target_id* dbo.ADM_COMPONENT_REQUEST_TARGET target_id FK01_ADM_COMPONENT_REQUEST_DETAIL
    user_id* dbo.AFW_USERS user_id FK03_ADM_COMPONENT_REQUEST_DETAIL