EN
Español
English
Português
    ASDK_SHOPPING_CART

    Contains the case shopping cart information

    Data model

    Fields

    Field Type Description
    category_id INT Category ID of the case created in the cart
    creation_date* DATETIME Date Case Created in Cart
    id* INT Unique case identifier in the shopping cart
    item_id INT Case ID created in cart
    json_error VARCHAR (MAX) Error data if generated when creating the case
    json_value VARCHAR (MAX) Case data in JSON format
    modification_date DATETIME Date of modification of the case in the cart
    project_id INT Project ID of the case created in the cart
    service_id INT Service ID of the case created in the cart
    status* INT Status of the case inside the cart
    subject VARCHAR (MAX) Subject of the case created in the cart
    user_id* INT Identifier of the user who registers the case in the cart

    Primary Key

    PK_ASDK_SHOPPING_CART
    id

    References

    Column Referenced Table Referenced column Name
    category_id dbo.ASDK_CATEGORY ctg_index FK05_ASDK_SHOPPING_CART
    item_id dbo.ASDK_ITEM_DW_LAST_OLD id FK02_ASDK_SHOPPING_CART
    project_id dbo.ASMS_PROJECTS proj_id FK03_ASDK_SHOPPING_CART
    service_id dbo.ASDK_SERVICE id FK04_ASDK_SHOPPING_CART
    user_id* dbo.AFW_USERS user_id FK01_ASDK_SHOPPING_CART