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

Table NameDescriptionFields along with attributes and explanation
*od_configStores user defined application configurations
  • configid - INT(11)
  • configname - VARCHAR(255)
  • description - VARCHAR(255)
  • configvalue - VARCHAR(255)
  • sortorder - INT(11)
*od_controllerStores 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_eventStores 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_pagevarsStores pagevar array keys
  • pagevarid - INT(11)
  • pagevarkey - VARCHAR(255)
*od_roleStores role information
  • roleid - INT(11)
  • rolename - VARCHAR(255)
  • sortorder - INT(11)
  • defaultctrid - INT(11)
  • defaulteventid - INT(11)
*od_sysStore 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_userStores 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