Table B–4 lists the data schema values for the SQL Server database type.
Table B–4 Data Schema Values for the SQL Server Database Type
Database Column |
Value |
---|---|
id |
NVARCHAR(50) NOT NULL |
name |
NVARCHAR(128) NOT NULL |
repomod |
DATETIME NOT NULL CURRENT_TIMESTAMP |
resourceName |
NVARCHAR(128) |
accountName |
NVARCHAR(255) |
objectType |
NCHAR(2) |
objectName |
NVARCHAR(128) |
action |
NCHAR(2) |
actionDateTime |
NCHAR(21) |
actionStatus |
NCHAR(1) |
interface |
NVARCHAR(50) |
server |
NVARCHAR(128) |
subject |
NVARCHAR(128) |
reason |
NCHAR(2) |
message |
NVARCHAR(255) or CLOB (See note1 at end of table.) |
acctAttrChanges |
NTEXT |
acctAttr01label |
NVARCHAR(50) |
acctAttr01value |
NVARCHAR(128) |
acctAttr02label |
NVARCHAR(50) |
acctAttr02value |
NVARCHAR(128) |
acctAttr03label |
NVARCHAR(50) |
acctAttr03value |
NVARCHAR(128) |
acctAttr04label |
NVARCHAR(50) |
acctAttr04value |
NVARCHAR(128) |
acctAttr05label |
NVARCHAR(50) |
acctAttr05value |
NVARCHAR(128) |
parm01label |
NVARCHAR(50) |
parm01value |
NVARCHAR(128) or CLOB (See note1 at end of table.) |
parm02label |
NVARCHAR(50) |
parm02value |
NVARCHAR(128) or CLOB (See note1 at end of table.) |
parm03label |
NVARCHAR(50) |
parm03value |
NVARCHAR(128) or CLOB (See note1 at end of table.) |
parm04label |
NVARCHAR(50) |
parm04value |
NVARCHAR(128) or CLOB (See note1 at end of table.) |
parm05label |
NVARCHAR(50) |
parm05value |
NVARCHAR(128) or CLOB (See note1 at end of table.) |
sequence |
NTEXT |
xmlSize |
NUMERIC(19,0) |
xml |
NTEXT |
The column length limit for these columns is configurable. The default data type is VARCHAR and the default size limit is noted in parentheses. See Audit Log Configuration for information on how to adjust the size limit.