What Does This Thing Do?
This lava template will give you a detailed overview of your database tables, with ease of searchability and referencing to other tables and columns.
How to Set This Up
Setup Steps
|
1
|
Create Page
Make sure it is somewhere you only want people with sql access to be able to see, so under settings/powertools. Add security to the page if not already inherited!
|
|
2
|
Add an HTML Content Block to Page
With SQL and Cache enabled in the block settings.
|
|
3
|
Paste the Lava Template
The attached SQLModelMap.lava file goes in the HTML block. Adjust the cache duration based on your needs. |
|
Done
|
That's it!
Navigate to the page and start exploring. |
Ready to Go!
That's it, hopefully this will help you familiarize yourself better with your database tables.