FND_USER_PREFERENCES
Details
-
Schema: PREFERENCES
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_D
Primary Key
| Name | Columns |
|---|---|
|
FND_USER_PREFERENCES_PK |
USER_NAME, MODULE_NAME, PREFERENCE_NAME, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| USER_NAME | VARCHAR2 | 320 | Yes | USER_NAME | |
| MODULE_NAME | VARCHAR2 | 30 | Yes | MODULE_NAME | |
| PREFERENCE_NAME | VARCHAR2 | 30 | Yes | PREFERENCE_NAME | |
| PREFERENCE_VALUE | VARCHAR2 | 240 | PREFERENCE_VALUE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_USER_PREFERENCES_U1 | Unique | Default | USER_NAME, MODULE_NAME, PREFERENCE_NAME, ENTERPRISE_ID |