ZMS_MOBILE_FEEDBACK
This Table is used to save data for feedback purpose.
Details
-
Schema: FUSION
-
Object owner: ZMS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ZMS_MOBILE_FEEDBACK_PK |
FEEDBACK_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
USER_ID | NUMBER | 18 | Yes | Would be unique for each record/user | |
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
FEEDBACK_ID | NUMBER | 18 | Yes | FEEDBACKID is Primary Key | |
USERNAME | VARCHAR2 | 64 | USERNAME | ||
LOGIN_COUNT | NUMBER | 18 | LOGIN_COUNT | ||
PROMPT_COUNT | NUMBER | 18 | PROMPT_COUNT | ||
LATEST_FEEDBACK | VARCHAR2 | 30 | LATEST_FEEDBACK | ||
PREVIOUS_PROMT_DATE | DATE | PREVIOUS_PROMT_DATE | |||
PREVIOUS_NO_FEED_DATE | DATE | PREVIOUS_NO_FEED_DATE | |||
COUNTRY_CODE | VARCHAR2 | 30 | COUNTRY | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
PREV_LOGIN_PROMPT_COUNT | NUMBER | 18 | Previous login promt count number | ||
COMMENTS | VARCHAR2 | 512 | COMMENTS | ||
STATUS_CODE | VARCHAR2 | 30 | status coloumn to indicate status | ||
PLAYSTORE_RATING | NUMBER | 18 | playstore feedback |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZMS_MOBILE_FEEDBACK_U1 | Unique | Default | FEEDBACK_ID |