Data Dictionary
>
FPSBASE Tables
> FPSBASE.FBK_W_FEEDBACK_COMMENTS
Table FPSBASE.FBK_W_FEEDBACK_COMMENTS"
In order to track comments and emails sent on specific feedbacks, we need a table that holds the comments. This table uses the FBK_GET_FEEDBACK_ID_NUM function to increments the id numbers of the feedback comments.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: FEEDBACK_ID, COMMENT_ID_NUM
-
Foreign keys: FBK_W_FEEDBACK_ID_FK: FEEDBACK_ID REFERENCES FPSAPP.FBK_W_FEEDBACKS (ID)
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
FEEDBACK_ID |
VARCHAR2(50) |
N |
|
|
COMMENT_ID_NUM |
NUMBER(10) |
N |
|
|
INST |
DATE |
Time when the event occurred. (* from FPSINPUT.WIP_EVENT_HIST) |
|
|
MESSAGE |
VARCHAR2(4000) |