refund_attributions

28,621 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE refund_attributions (
    store                     TEXT NOT NULL,
    refund_id                 TEXT NOT NULL,
    order_id                  TEXT,
    refund_at                 TEXT NOT NULL,

    refund_amount             REAL,
    refund_tax                REAL,
    refund_reason             TEXT,
    refund_item_count         INTEGER,

    bc_user_id                INTEGER,
    issuer_email              TEXT,
    issuer_name               TEXT,
    issuer_confidence         TEXT,

    customer_email            TEXT,

    gorgias_ticket_id         TEXT,
    gorgias_ticket_subject    TEXT,
    gorgias_assignee_email    TEXT,
    gorgias_match_confidence  TEXT,

    source_event_id           INTEGER,
    built_at                  TEXT NOT NULL,

    PRIMARY KEY (store, refund_id)
);
CREATE INDEX idx_refund_attr_refund_at
    ON refund_attributions (refund_at DESC);
CREATE INDEX idx_refund_attr_issuer
    ON refund_attributions (issuer_email, refund_at DESC);
CREATE INDEX idx_refund_attr_store
    ON refund_attributions (store, refund_at DESC);
CREATE INDEX idx_refund_attr_bc_user
    ON refund_attributions (store, bc_user_id);