When integrating your preferred Business Intelligence (BI) tool to the database, the following technical details are worth noting: - The learning environment is based on Moodle, the world's most popular open-source learning management system. Moodle does not currently generate actual foreign key constraints in the database. As such, Dual Code has defined the relationship using the following convention.
- The ID column in a table always represents the primary key and usually has the comment of "Primary key of the table."
- A foreign key usually has the comment of "Key referencing the primary key in the [tablename] table."
- When dealing with dates or times:
- As a general rule, most dates/times are stored in the database as a BigInt in Unix time format (also known as Epoch time, POSIX time, seconds since the Epoch, or UNIX Epoch time). Some exceptions apply.
- The database read-only replica is in the same timezone as the production server.
- Dual Code has developed views to facilitate your development.
- Regular table start with the mdl_ prefix (e.g. mdl_course)
- Views start with the bi_mdl_ prefix (e.g. bi_mdl_users)
|