Layton ServiceDesk - FAQ - Database Schema
From Layton Support
You can find the database schema in the database itself. It's a System View in the Views folder. This query will list all the columns in all the tables, ordered alphabetically.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME ,COLUMN_NAME