DOO_OBJECT_ATTRIBUTES_B
Stores all the attributes that can have constraints defined against them
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
DOO_OBJECT_ATTRIBUTES_B_PK |
OBJECT_ATTRIBUTE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DATABASE_OBJECT_NAME | VARCHAR2 | 30 | Yes | Database object name of the entity | |
| DELTA_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Not used. | |
| OBJECT_ATTRIBUTE_ID | NUMBER | 18 | Yes | Unique identifier of the object attribute | |
| ENTITY_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the entity object | |
| ATTRIBUTE_ID | NUMBER | 18 | Yes | Reference to the unique identifier for the attribute | |
| ATTRIBUTE_CODE | VARCHAR2 | 30 | Yes | Code for a database column used in the DOO tables. Displayed in both constraints and change management related setup UIs. | |
| SEEDED_FLAG | VARCHAR2 | 1 | Yes | Indicates that the record is seeded by the product | |
| ATTRIBUTE_APPLICATION_ID | NUMBER | Application id associated with attributes exposed from entities for defining constraints. | |||
| DEFAULTING_SEQUENCE | NUMBER | Not used. | |||
| DEFAULTING_ENABLED_FLAG | VARCHAR2 | 1 | Not used. | ||
| DEFAULTING_CONDN_REF_FLAG | VARCHAR2 | 1 | Indicates that this attribute can be used in building defaulting conditions | ||
| DEFAULTING_SOURCE_FLAG | VARCHAR2 | 1 | Indicates that this attribute can be used as a defaulting source | ||
| CONSTRAINTS_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates that constraints can be setup for this attribute | |
| CONSTRAINT_CONDN_REF_FLAG | VARCHAR2 | 1 | Indicates that this attribute can be used in constraints validation templates | ||
| COLUMN_TYPE_CODE | VARCHAR2 | 30 | Data type of the column name | ||
| DEPENDENT_API_PKG | VARCHAR2 | 30 | Not used. | ||
| DEPENDENT_API_PROC | VARCHAR2 | 30 | Not used. | ||
| SECURITY_API_PKG | VARCHAR2 | 30 | Database package to check security constraints on this attribute | ||
| SECURITY_API_PROC | VARCHAR2 | 30 | Procedure to check security constraints on this attribute | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| 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. | ||
| CONTEXT | VARCHAR2 | 30 | Context | ||
| STATE_ATTRIBUTE_FLAG | VARCHAR2 | 1 | Indicates that this attribute represents a status column | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | ||
| REQUIRED_FLAG | VARCHAR2 | 1 | Indicates that the object attribute should be required | ||
| DATA_SOURCE_TYPE | VARCHAR2 | 30 | Data source type specifies where the object attribute comes from. | ||
| DATA_STORAGE_TYPE | VARCHAR2 | 30 | Not used. | ||
| COLUMN_NAME | VARCHAR2 | 30 | Attribute Name that is constrainable | ||
| ATTRIBUTE_LABEL_LENGTH | NUMBER | 18 | Not used. | ||
| EVENT_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether the attribute may be enabled for orchestartion order update business event.This is seeded property.If the value is 'Y', the attribute will be visible in the Manage Business Event trigger points setup task UI where the user may enable it for the Order Orchestartion Order update. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| ORCHESTRATION_APPLICATION_ID | NUMBER | 18 | These are the foreign key reference from the DOO_ORCHESTRATION_APPLICATION table to identify these are DOO specific columns used in Constraint and change. | ||
| EFF_CONTEXT_CODE | VARCHAR2 | 80 | Extensible flexfield segment's context code | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| DOO_OBJECT_ATTRIBUTES_B | doo_objects_b | ENTITY_ID |
| DOO_OBJECT_ATTRIBUTES_B | doo_attributes_b | ATTRIBUTE_ID |
| doo_object_attributes_tl | doo_object_attributes_b | OBJECT_ATTRIBUTE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_OBJECT_ATTRIBUTES_B_N1 | Non Unique | Default | ENTITY_ID, ATTRIBUTE_ID, MODULE_ID |
| DOO_OBJECT_ATTRIBUTES_B_N2 | Non Unique | Default | MODULE_ID, COLUMN_NAME |
| DOO_OBJECT_ATTRIBUTES_B_N3 | Non Unique | Default | MODULE_ID, CONSTRAINTS_ENABLED_FLAG |
| DOO_OBJECT_ATTRIBUTES_B_PK | Unique | Default | OBJECT_ATTRIBUTE_ID, ORA_SEED_SET1 |
| DOO_OBJECT_ATTRIBUTES_B_PK1 | Unique | Default | OBJECT_ATTRIBUTE_ID, ORA_SEED_SET2 |
| DOO_OBJECT_ATTRIBUTES_B_UK1 | Unique | Default | ATTRIBUTE_CODE, DATABASE_OBJECT_NAME, MODULE_ID, EFF_CONTEXT_CODE, ORA_SEED_SET1 |
| DOO_OBJECT_ATTRIBUTES_B_UK11 | Unique | Default | ATTRIBUTE_CODE, DATABASE_OBJECT_NAME, MODULE_ID, EFF_CONTEXT_CODE, ORA_SEED_SET2 |