CREATE TABLE sales_order_payment (
  id BIGSERIAL PRIMARY KEY,
  sales_order_id BIGINT NOT NULL REFERENCES sales_order(id) ON DELETE CASCADE,
  payment_method_id BIGINT NOT NULL REFERENCES payment_method(id) ON DELETE RESTRICT,
  amount NUMERIC(14, 2) NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMP NOT NULL DEFAULT NOW(),
  CONSTRAINT chk_sales_order_payment_amount_positive CHECK (amount > 0)
);

CREATE INDEX idx_sales_order_payment_order ON sales_order_payment(sales_order_id);
CREATE INDEX idx_sales_order_payment_method ON sales_order_payment(payment_method_id);