Table: OTA_TEST_QUESTIONS

Product:	OTA - Learning Management
Description:	This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pre Selected)test. This stores which questions will be displayed under which test sections.
Implementation/DBA Data:	OTA.OTA_TEST_QUESTIONS

Primary Key: OTA_TEST_QUESTIONS_PK

1. TEST_QUESTION_ID

Primary Key: OTA_TEST_QUESTIONS_UK1

1. TEST_ID
2. QUESTION_BANK_ID
3. QUESTION_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_TEST_QUESTIONS		OTA_QUESTIONS	OTA_TEST_QUESTIONS.QUESTION_ID
OTA_TEST_QUESTIONS		OTA_QUESTION_BANKS	OTA_TEST_QUESTIONS.QUESTION_BANK_ID
OTA_TEST_QUESTIONS		OTA_TEST_SECTIONS	OTA_TEST_QUESTIONS.SECTION_ID
OTA_TEST_QUESTIONS		OTA_TESTS	OTA_TEST_QUESTIONS.TEST_ID