Here's the link to the earlier Postgresql documentation

http://nautilus.baruch.sc.edu/twiki_dmcc/bin/view/Main/XeniaPackageV2#Source

Install Notes

Run the following sql in the following order against your database

Postgres main schema

Observation data dictionary lookups

Note in the above sql file there is the below commented SELECT statement which will give a more human readable listing of the observation data dictionary

Display order lookups

Source Code

http://code.google.com/p/xenia/source/browse/trunk/postgresql

Xenia Table Schema Diagram