5. Auto-Catalog
Machine-generated, exhaustive reference for every database object in
xlyweberp_saas_ai.
This chapter is regenerated by scripts/gen_catalog.py, which queries the
live database directly through ~/.my.cnf. Do not hand-edit pages under
this chapter — they will be overwritten on the next regeneration.
Hand-written narrative belongs in Reference
or Vertical Slices, with cross-links from here.
- Tables — 901 base tables.
- Views — 311 views.
- Procedures — 1,687 stored procedures.
- Functions — 177 stored functions.
Each entry includes name, comment, columns / parameters, indexes (for
tables), the CREATE VIEW body (for views), and a narrative slot for
any human-written prose that covers it.
To regenerate: python scripts/gen_catalog.py. The script reads
connection parameters from ~/.my.cnf and the schema name from the same
file's database = ... entry; override either via the DB_DEFAULTS_FILE
or DB_NAME environment variables.