FND Design Data [Home] [Help]

Table: OTA_TEST_SECTIONS

Product: OTA - Learning Management
Description: A test can have one or more test sections. For a test to be offered it must have atleast one test section associated with it which contains atleast one question. There is a 1:N relation between the OTA_TESTS and OTA_TEST_SECTIONS
Implementation/DBA Data: TableOTA.OTA_TEST_SECTIONS
Primary Key: OTA_TEST_SECTIONS_PK
  1. ColumnTEST_SECTION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OTA_TEST_SECTIONS FK Joins to TableOTA_LEARNING_OBJECTS OTA_TEST_SECTIONS.LEARNING_OBJECT_ID
OTA_TEST_SECTIONS FK Joins to TableOTA_TESTS OTA_TEST_SECTIONS.TEST_ID
TableOTA_SECTION_RULES FK Joins to OTA_TEST_SECTIONS OTA_SECTION_RULES.SECTION_ID
TableOTA_TEST_QUESTIONS FK Joins to OTA_TEST_SECTIONS OTA_TEST_QUESTIONS.SECTION_ID