added alpha support for foreign-key relationships