| PRIMARY KEY |
|
AD_WF_Activity_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 |
| |
|
AD_WF_Process_ID
NUMBER (10, 0) NOT NULL |
| AD_WF_Process |
|
AD_WF_Node_ID
NUMBER (10, 0) NOT NULL |
| AD_WF_Node |
|
AD_WF_Responsible_ID
NUMBER (10, 0) |
| AD_WF_Responsible |
|
AD_User_ID
NUMBER (10, 0) |
| AD_User |
|
WFState
CHAR (2) NOT NULL |
| |
|
AD_Message_ID
NUMBER (10, 0) |
| AD_Message |
|
TextMsg
NVARCHAR2 (2000) |
| |
|
Processing
CHAR (1) |
| |
|
Processed
CHAR (1) default: 'N' CHECK ( Processed in ( 'Y' , 'N' )) NOT NULL |
| |
FOREIGN KEY
ADMessage_ADWFActivity: AD_Message_ID => AD_Message
ADUser_ADWFActivity: AD_User_ID => AD_User
ADWFNode_ADWFActivity: AD_WF_Node_ID => AD_WF_Node
ADWFProcess_ADWFActivity: AD_WF_Process_ID => AD_WF_Process
ADWFResponsible_ADWFActivity: AD_WF_Responsible_ID => AD_WF_Responsible
|
REFERENCED BY
AD_Note,
AD_WF_ActivityResult,
AD_WF_EventAudit |
|