SQL Server Database Type

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 note¹ 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 note¹ at end of table.)

parm02label

NVARCHAR(50)

parm02value

NVARCHAR(128) or CLOB (See note¹ at end of table.)

parm03label

NVARCHAR(50)

parm03value

NVARCHAR(128) or CLOB (See note¹ at end of table.)

parm04label

NVARCHAR(50)

parm04value

NVARCHAR(128) or CLOB (See note¹ at end of table.)

parm05label

NVARCHAR(50)

parm05value

NVARCHAR(128) or CLOB (See note¹ at end of table.)

sequence

NTEXT

xmlSize

NUMERIC(19,0)

xml

NTEXT