requests

✎ View and edit SQL

This data as json

0 records

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
            );