Database What's There

Jump to bottom Edit New page

saschaben edited this page Dec 12, 2012 · 1 revision

The Ilios Database - What's there (v. 2.1.1)

General Info

Collation: utf_general_ci
Database engines used: InnoDB, MyISAM
Number of Tables: 85
Number of Functions: 16
Number of Procedures: 23

Framework-specific/CodeIgniter (CI) database components

one sole table ci_sessions for storing user sessions
uses MyISAM engine

Application-specific/Ilios database components

use InnoDB engine
plethora of functions/procedures, which implement fairly advanced business processes using temporary tables and temporary triggers
some usage of foreign key constraints, but not completely implemented throughout
JOIN tables use TABLE1_x_TABLE2 naming convention

Medical Subject Headings (MeSH) database components

consists of 12 tables and 6 procedures
use MyISAM engine
prefixed with mesh_

ERD available here