5 SELECT has_table('asset'::name, 'copy_inventory'::name);
7 SELECT has_index('asset'::name, 'copy_inventory'::name, 'copy_inventory_copy_idx'::name, 'copy'::name);
9 SELECT has_index('asset'::name, 'copy_inventory'::name, 'asset_copy_inventory_date_once_per_copy'::name,
10 ARRAY[ 'inventory_date', 'copy' ]);
12 SELECT has_function('evergreen'::name, 'asset_copy_inventory_copy_inh_fkey'::name);
14 SELECT has_trigger('asset'::name, 'copy_inventory'::name, 'inherit_asset_copy_inventory_copy_fkey'::name);
16 SELECT has_function('asset'::name, 'copy_may_float_to_inventory_workstation'::name);
18 SELECT has_trigger('asset'::name, 'copy_inventory'::name, 'asset_copy_inventory_allowed_trig'::name);
20 SELECT hasnt_function('evergreen'::name, 'asset_latest_inventory_copy_inh_fkey'::name);
22 SELECT hasnt_trigger('asset'::name, 'latest_inventory'::name, 'inherit_asset_latest_inventory_copy_fkey'::name);
24 SELECT hasnt_table('asset'::name, 'latest_inventory'::name);
26 SELECT has_view('asset'::name, 'latest_inventory'::name, 'View latest_inventory should exist');
28 SELECT * from finish();