aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_save_draft
Parameters
Name
Type
Mode
user_id
integer
IN
draft_type
integer
IN
draft_data
json
IN
ref_id
integer
IN (DEFAULT NULL)
Definition
INSERT INTO draft(user_id, draft_type, draft_data, ref_id) VALUES ($1, $2, $3, $4) ON CONFLICT(draft_type, user_id) DO UPDATE SET draft_data = $3, modify_time = current_timestamp RETURNING id