JSON schema
v1: Original form
v2: Redesigned form
Answer mapping · v1
The Express route copies the stable answer keys into these columns. Renaming a question doesn't change its answer key.
| Question name | Answer key (valueName) | Database column |
|---|
JSON definition · shared/definitions/relational-storage.v1.json
View on GitHub
{
"title": "Insurance claim",
"elements": [
{
"type": "text",
"name": "q_email",
"valueName": "customer_email",
"dbColumn": "claims.customer_email",
"title": "Email",
"inputType": "email",
"isRequired": true
},
{
"type": "text",
"name": "q_amount",
"valueName": "amount",
"dbColumn": "claims.amount",
"title": "Amount claimed",
"inputType": "number",
"min": 0
},
{
"type": "dropdown",
"name": "incident",
"title": "What happened?",
"choices": [
{
"value": "collision",
"text": "Collision"
},
{
"value": "theft",
"text": "Theft"
},
{
"value": "weather",
"text": "Storm or flood"
}
]
},
{
"type": "comment",
"name": "details",
"title": "Details"
},
{
"type": "boolean",
"name": "priority_handling",
"title": "Priority handling"
}
]
}
JSON definition · shared/definitions/relational-storage.v2.json
View on GitHub
{
"title": "Insurance claim",
"elements": [
{
"type": "panel",
"name": "contact",
"title": "Contact",
"elements": [
{
"type": "text",
"name": "contact_email",
"valueName": "customer_email",
"dbColumn": "claims.customer_email",
"title": "Where should we write to you?",
"inputType": "email",
"isRequired": true
}
]
},
{
"type": "panel",
"name": "claim",
"title": "Claim",
"elements": [
{
"type": "dropdown",
"name": "incident",
"title": "What happened?",
"choices": [
{
"value": "collision",
"text": "Collision"
},
{
"value": "theft",
"text": "Theft"
},
{
"value": "weather",
"text": "Storm or flood"
}
]
},
{
"type": "text",
"name": "claimed_total",
"valueName": "amount",
"dbColumn": "claims.amount",
"title": "Total amount you are claiming",
"inputType": "number",
"min": 0
},
{
"type": "comment",
"name": "details",
"title": "Details"
},
{
"type": "boolean",
"name": "priority_handling",
"title": "Priority handling"
}
]
}
]
}
Client · shared/client/relational-storage.js · sjs:relational-storage.client
View on GitHub
import { Model, Serializer } from "survey-core";
// Optional metadata describing the columns used by the server
Serializer.addProperty("question", { name: "dbColumn", category: "data" });
// Keep answer keys stable when question names change
const survey = new Model(definitions[definitionVersion]);
survey.completeText = "Submit claim";
Client · shared/client/relational-storage.js · sjs:relational-storage.save
View on GitHub
async function saveClaim(data, definitionVersion) {
const response = await fetch("/api/claims", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({ data, definitionVersion })
});
if (!response.ok) throw new Error("Save failed");
return response.json();
}
Server · routes/relational-storage.js · sjs:relational-storage.server
View on GitHub
// POST /api/claims — original JSON first, then the columns you query
app.post("/api/claims", (req, res) => {
const { data, definitionVersion } = req.body ?? {}; // the parsed raw body: {} stays {}
if (data == null || definitionVersion == null) throw httpError(400, "Expected { data, definitionVersion }");
const id = transaction(db(req), () => {
const responseId = insertResponse(req, "claim", data, definitionVersion); // the original and its version
db(req).prepare("INSERT INTO claims (response_id, customer_email, amount) VALUES (?, ?, ?)")
.run(responseId, data.customer_email ?? null, data.amount ?? null); // keys come from valueName
return responseId;
});
res.status(201).json({ id });
});