Database design to store saved searches

[Rajib Sarkar]

Hello all,
I am trying to design a database to store saved searches i.e. user selects some criteria and saves the search for future use i.e. he can just run the search next time to get the results from the db.

The thing is that, each search type searches a group of tables based on what the user chooses.

I started the design creating a table to store the search_id, user_id (who submitted the search) and the name of the search and then created another table with a 1:n relationship to this table, where it stores the column_name and value.

Is there any better way of implementing this ?

Rajib