requests

29 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status, created_by, note, reject_reason, created_at, zort_status, created_at (date), decided_at (date), zort_errors (array)

CREATE TABLE requests (
                id              INTEGER PRIMARY KEY AUTOINCREMENT,
                request_no      TEXT UNIQUE NOT NULL,   -- เช่น ADJ-20260502-001
                type            TEXT NOT NULL,          -- produce | repack | adjust
                status          TEXT DEFAULT 'pending', -- pending | approved | rejected
                created_by      TEXT NOT NULL,
                note            TEXT,
                reject_reason   TEXT,
                created_at      TEXT DEFAULT (datetime('now','localtime')),
                decided_at      TEXT,
                decided_by      TEXT
            , zort_errors TEXT, zort_status TEXT DEFAULT 'na');