order

0 rows where seller_id = 0

✎ View and edit SQL

This data as json

0 records

CREATE TABLE "order" (
    order_id            INTEGER PRIMARY KEY AUTOINCREMENT,
    proposal_id         INTEGER REFERENCES proposal(proposal_id),
    conversation_id     INTEGER NOT NULL REFERENCES conversation(conversation_id),
    seller_id           INTEGER NOT NULL REFERENCES seller(seller_id),
    customer_id         INTEGER NOT NULL REFERENCES customer(customer_id),
    status              TEXT NOT NULL DEFAULT 'pending',
    total_cents         INTEGER NOT NULL DEFAULT 0,
    payment_method      TEXT,
    payment_status      TEXT NOT NULL DEFAULT 'pending',
    shipping_address    TEXT,
    tracking_info       TEXT NOT NULL DEFAULT '{}',
    notes               TEXT,
    created_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    updated_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    closed_at           TEXT,
    CHECK (status IN ('pending', 'confirmed', 'shipped', 'delivered', 'cancelled', 'returned')),
    CHECK (payment_status IN ('pending', 'paid', 'refunded'))
);
CREATE INDEX idx_order_seller ON "order"(seller_id);
CREATE INDEX idx_order_customer ON "order"(customer_id);