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.

Metadata schema

fmsz

Report, selector, screen, table, and database metadata

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

Source live · Updated 2026-09-27T00:00:11Z

10.1.48-MariaDB degraded

Replication status

Replica I/O running, SQL stopped

Query partially completed on the master (error on master: 1927) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with S...

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: degraded
Replica threads: I/O Yes, SQL No
Behind: unknown
Master: 196.11.250.14:3306
Last errno: 1927
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_PGMS

DSP 1350

MAN 295

MDL 65

ZZD 24

PRT 17

UPD 5

DEL 4

SEL 2

ENQ 1

Largest 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