Batoi RAD Framework Application Database Structure

Back to Help Articles
When we install the Batoi RAD Framework, seven database tables are created with names as *od_* as below. These tables store application information and are critical to applications created with the Batoi RAD Framework.
Table Name Description Fields along with attributes and explanation
*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_config Stores user defined application configurations
  • configid - INT(11)
  • configname - VARCHAR(255)
  • description - VARCHAR(255)
  • configvalue - VARCHAR(255)
  • sortorder - INT(11)
*od_pagevars Stores pagevar array keys
  • pagevarid - INT(11)
  • pagevarkey - VARCHAR(255)
*od_user Stores essential user information
  • userid - INT(11)
  • 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
*od_role Stores role information
  • roleid - INT(11)
  • rolename - VARCHAR(255)
  • sortorder - INT(11)
  • defaultctrid - INT(11)
  • defaulteventid - INT(11)
*od_sys Stores system information
  • sysid - INT(11)
  • appname - VARCHAR(255)
  • author - VARCHAR(255)
  • description - TEXT
  • baseurl - VARCHAR(255)[the base URL of the application]
  • 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.

Back to Help Articles