eRooom application back end databases for data organisation.There are a few points,every eroom administrator must be aware of.
- The facility database contains data for collection of erooms.This contains all eroom structure and contents except for file attachment and images which are kept in file server.There is typically one facility database for every 10-100 erooms.
- 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.
