proposal_line_item

0 rows where product_id = 47

✎ View and edit SQL

This data as json

0 records

CREATE TABLE proposal_line_item (
    line_item_id        INTEGER PRIMARY KEY AUTOINCREMENT,
    proposal_id         INTEGER NOT NULL REFERENCES proposal(proposal_id) ON DELETE CASCADE,
    product_id          INTEGER NOT NULL REFERENCES product(product_id),
    product_snapshot    TEXT NOT NULL DEFAULT '{}',
    quantity            INTEGER NOT NULL DEFAULT 1,
    unit_price_cents    INTEGER NOT NULL DEFAULT 0,
    total_cents         INTEGER NOT NULL DEFAULT 0,
    created_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now'))
);
CREATE INDEX idx_proposal_line_item_proposal ON proposal_line_item(proposal_id);