ZCA_OBJECT_ATTRIBUTES

Details

Schema: FUSION
Object owner: ZCA
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
ZCA_OBJECT_ATTRIBUTES_PK	OBJECT_ATTR_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
OBJECT_ATTR_ID	NUMBER		18	Yes	Auto generated primary key of the table
OBJECT_ID	NUMBER		18	Yes	Parent foreign key refering to ZCA_OBJECTS table.
LANG_INDEPENDENT_CODE	VARCHAR2	128			This specifies the language Independent code of object according to ZCA_OBJECTS table
ENTITY_DEFINITION	VARCHAR2	600			Enity Definition for the corresponding Attribute
ATTR_NAME	VARCHAR2	100		Yes	Name of the attribute in base table.
ATTR_COLUMN	VARCHAR2	30			Underlying column of the attribute in base table.
ATTR_TABLE	VARCHAR2	30			Name of the base table of the attribute.
ATTR_TYPE	VARCHAR2	30		Yes	Data type of the attribute in the ADF base VO
COLUMN_TYPE	VARCHAR2	30			Data type of the underlying column in the database
ATTR_LENGTH	NUMBER			Yes	Length of the ViewObject(VO) attribute
ATTR_SCALE	NUMBER				Scale of the ViewObject(VO) attribute
ATTR_PRECISION	NUMBER				Precision of the ViewObject(VO) attribute
MANDATORY_FLAG	VARCHAR2	1		Yes	Flag specifying whether the attribute is mandatory or not
UPDATABLE_FLAG	VARCHAR2	1		Yes	Flag specifying whether the attribute can be updated or not
CUSTOM_FLAG	VARCHAR2	1		Yes	Specifies whether this is a custom attribute
PRIMARY_KEY_FLAG	VARCHAR2	1			Specifies whether this is a PK attribute
PRIMARY_KEY_NUM	NUMBER				Specifies the PK Number attribute. The sequence of the attribute in PK.
PUID_FLAG	VARCHAR2	1			Specifies whether this is a PUID attribute
PARENT_PUID_FLAG	VARCHAR2	1			Specifies whether this is a Parent PUID attribute.
PARENT_FK_FLAG	VARCHAR2	1			Specifies whether this is a Parent PK attribute
PARENT_FK_NUM	NUMBER				Specifies the Parent PK Number attribute. The sequence of the attribute in parent pk
TRANSIENT_FLAG	VARCHAR2	1			Specifies whether the Attribute is transient or not .
IMPORT_MAPPABLE_FLAG	VARCHAR2	1			Specifies, whether the Attribute has to be visible in the Mapping Screen or Not.
DEFAULT_VALUE	VARCHAR2	4000			It specifies default value of the attribute, set at its consumer VO level.
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.
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.
ATTRIBUTE_FLAGS	NUMBER				This column is used to store attribute flags, e g: 7 means in binary its 111, each bit represents one flag
LABEL_RESID	VARCHAR2	700			It specifies the label resource id of an attribute
ATTR_DESCRIPTION	VARCHAR2	4000			It Specifies description of the attributes
ALIAS_NAME	VARCHAR2	300			Alias Name for the corresponding Attribute
DEPENDS_ON	VARCHAR2	800			Column used to save the attribute dependencies for the object
ATTRIBUTE_DEF_TYPE	VARCHAR2	50			This column specifies the control type of an attribute.

Foreign Keys

Table	Foreign Table	Foreign Key Column
ZCA_OBJECT_ATTRIBUTES	zca_objects	OBJECT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
ZCA_OBJECT_ATTRIBUTES_N1	Non Unique	Default	OBJECT_ID
ZCA_OBJECT_ATTRIBUTES_N2	Non Unique	Default	LANG_INDEPENDENT_CODE, ATTR_NAME
ZCA_OBJECT_ATTRIBUTES_U1	Unique	Default	OBJECT_ATTR_ID