ustify"> / ***************************************** ************************************* /
/ *** Tables *** /
/******************************************************************************/TABLE D_RES_ANSWER (_RES_ANSWER PRK, _RES_TEST INTT, _TEST INTT, _ANSWER INTT, _SESSION INTT, TIMEST, TIMEST, _CORRECT INTT, DOUBLE_PREC, DOUBLE_PREC, INTT, TIMEST, D10CHAR
); TABLE D_RES_TEST (_RES_TEST PRK, _TEST INTT, _SESSION INTT, TIMEST, TIMEST, DOUBLE_PREC, DOUBLE_PREC, INTT, TIMEST, D10CHAR
); TABLE HEL (VARCHAR (100), VARCHAR (100)
); TABLE L_ANSWER (_ANSWER PRK, _QUERY INTT, INTT, D512VARCHAR, _CORRECT INTT, DOUBLE_PREC, INTT, TIMEST, D10CHAR
); TABLE L_GROUP (_GROUP PRK, D128VARCHAR, D10CHAR, _EDIT INTT, _ASSEMBLE INTT, _STAT INTT, _TEST INTT, D1024VARCHAR, INTT, TIMEST, D10CHAR
); TABLE L_QUERY (_QUERY PRK, _QUERY_TYPE INTT, _TEST INTT, _THEM INTT, INTT, D512VARCHAR, INTT, TIMEST, D10CHAR
); TABLE L_SESSION (_SESSION PRK, _USER INTT, TIMEST, TIMEST, INTT, TIMEST, D10CHAR
); TABLE L_TEST (_TEST PRK, _THEM INTT, D128VARCHAR, INTT, TIMEST, D10CHAR
); TABLE L_THEM (_THEM PRK, D128VARCHAR, INTT, TIMEST, D10CHAR
); TABLE L_USER (_USER PRK, D128VARCHAR, D128VARCHAR, D128VARCHAR, INTT, TIMEST, D10CHAR
); TABLE L_USER_GROUP (_USER_GROUP PRK, _USER INTT, _GROUP INTT, INTT, TIMEST, D10CHAR
); TABLE S_QUERY_TYPE (_QUERY_TYPE PRK, D128VARCHAR, D10CHAR, INTT, TIMEST, D10CHAR
);
/ ***************************************** ************************************* /
/ *** Primary Keys *** /
/******************************************************************************/TABLE D_RES_ANSWER ADD CONSTRAINT PK_D_RES_ANSWER PRIMARY KEY (ID_RES_ANSWER); TABLE D_RES_TEST ADD CONSTRAINT PK_D_RES_TEST PRIMARY KEY (ID_RES_TEST); TABLE L_ANSWER ADD CONSTRAINT PK_L_ANSWER PRIMARY KEY (ID_ANSWER); TABLE L_GROUP ADD CONSTRAINT PK_L_GROUP PRIMARY KEY (ID_GROUP); TABLE L_QUERY ADD CONSTRAINT PK_L_QUERY PRIMARY KEY (ID_QUERY); TABLE L_SESSION ADD CONSTRAINT PK_L_SESSION PRIMARY KEY (ID_SESSION); TABLE L_TEST ADD CONSTRAINT PK_L_TEST PRIMARY KEY (ID_TEST); TABLE L_THEM ADD CONSTRAINT PK_L_THEM PRIMARY KEY (ID_THEM); TABLE L_USER ADD CONSTRAINT PK_L_USER PRIMARY KEY (ID_USER); TABLE L_USER_GROUP ADD CONSTRAINT PK_L_USER_GROUP PRIMARY KEY (ID_USER_GROUP); TABLE S_QUERY_TYPE ADD CONSTRAINT PK_S_QUERY_TYPE PRIMARY KEY (ID_QUERY_TYPE);
/ ***************************************** ************************************* /
/ *** Triggers *** /
/ ***************************************** ************************************* / TERM ^;
/ ***************************************** ************************************* /
/ *** Triggers for tables *** /
/ ***************************************** ************************************* /
/ * Trigger: TR_D_RES_ANSWER_BI * / TRIGGER TR_D_RES_ANSWER_BI FOR D_RES_ANSWERBEFORE INSERT POSITION 0VARIABLE v_ID integer; (NEW.id_res_answer IS N...
