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
|