Table AD_Alert
PRIMARY KEY
AD_Alert_ID
NUMBER (10, 0)
NOT NULL
AD_Client_ID
NUMBER (10, 0)
NOT NULL
AD_Org_ID
NUMBER (10, 0)
NOT NULL
IsActive
CHAR (1)
default: 'Y'
CHECK ( IsActive in ( 'Y' , 'N' ))
NOT NULL
Created
DATE
default: SYSDATE
NOT NULL
CreatedBy
NUMBER (10, 0)
NOT NULL
Updated
DATE
default: SYSDATE
NOT NULL
UpdatedBy
NUMBER (10, 0)
NOT NULL
Name
NVARCHAR2 (60)
NOT NULL
Description
NVARCHAR2 (255)
Help
NVARCHAR2 (2000)
AlertSubject
NVARCHAR2 (60)
NOT NULL
AlertMessage
NVARCHAR2 (2000)
NOT NULL
EnforceClientSecurity
CHAR (1)
default: 'Y'
CHECK ( EnforceClientSecurity in ( 'Y' , 'N' ))
NOT NULL
EnforceRoleSecurity
CHAR (1)
default: 'Y'
CHECK ( EnforceRoleSecurity in ( 'Y' , 'N' ))
NOT NULL
AD_AlertProcessor_ID
NUMBER (10, 0)
AD_AlertProcessor
FOREIGN KEY
CAlertProcessor_ADAlert: AD_AlertProcessor_ID =>
AD_AlertProcessor
REFERENCED BY
AD_AlertRecipient
,
AD_AlertRule