select type_id, tablename, id_column from pb_types where pkg_id = :pkg_id order by sort_order select name, column_spec from pb_attributes where type_id = :type_id order by attribute_id select tablename from pb_types where pkg_id = :pkg_id order by sort_order desc