Dynamic page with external DB

I have an external database with two tables in it on my WIX site and when I go to set up a dynamic page it shows no available fields to add in the URL on table1 and only the ID field as the only available field to add in the URL on table2. Does anyone have any idea why WIX is not recognizing these fields as being valid to be in the URL?