MDS_ATTRIBUTES
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ATT_PARTITION_ID | NUMBER | Yes | ATT_PARTITION_ID | ||
| ATT_CONTENTID | NUMBER | Yes | ATT_CONTENTID | ||
| ATT_COMP_SEQ | NUMBER | 6 | Yes | ATT_COMP_SEQ | |
| ATT_SEQ | NUMBER | 4 | Yes | ATT_SEQ | |
| ATT_NSID | NUMBER | 5 | ATT_NSID | ||
| ATT_PREFIX | VARCHAR2 | 127 | ATT_PREFIX | ||
| ATT_LOCALNAME | VARCHAR2 | 800 | ATT_LOCALNAME | ||
| ATT_VALUE | VARCHAR2 | 4000 | ATT_VALUE | ||
| IS_LARGE | VARCHAR2 | 1 | IS_LARGE | ||
| ENTERPRISE_ID | NUMBER | 18 | ENTERPRISE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MDS_ATTRIBUTES_U1 | Unique | SYSTEM | ATT_PARTITION_ID, ATT_CONTENTID, ATT_COMP_SEQ, ATT_SEQ |
| MDS_ATTRIBUTES_U2 | Unique | SYSTEM | ATT_PARTITION_ID, ATT_LOCALNAME, ATT_CONTENTID, ATT_COMP_SEQ, ATT_NSID |