eRoom Backend Databases « Deep Inside eRoom

eRoom Backend Databases

eRooom application back end databases for data organisation.There are a few points,every eroom administrator must be aware of.

Every eRoom Facility is having a database.Whenever a facility is created,there is a database created,containing corresponding tables for the facility.
There is a Site database (eRoom_eRoomSite) which contains tables for the site like Community,Facility,Room,Members etc.
eRoom_eRoomSiteUsage database contains all tables that are specific to the usage of the site by members of the eroom.
The System databases include Master,Model,MSDB,tempdb
The Databases are owned by “dbo” owner.

This entry was posted on May 6, 2008 at 12:31 pm and is filed under Administration. Tagged: dbo, eRoomSiteUsage, eRoom_eRoomSiteUsage, Model, MSDB, organisation, SQL, tempdb. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.