I need to read from the database the node information and the course-node relationship. In which tables can I find this?
I don't pretend to completely understand the Node to Course tables. But try this query (ORACLE based). Note that:
, mi.NAME AS Node
FROM COURSE_MAIN cm
INNER JOIN domain_course_coll dcc ON dcc.COURSE_MAIN_PK1 = cm.PK1
INNER JOIN MI_NODE mi ON mi.DOMAIN_PK1 = dcc.DOMAIN_PK1
WHERE cm.SERVICE_LEVEL = 'F'
Retrieving data ...