-------------------------------------------------------------------------------
-- E.Gallas April 5, 2002
-- 
-- This file contains queries to get the counts of the number
-- of elements of various types in the speakers bureau database.
-- The counts reported below for the table rows, 
--   and application views, tables, synonymns, constraints, triggers
--   were recorded on April 5, 2002.
-------------------------------------------------------------------------------
set echo on;
set linesize 256;

select count(*) from ssgroups;		
-- 0
select count(*) from subgroups;		
-- 42
select count(*) from pgroups;
-- 3
select count(*) from links;
-- 964
select count(*) from confs;
-- 446
select count(*) from peoples;
-- 941
select count(*) from whod0s;
-- 1215
select count(*) from instits;
-- 67
select count(*) from mastinsts;
-- 78
pause

select count(*) from user_views;
-- 0
select count(*) from user_tables;
-- 9
select count(*) from all_synonyms where table_owner like '%SPEAKERDB%';
-- 19
select count(*) from user_constraints;
-- 62
select count(*) from user_triggers;
-- 18
select * from user_sequences;
-- id_link_seq and links_seq_id in int and dev.
-- I think that LINKS_SEQ_ID is never used.

pause
select synonym_name,table_owner,table_name
	from all_synonyms where table_owner like '%SPEAKERDB%'
	order by table_name,synonym_name;
pause

