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 |