MOW_MRA_ALPHA_NODES_ENG

Stores Alpha Nodes and there dyanmic table definition and load query

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
mow_mra_alpha_nodes_eng_PK	FAMILY_CODE, EXECUTION_NUMBER, ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
FAMILY_CODE	VARCHAR2	30		Yes	FAMILY_CODE
EXECUTION_NUMBER	NUMBER		18	Yes	EXECUTION_NUMBER
ID	NUMBER		18	Yes	ID
GROUP_NUMBER	NUMBER		18		GROUP_NUMBER
LEVEL_NUMBER	NUMBER		18		LEVEL_NUMBER
LEVEL_SEQ_NUMBER	NUMBER		18		LEVEL_SEQ_NUMBER
NODE_TYPE	VARCHAR2	100			NODE_TYPE
NODE_EXEC_COMMAND	CLOB				NODE_EXEC_COMMAND
ALPHA_CHILD	VARCHAR2	4000			ALPHA_CHILD
ALPHA_PARENT	VARCHAR2	4000			ALPHA_PARENT
ACTION_TABLE	VARCHAR2	4000			ACTION_TABLE
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
MOW_MRA_ALPHA_NODES_ENG_U1	Unique	Default	FAMILY_CODE, EXECUTION_NUMBER, ID