I want to build the following scenerio

There should be some sort of database table to hold a list of gateway entries with fields ip, prefix, and name/description.

It would be good to use exiting tables to use what is avaiable. Have been looking at the lcr and drouting tables

but it seems they are designed to choose automaticaly for you and not just returning data about specific entries.

Please suggest how I may archive the following

Kamailio will receive a request it will then send to another Kamailio redirect server.

The response from the redirect will have a sip header value holding the id/name of the gateway choosen.

I want Kamailio processing the reponse to use the gateway id/name to lookup on the table and access the full details

ip, prefix details.

This data can then be used to construct the relay parameter.

Regards