/quote_revisions

Tag: quote_revisions

getAudit trail for quote changes — status updates, design updates, cancellations

Parameters

Name	In	Type	Format	Required	Description
`id`	query	string	—	—	—
`quote_id`	query	string	—	—	FK to the quote being revised
`revision_number`	query	string	—	—	Sequential revision counter per quote
`changed_by`	query	string	—	—	The user who triggered the change
`change_type`	query	string	—	—	Type of change: status_change, customization_update, cancellation
`change_summary`	query	string	—	—	Structured diff of what changed (field-level before/after)
`previous_status`	query	string	—	—	Quote status before the change
`new_status`	query	string	—	—	Quote status after the change
`previous_snapshot`	query	string	—	—	Full customization JSONB before a design update (only for customization_update)
`created_at`	query	string	—	—	—
`select`	query	string	—	—	Filtering Columns
`order`	query	string	—	—	Ordering
`Range`	header	string	—	—	Limiting and Pagination
`Range-Unit`	header	string	—	—	Limiting and Pagination
`offset`	query	string	—	—	Limiting and Pagination
`limit`	query	string	—	—	Limiting and Pagination
`Prefer`	header	string	—	—	Preference

Example

bash

curl "https://szkofkgbqogzlbqtcrke.supabase.co/rest/v1/quote_revisions?select=*&limit=10" \
  -H "apikey: YOUR_API_KEY" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN"

Responses

200OK

206Partial Content

postAudit trail for quote changes — status updates, design updates, cancellations

Parameters

Name	In	Type	Format	Required	Description
`quote_revisions`	body	object	—	—	quote_revisions
`select`	query	string	—	—	Filtering Columns
`Prefer`	header	string	—	—	Preference

Example

bash

curl -X POST "https://szkofkgbqogzlbqtcrke.supabase.co/rest/v1/quote_revisions" \
  -H "apikey: YOUR_API_KEY" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -H "Prefer: return=representation" \
  -d '{
  "quote_id": "00000000-0000-0000-0000-000000000000",
  "revision_number": 0,
  "change_type": "example",
  "change_summary": {}
}'

Responses

201Created

patchAudit trail for quote changes — status updates, design updates, cancellations

Parameters

Name	In	Type	Format	Required	Description
`id`	query	string	—	—	—
`quote_id`	query	string	—	—	FK to the quote being revised
`revision_number`	query	string	—	—	Sequential revision counter per quote
`changed_by`	query	string	—	—	The user who triggered the change
`change_type`	query	string	—	—	Type of change: status_change, customization_update, cancellation
`change_summary`	query	string	—	—	Structured diff of what changed (field-level before/after)
`previous_status`	query	string	—	—	Quote status before the change
`new_status`	query	string	—	—	Quote status after the change
`previous_snapshot`	query	string	—	—	Full customization JSONB before a design update (only for customization_update)
`created_at`	query	string	—	—	—
`quote_revisions`	body	object	—	—	quote_revisions
`Prefer`	header	string	—	—	Preference

Example

bash

curl -X PATCH "https://szkofkgbqogzlbqtcrke.supabase.co/rest/v1/quote_revisions?id=eq.YOUR_ID" \
  -H "apikey: YOUR_API_KEY" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
  -H "Content-Type: application/json" \
  -H "Prefer: return=representation" \
  -d '{"quote_id": "00000000-0000-0000-0000-000000000000"}'

Responses

204No Content

deleteAudit trail for quote changes — status updates, design updates, cancellations

Parameters

Name	In	Type	Format	Required	Description
`id`	query	string	—	—	—
`quote_id`	query	string	—	—	FK to the quote being revised
`revision_number`	query	string	—	—	Sequential revision counter per quote
`changed_by`	query	string	—	—	The user who triggered the change
`change_type`	query	string	—	—	Type of change: status_change, customization_update, cancellation
`change_summary`	query	string	—	—	Structured diff of what changed (field-level before/after)
`previous_status`	query	string	—	—	Quote status before the change
`new_status`	query	string	—	—	Quote status after the change
`previous_snapshot`	query	string	—	—	Full customization JSONB before a design update (only for customization_update)
`created_at`	query	string	—	—	—
`Prefer`	header	string	—	—	Preference

Example

bash

curl -X DELETE "https://szkofkgbqogzlbqtcrke.supabase.co/rest/v1/quote_revisions?id=eq.YOUR_ID" \
  -H "apikey: YOUR_API_KEY" \
  -H "Authorization: Bearer YOUR_ACCESS_TOKEN"

Responses

204No Content

Schema

Audit trail for quote changes — status updates, design updates, cancellations

Column	Type	Format	Nullable	Default	Notes
`id`PK	string	uuid	—	extensions.uuid_generate_v4()	This is a Primary Key.
`quote_id`	string	uuid	—	—	FK → `quotes.id`
`revision_number`	integer	integer	—	1	Sequential revision counter per quote
`changed_by`	string	uuid	✓	—	The user who triggered the change
`change_type`	string	text	—	—	Type of change: status_change, customization_update, cancellation
`change_summary`	object	jsonb	—	—	Structured diff of what changed (field-level before/after)
`previous_status`	string	text	✓	—	Quote status before the change
`new_status`	string	text	✓	—	Quote status after the change
`previous_snapshot`	object	jsonb	✓	—	Full customization JSONB before a design update (only for customization_update)
`created_at`	string	timestamp with time zone	✓	now()	—