Table: G3E_ANALYSIS

 
Field Type Nullable Comments
G3E_ADNO NUMBER(9,0) N  
G3E_USERNAME VARCHAR2(80) N  
G3E_TYPE VARCHAR2(30) N  
G3E_TABLE VARCHAR2(22) N  
G3E_OPTIMIZEDTABLE VARCHAR2(30) Y  
G3E_TOOLTIP VARCHAR2(240) Y  
G3E_SUPPORTINTERFACE VARCHAR2(80) Y  
G3E_EDITDATE DATE N  

Constraint: M_C_G3E_ANALYSIS_ADNO

Constraint Columns G3E_ADNO
Constraint Type CHECK
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body G3E_ADNO > 0

Constraint: M_N_G3E_ANALYSIS_ADNO

Constraint Columns G3E_ADNO
Constraint Type CHECK
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body "G3E_ADNO" IS NOT NULL

Constraint: M_N_G3E_ANALYSIS_EDITDATE

Constraint Columns G3E_EDITDATE
Constraint Type CHECK
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body "G3E_EDITDATE" IS NOT NULL

Constraint: M_N_G3E_ANALYSIS_TABLE

Constraint Columns G3E_TABLE
Constraint Type CHECK
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body "G3E_TABLE" IS NOT NULL

Constraint: M_N_G3E_ANALYSIS_TYPE

Constraint Columns G3E_TYPE
Constraint Type CHECK
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body "G3E_TYPE" IS NOT NULL

Constraint: M_N_G3E_ANALYSIS_USERNAME

Constraint Columns G3E_USERNAME
Constraint Type CHECK
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body "G3E_USERNAME" IS NOT NULL

Constraint: M_P_G3E_ANALYSIS

Constraint Columns G3E_ADNO
Constraint Type PRIMARY KEY
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body  

Constraint: M_U_G3E_ANALYSIS_USERNAME

Constraint Columns G3E_USERNAME
Constraint Type UNIQUE
Status ENABLED
Deferrable NOT DEFERRABLE
Deffered IMMEDIATE
Constraint Body  

Index: M_P_G3E_ANALYSIS

Index Columns G3E_ADNO
Index Type NORMAL
Uniqueness UNIQUE
Status VALID

Index: M_U_G3E_ANALYSIS_USERNAME

Index Columns G3E_USERNAME
Index Type NORMAL
Uniqueness UNIQUE
Status VALID

Trigger: M_T_ADR_G3E_ANALYSIS_DL

Trigger Type AFTER EACH ROW
Triggering Event DELETE
Column Name  
Trigger Body DECLARE
dlno INTEGER;
tmpString G3E_DELETIONLOG.G3E_USERNAME%TYPE;
string_too_long EXCEPTION;
PRAGMA EXCEPTION_INIT (string_too_long, -6502); -- VALUE_ERROR
BEGIN
SELECT M_S_G3E_DELETIONLOG.NEXTVAL INTO dlno FROM DUAL;
tmpString := 'G3E_USERNAME=' || :OLD.G3E_USERNAME;
INSERT INTO G3E_DELETIONLOG VALUES
(dlno, -- new seq number
'G3E_ANALYSIS', -- name of this table
tmpString, -- information from this table
SYSDATE); -- today's date
EXCEPTION
WHEN string_too_long THEN
INSERT INTO G3E_DELETIONLOG VALUES
(dlno, -- new seq number
'G3E_ANALYSIS', -- name of this table
'Error, string length.', -- info string was too long
SYSDATE); -- today's date
END;

Trigger: M_T_BIUR_G3E_ANALYSIS

Trigger Type BEFORE EACH ROW
Triggering Event INSERT OR UPDATE
Column Name  
Trigger Body BEGIN
IF NOT mg3efuncIsValidTableOrViewName(:NEW.G3E_TABLE) THEN
raise_application_error(-20758,
'M_T_BIUR_G3E_ANALYSIS: Invalid table or view name in G3E_TABLE',
TRUE);
END IF;
IF NOT mg3efuncIsValidFieldName(:NEW.G3E_TABLE, 'G3E_TABLE')
THEN
raise_application_error(-20787,
'M_T_BIUR_G3E_ANALYSIS: G3E_TABLE column does not exist',
TRUE);
END IF;
IF NOT mg3efuncIsValidFieldName(:NEW.G3E_TABLE, 'G3E_OPTIMIZEDTABLE')
THEN
raise_application_error(-20788,
'M_T_BIUR_G3E_ANALYSIS: G3E_OPTIMIZEDTABLE column does not exist',
TRUE);
END IF;
END;

Trigger: M_T_BIUR_G3E_ANALYSIS_EDATE

Trigger Type BEFORE EACH ROW
Triggering Event INSERT OR UPDATE
Column Name  
Trigger Body BEGIN
:NEW.G3E_EDITDATE := SYSDATE;
END;