Metadata schema
fmsz
Report, selector, screen, table, and database metadata
Canonical map in progress
Decode the Freshmark stack.
This workspace tracks the replication server, the metadata schemas, and the menu/report definitions we need for a rebuild. The snapshot below comes from local database exploration and can be refreshed at any time.
Snapshot generated
2026-03-15T22:18:24Z
Run uv run freshmark-canonical snapshot to refresh it from the live MariaDB container.
Menu schema
fmsx
Live menu rows and security groups
Reports discovered
142
Definitions pulled from ZE_ENQ
Programs discovered
1763
Definitions pulled from ZP_PGMS
Selectors discovered
837
Reusable lookup definitions from ZS_SEL
Menu rows
1869
Entries pulled from ZM_MENU
Server inventory
10.1.48-MariaDB
healthy
Replication status
Replica I/O and SQL threads are running
No replication error reported.
Polling can refresh the replication state without reloading the page.
- Host
- 127.0.0.1:3306
- User
- remote
- Databases
- 13
- Canonical docs
- 5 markdown files
- Replication
- healthy
- Replica threads
- I/O Yes, SQL Yes
- Behind
- caught up
- Master
- 196.11.250.14:3306
- Last errno
- none
- Slave I/O state
- Waiting for master to send event
Most-used report tables
from ZE_ENQ
STK_DETS
59 reports
STK_TRANS
42 reports
LOC_TRANS
8 reports
AUD_STK_DETS
7 reports
DEBTOR_MAST
6 reports
PALL_TRANS
4 reports
STK_MAST
4 reports
AUD_REPRINTS
3 reports
Program type mix
from ZP_PGMSLargest menus
from ZM_MENU
ADMINI_REPS
168 items
DEBTORS
89 items
ADMIN_REPORTS
62 items
AGN_DELS
61 items
COLDSTORAGE
57 items
COMM_SALES
54 items
CASHIERSMNU
47 items
DELIVERIES
47 items