| Name | ACTIVITY_ATTRIBUTE_VALUE |
| Comment | Activity Attribute Value table. |
| Column |
| Name | Is PK | Is FK | UDP | Datatype | Null Option | Comment |
| PRIMARY_KEY | Yes | Yes |
|
NUMBER(20) | NOT NULL | Unique System Assigned ID |
| ATTRIBUTE_ID | Yes | Yes |
|
VARCHAR2(15) | NOT NULL | Attribute ID |
| ATTRIBUTE_VALUE | No | No |
|
VARCHAR2(15) | NULL | Attribute Value |
| CREATED_BY | No | No |
|
VARCHAR2(20) | NULL | Created by User ID |
| CREATED_DATE | No | No |
|
DATE | NULL | Created Date |
| MODIFIED_BY | No | No |
|
VARCHAR2(20) | NULL | Modified by User ID |
| MODIFIED_DATE | No | No |
|
DATE | NULL | Modified date |
| UDP(s) of "PRIMARY_KEY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "ATTRIBUTE_ID" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "ATTRIBUTE_VALUE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "CREATED_BY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "CREATED_DATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "MODIFIED_BY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "MODIFIED_DATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| Index |
| Name | Member |
| XPKACTIVITY_ATTRIBUTE_VALUE |
|
| XIF1ACTIVITY_ATTRIBUTE_VALUE |
|
| XIF2ACTIVITY_ATTRIBUTE_VALUE |
|
| Member(s) of "XPKACTIVITY_ATTRIBUTE_VALUE" Index |
| Column |
| Name |
| PRIMARY_KEY |
| Column |
| Name |
| ATTRIBUTE_ID |
| Member(s) of "XIF1ACTIVITY_ATTRIBUTE_VALUE" Index |
| Column |
| Name |
| PRIMARY_KEY |
| Member(s) of "XIF2ACTIVITY_ATTRIBUTE_VALUE" Index |
| Column |
| Name |
| ATTRIBUTE_ID |
| Child Relationship |
| Parent Relationship |
| Parent Table |
| Name |
| ACTIVITY_ATTRIBUTES |
| Parent Table |
| Name |
| ACTIVITY_DETAIL |
| Script |
| Name | Code |
| BU |
create or replace trigger %TableOwner.%Substr(%TableName,1,21)_BU
before update on %TableOwner.%TableName for each row
begin
:new.modified_by := user;
:new.modified_date :=sysdate;
end ;
/
|