Probes every tare_source and scan_type value the app code uses, by attempting a real INSERT to the tickets table.
Pass = the database accepts that value. Fail = constraint mismatch (which would silently break a driver scan in production).
All test tickets are inserted into the Test project and deleted after the test completes.
⚙️ Run Test
Test takes 5-15 seconds. It inserts ~15 test tickets, records which ones pass the CHECK constraints,
then deletes them all. The test ticket project is the placeholder "Test project" (UUID 278d4428-...).
📦 tare_source CHECK constraint
These values are written to tickets.tare_source by scale.html. Each value must be accepted by the database.
Value (from app code)
Status
Detail
🏷️ scan_type CHECK constraint
These values are written to tickets.scan_type from scale.html, admin manual entry, OCR batch, and orphan resolve flows.