Commerce composer important tables:
PAGELAYOUT
PAGELAYOUTTYPE
PLLOCATION
PLPAGE
PLSTOREWIDGET
PLTEMPLATEREL
PLWIDGET
PLWIDGETDEF
PLWIDGETDEFDESC
PLWIDGETNVP
PLWIDGETREL
PLWIDGETSLOT
STOREPLTYPES
Some of the important queries:
Select * from PLWIDGET where PAGELAYOUT_ID in (select
PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%');
Select * from PLWIDGETDEF where IDENTIFIER like
'Sample%';
Select * from PLWIDGETDEFDESC where PLWIDGETDEF_ID in
(select PLWIDGETDEF_ID from PLWIDGETDEF where IDENTIFIER like 'Sample%');
Select * from PLSTOREWIDGET where PLWIDGETDEF_ID in
(select PLWIDGETDEF_ID from PLWIDGETDEF where IDENTIFIER like 'Sample%');
Select * from PAGELAYOUT where name like 'Sample%';
Select * from PLWIDGETREL where PLWIDGET_ID_CHILD in
(select PLWIDGET_ID
from PLWIDGET
where PAGELAYOUT_ID in (select PAGELAYOUT_ID from PAGELAYOUT where name like
'Sample%'));
Select * from PLWIDGETSLOT where PAGELAYOUT_ID in (select
PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%');
Do share the related data if anything found so that it can be helpful to others tooo...
