|
|
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;
