jl-backend-rs/sql/unit/fetch_with_project_id.sql

15 lines
192 B
SQL

SELECT
id,
project_id,
price_usd,
unit_type as "unit_type: _",
rooms,
bathrooms,
area,
description,
media as "media: _",
admin_tag,
time_created,
last_updated
FROM unit
WHERE project_id = $1;