Hi ,
As per my knowledge . different naming conventions is usually set for master tables and transaction tables . it depends on the design stratagy .
If naming conventions are not set . then just confirm from your designer if all the tables without foreign key and with primary key are master tables . if YES based on these where clause just query on the above tables .