Home » Support » Help Articles » Batoi OSF Application Database Structure

Batoi OSF Application Database Structure

Back to Help Articles Home


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

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


Updated on Aug 20, 2016

The techReview is an online magazine by Batoi and publishes articles on current trends in technologies across different industry verticals and areas of research. The objective of the online magazine to provide an insight into cutting-edge technologies in their evolution from labs to market.

Visit techReview


English - IN (USD)
New Users? Signup.     Existing Users? Login.