| PRIMARY KEY |
|
K_Entry_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 |
| |
|
K_Topic_ID
NUMBER (10, 0) NOT NULL |
| K_Topic |
|
TextMsg
NVARCHAR2 (2000) NOT NULL |
| |
|
Rating
NUMBER (10, 0) NOT NULL |
| |
|
IsPublic
CHAR (1) default: 'Y' CHECK ( IsPublic in ( 'Y' , 'N' )) NOT NULL |
| |
|
Keywords
NVARCHAR2 (255) |
| |
|
ValidTo
DATE |
| |
|
K_Source_ID
NUMBER (10, 0) |
| K_Source |
|
DescriptionURL
NVARCHAR2 (120) |
| |
|
AD_Session_ID
NUMBER (10, 0) |
| AD_Session |
FOREIGN KEY
ADSession_KEntry: AD_Session_ID => AD_Session
KSource_KEntry: K_Source_ID => K_Source
KTopic_KEntry: K_Topic_ID => K_Topic
|
REFERENCED BY
K_Comment,
K_EntryCategory,
K_EntryRelated,
K_EntryRelated |
|