MIFAR UI College of Medicine
Site Map Site Map Documentation Physiologic Imaging
Previous ~ Up ~ Next

Framework Domain - Table Categories

Tables in MIFAR can be though of in two categories.
  1. Metadata tables.
  2. Object tables.
  3. Helper tables.
In general metadata tables are only writable by the DB superuser, but are readable by everyone. They contain database meta information. Such as what object types are defined (mf_type), what permission groups exist (mf_group) and what services are supported (mf_service).

Object tables get the full user-group permission treatment. In general these tables contain the information that users care about. Examples include: the project definition table, dataroot, the service location table, servinst, and the data host table fhost.

Helper tables are often used to defined how one object relates to another. For example there is an object table which tracks files stored in a MIFAR system named, file. Seperate from this table is another, named store which tracks data storage locations. Storage locations could be a CD rack, a computer or an iron safe. Since copies of a file can exist in multiple storage locations and since each storage location usually contains more than one file, there is a many to many relationship between file and store. The table which provides a the link between files and stores is called finst. It is a helper table. Like object tables, helper tables can have arbitary permissions.

Previous ~ Up ~ Next
If you have any problems with the page contact Chris Piker at the
Division of Physiologic Imaging.