FND Design Data [Home] [Help]

Table: OTA_QUESTION_BANKS

Product: OTA - Learning Management
Description: This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Presently we support at 1:N relation between OTA_QUESTION_BANKS and OTA_QUESTIONS but the design is in
Implementation/DBA Data: TableOTA.OTA_QUESTION_BANKS
Primary Key: OTA_QUESTIONS_BANKS_UK1
  1. ColumnFOLDER_ID
  2. ColumnNAME
Primary Key: OTA_QUESTION_BANKS_PK
  1. ColumnQUESTION_BANK_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OTA_QUESTION_BANKS FK Joins to TableOTA_LO_FOLDERS OTA_QUESTION_BANKS.FOLDER_ID
TableOTA_QBANK_QUESTIONS FK Joins to OTA_QUESTION_BANKS OTA_QBANK_QUESTIONS.QUESTION_BANK_ID
TableOTA_SECTION_RULES FK Joins to OTA_QUESTION_BANKS OTA_SECTION_RULES.QUESTION_BANK_ID
TableOTA_TEST_QUESTIONS FK Joins to OTA_QUESTION_BANKS OTA_TEST_QUESTIONS.QUESTION_BANK_ID