When we install Opendelight, seven database tables are created with name as *od_* as below. These tables store application information and are critical to application created with Opendelight.
| Table Name |
Description |
Fields along with attributes and explanation |
*od_controller |
Stores module information |
1. ctrid - INT(11)
2. ctrname - VARCHAR(255)
3. ispublic - ENUM('0','1') [0=public, 1=private]
4. defaulteventid - INT(11)
5. sortorder - INT(11)
6. ctrstatus - ENUM('0','1') [0=inactive, 1=active]
7. signinctrid - INT(11) [ctrid of corresponding signin controller if it is a private controller]
8. lastupdate - DATETIME |
*od_event |
Stores event information |
1. eventid - INT(11)
2. eventname - VARCHAR(255)
3. ctrid - INT(11)
4. sortorder - INT(11)
5. estatus - ENUM('0','1') [0=inactive, 1=active]
6. eventverifier - VARCHAR(255)
7. formrules - LONGTEXT
8. blcode - LONGTEXT
9. viewparts - TEXT
10. pagevars - TEXT
11. roles - VARCHAR(255)
12. lastupdate - DATETIME |
*od_config |
Stores user defined application configurations |
1. configid - INT(11)
2. configname - VARCHAR(255)
3. description - VARCHAR(255)
4. configvalue - VARCHAR(255)
5. sortorder - INT(11) |
*od_pagevars |
Stores pagevar array keys |
1. pagevarid - INT(11)
2. pagevarkey - VARCHAR(255) |
*od_user |
Stores essential user information |
1. userid - INT(11)
2. idverifier - VARCHAR(255)
3. username - VARCHAR(255)
4. password - VARCHAR(255)
5. email - VARCHAR(255)
6. firstname - VARCHAR(255)
7. lastname - VARCHAR(255)
8. userstatus - ENUM('0','1','2') [0=inactive, 1=active, 2=archived]
9. roleid - INT(11)
10. lastlogin - DATETIME |
*od_role |
Stores role information |
1. roleid - INT(11)
2. rolename - VARCHAR(255)
3. sortorder - INT(11)
4. defaultctrid - INT(11)
5. defaulteventid - INT(11) |
*od_sys |
Store system information |
1. sysid - INT(11)
2. appname - VARCHAR(255)
3. author - VARCHAR(255)
4. description - TEXT
5. baseurl - VARCHAR(255) [the base URL of the application]
6. sysstatus - ENUM('0','1') [0=not in production, 1=in production] |
|
During the course of development, developers add more tables depending on the scope of application.
