HOC SiteDocumentation

Field types

Every object field type, what it stores, and the constraints that apply to it.

Scalar types

TypeStoresNotes
textstringminLength / maxLength, optional unique.
multilineTextstringSame constraints, rendered as a textarea.
richTextstringRich text markup; see Rich text.
emailstringValidated as an email.
phonestringValidated as a phone number.
urlstringValidated as a URL.
numbernumbermin, max, step, integer.
booleanboolean—
enumstringenumOptions lists the allowed values.
dateISO dateDate only.
dateTimeISO timestampUses dateTimeConfig.
passwordstringHashed only on user kind; plain text elsewhere.

Media and files

TypeStoresNotes
imagefile referenceallowedMimeTypes, maxFileSizeBytes.
filefile referenceSame constraints as image.
socialLink{ platform, url }One link per platform.

Schedule

schedule stores dated slots with a validUntil, weekday slots, blocked exact dates, blocked annual dates, and an optional maximum of entries per slot. Use it for bookings and availability.

Relations

TypePoints at
relation_objectAn entry of relationObjectTypeId.
relation_userA website user entry.
relation_roleA website user role.

onDelete is soft_cascade, nullify, or restrict. A relation can be a single reference or a list.

Calculated

calculated fields derive a value from a formula: literal, path, number terms, date offset, comparison, logic, conditional, switch, lookup, or aggregate. resultType is number, date, dateTime, or boolean.

Behavior flags

  • localizable — one value per locale.
  • sensitive — never returned without an explicit field grant.
  • unique — one row per value.
  • sessionOwned — the value belongs to the current session.