Opendelight Application Database Structure

Downloads Docs Blogs Get Involved

Back

Overview of Opendelight Architecture Opendelight Objects, Arrays and Libraries Opendelight Application Database Structure Opendelight Application File Structure Controller in Opendelight Event in Opendelight Model in Opendelight View in Opendelight Users and Roles in Opendelight Overview of Opendelight IDE Opendelight Coding Standards and Conventions Installation and Upgrades of Opendelight

When we install the Opendelight, seven database tables are created with name as *od_* as below. These tables store application information and are critical to application created with the Opendelight.

Table Name	Description	Fields along with attributes and explanation
`*od_config`	Stores user defined application configurations	`configid` - `INT(11)` `configname` - `VARCHAR(255)` `description` - `VARCHAR(255)` `configvalue` - `VARCHAR(255)` `sortorder` - `INT(11)`
`*od_controller`	Stores module information	`ctrid` - `INT(11)` `ctrname` - `VARCHAR(255)` `ispublic` - `ENUM('0','1')` [0=public, 1=private] `defaulteventid` - `INT(11)` `sortorder` - `INT(11)` `ctrstatus` - `ENUM('0','1')` [0=inactive, 1=active] `signinctrid` - `INT(11)` [`ctrid` of corresponding signin controller if it is a private controller] `lastupdate` - `DATETIME`
`*od_event`	Stores event information	`eventid` - `INT(11)` `eventname` - `VARCHAR(255)` `ctrid` - `INT(11)` `sortorder` - `INT(11)` `estatus` - `ENUM('0','1')` [0=inactive, 1=active] `eventverifier` - `VARCHAR(255)` `formrules` - `LONGTEXT` `blcode` - `LONGTEXT` `viewparts` - `TEXT` `pagevars` - `TEXT` `roles` - `VARCHAR(255)` `lastupdate` - `DATETIME`
`*od_pagevars`	Stores pagevar array keys	`pagevarid` - `INT(11)` `pagevarkey` - `VARCHAR(255)`
`*od_role`	Stores role information	`roleid` - `INT(11)` `rolename` - `VARCHAR(255)` `sortorder` - `INT(11)` `defaultctrid` - `INT(11)` `defaulteventid` - `INT(11)`
`*od_sys`	Store system information	`sysid` - `INT(11)` `appname` - `VARCHAR(255)` `author` - `VARCHAR(255)` `description` - `TEXT` `baseurl` - `VARCHAR(255)` [the base URL of the application] `ssodefaultroleid` - `INT(11)` `logstatus` - `ENUM('0','1')` [0=not enabled, 1=enabled] `sysstatus` - `ENUM('0','1')` [0=not in production, 1=in production]
`*od_user`	Stores essential user information	`userid` - `INT(11)` `idprovider` - `VARCHAR(255)` `idverifier` - `VARCHAR(255)` `username` - `VARCHAR(255)` `password` - `VARCHAR(255)` `email` - `VARCHAR(255)` `firstname` - `VARCHAR(255)` `lastname` - `VARCHAR(255)` `userstatus` - `ENUM('0','1','2')` [0=inactive, 1=active, 2=archived] `roleid` - `INT(11)` `lastlogin` - `DATETIME`