FND Design Data [Home] [Help]

Table: OTA_COURSE_PREREQUISITES

Product: OTA - Learning Management
Description: This hold the information of which courses need to be completed before learners can enroll into a specific course. A course can have one or more courses as prerequisite. The prerequisite can be mandadory or advisory.
Implementation/DBA Data: TableOTA.OTA_COURSE_PREREQUISITES
Primary Key: OTA_COURSE_PREREQUISITES_PK
  1. ColumnACTIVITY_VERSION_ID
  2. ColumnPREREQUISITE_COURSE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OTA_COURSE_PREREQUISITES FK Joins to TableOTA_ACTIVITY_VERSIONS OTA_COURSE_PREREQUISITES.ACTIVITY_VERSION_ID
OTA_COURSE_PREREQUISITES FK Joins to TableOTA_ACTIVITY_VERSIONS OTA_COURSE_PREREQUISITES.PREREQUISITE_COURSE_ID