Jump to content
  • 6.1 - Database field definitions

    6.1 - Database field definitions

    VBScript

     

    This is how the PersistentVariables table with it's fields is defined: 

     

    PersistentVariables
    ---------------------------------------------------------------------------------
    PersVarID        int                       unique id of variable
    Name             nvarchar(50)              variable name
    Value            nvarchar(1024) *          value of variable
    Scope            int                       scope of variable ( SCOPE_SCRIPT 1, SCOPE_USER 2, SCOPE_GLOBAL 3, SCOPE_GROUP 4)
    UserID           int *                     SwyxWare UserID of user who is allowed to access this variable (SCOPE_USER)
    GroupID          int *                     SwyxWare GroupID of group which is allowed to access this variable (SCOPE_GROUP)
    NameSpace        nvarchar(128) *           Namespace in which this variable is available (SCOPE_NAMESPACE)
    Created          datetime *                Timestamp of when the variable was initially created in database
    CreatedByName    nvarchar(80)*             Name of caller in call routing script in which the variable was initially created in database
    CreatedByNumber  nvarchar(80)*             Number of caller in call routing script in which the variable was initially created in database
    Modified         datetime *                Timestamp of when the variable was stored last time in database
    ModifiedByName   nvarchar(80)*             Name of caller in call routing script in which the variable was stored last time in database
    ModifiedByNumber nvarchar(80)*             Number of caller in call routing script in which the variable was stored last time in database
    
    * = Allow Nulls

     

     


    Tom Wellige
     Share


     Share




×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and have taken note of our Privacy Policy.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.