Table: OTA_SECTION_RULES

Product:	OTA - Learning Management
Description:	This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user attempts a test. This is only used when the OTA_TEST.TYPE_FLAG is set to D(Rule Based or Dynamic)
Implementation/DBA Data:	OTA.OTA_SECTION_RULES

Primary Key: OTA_SECTION_RULES_PK

1. SECTION_RULE_ID

Primary Key: OTA_SECTION_RULES_UK1

1. SECTION_ID
2. QUESTION_BANK_ID

Primary Key: OTA_SECTION_RULES_UK2

1. TEST_ID
2. QUESTION_BANK_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_SECTION_RULES		OTA_QUESTION_BANKS	OTA_SECTION_RULES.QUESTION_BANK_ID
OTA_SECTION_RULES		OTA_TEST_SECTIONS	OTA_SECTION_RULES.SECTION_ID
OTA_SECTION_RULES		OTA_TESTS	OTA_SECTION_RULES.TEST_ID