Bilingual Lease Documents (Qatar)
Qatar lease contracts are bilingual: an Arabic and an English text, and the Arabic version prevails before a court or the Rental Dispute Settlement Committee (Law 4/2008). PMFriend stores that pair per lease and renders it side-by-side.
PMFriend never machine-translates a contract. Anything contract-adjacent is gated on human Arabic legal review — the product stores and displays the two texts your practitioner produced; it makes no claim about their legal equivalence.
Data model
- Table
lease_documents(migrationV38): at most one document per (lease, language) —language IN ('ENGLISH','ARABIC'), enforced by a unique constraint. Re-uploading a language replaces the row and the blob (row first, old blob deleted after the save, so a failed replacement never leaves the lease without its previous file). - Blobs ride the same
DocumentStorageadapter as property documents (S3 in production, filesystem in dev), keyedlease-documents/{leaseId}/{documentId}.{ext}. - Accepted: PDF or an image scan (JPEG/PNG/WebP/HEIC), max 25 MB.
- Row-level security: same per-agency isolation as every other table.
API
| Endpoint | What |
|---|---|
POST /api/v1/leases/{leaseId}/documents | multipart file + language=ENGLISH|ARABIC; replaces the existing version of that language |
GET /api/v1/leases/{leaseId}/documents | the stored pair (0–2 entries; each carries prevails: true for Arabic) |
GET /api/v1/lease-documents/{id}/download | streams the file; ?inline=true serves it inline so the SPA can iframe it |
Admin UI
On the property page's Current lease card (shown for QAR-currency agencies): a Contract versions section with two slots — English and العربية · Arabic (badged Prevails) — upload/replace per slot, and a View side-by-side toggle that renders both PDFs in paired iframes.
RDSC case-pack integration
The Qatar case pack's Lease & registration evidence
section now records the contract versions on file per lease
(— contract versions on file: Arabic (prevails, uploaded …) + English).
When no Arabic version is on file for any lease, the pack carries a
CAUTION: the Arabic text prevails before the Committee, and an English-only
contract may need a certified Arabic translation before filing. As
everywhere: record statements, not legal conclusions.
See also
- Qatar — Compliance Defaults — the lease-registration and deposit-return timers
- Case Pack — RDSC framing
- Qatar Market Roadmap — where this sits in the plan