CSE_GROUP_VALIDATION_RULES
The entity that stores the validation rules for the asset group. These validation rules will be used in the downstream applications to constrain or limit the usage of assets in the group to be consumed by the respective application such as service contract, service request, etc.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSE_GROUP_VALIDATION_RULES_PK |
VALIDATION_RULE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
VALIDATION_RULE_ID | NUMBER | 18 | Yes | The validation rule identifier. The primary key attribute. | |
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. | |
GROUP_ID | NUMBER | 18 | Yes | The foreign key reference to the asset group entity. | |
VALIDATION_CODE | VARCHAR2 | 30 | Yes | The validation code for the group. This validation rule limits the assets in the group from downstream functionalities where the assets in the group will be constrained to such as limiting the usage of the assets in service contracts, service requests etc. | |
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_GROUP_VALIDATION_RULES_U01 | Unique | Default | VALIDATION_RULE_ID |