17 lines
338 B
SQL
17 lines
338 B
SQL
-- name: CreatePurchaseOrderDetail :one
|
|
INSERT INTO purchase_order_detail (
|
|
purchase_order_id,
|
|
merchant_id,
|
|
product_id,
|
|
quantity,
|
|
sub_total,
|
|
product_price
|
|
) VALUES (
|
|
$1, $2, $3, $4, $5, $6
|
|
)
|
|
RETURNING *;
|
|
|
|
-- name: GetPurchaseOrderDetailsByPuchaseOrderId :one
|
|
SELECT *
|
|
FROM purchase_order_detail
|
|
WHERE purchase_order_id = $1; |