CSO_SCH_ACTN_BASE_PROF
This table stores action profiles (currently not used)
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_SCH_ACTN_BASE_PROF_PK |
PROFILE_ID, ACTION_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ACTION_ID | VARCHAR2 | 32 | Yes | Action ID, a foreign key reference to RECORD_ID in CSO_SCH_MAN_ANS table. |
| PROFILE_ID | VARCHAR2 | 32 | Yes | Profile ID, a foreign key reference to RECORD_ID in CSO_SCH_PROF table. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_SCH_ACTN_BASE_PROF | cso_sch_man_ans | ACTION_ID |
| CSO_SCH_ACTN_BASE_PROF | cso_sch_prof | PROFILE_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CSO_SCH_ACTN_BASE_PROF_U1 | Unique | PROFILE_ID, ACTION_ID |