The “WatIAM” application maintains a copy of all the information found in the WatIAM ”Extract” file.

Profile

Schemas

  • _watiam — Main schema containing tables derived from WatIAM “Extract” file.
  • _watiam_load — Tables used when updating the _watiam tables from the _watiam_raw tables.
  • _watiam_raw — Raw tables used to load WatIAM “Extract” file, and check views which find questionable entries.
  • _watiam_view — Views which compute _watiam table contents from _watiam_raw tables.

Roles

  • _watiam_core — Standard role which owns functions.
  • _watiam_load — Role used to load data. Full access to tables in _watiam, _watiam_load, and _watiam_raw.
  • _watiam_raw_select — Grantable role to give SELECT access to tables in _watiam_load and _watiam_raw.
  • _watiam_references — Standard role to give REFERENCES access to all tables in _watiam.
  • _watiam_root — Standard role which owns all tables.
  • _watiam_select — Standard role with SELECT access to all tables in _watiam.

Dependencies

Dependents

Details