Field API

const base = f.text(255).required();
const title = base.label("Title");
const slug = base.label("Slug").inputOptional();
// base, title, and slug are all separate instances

title: f.text(255).required(),
slug: f.text(100).required().inputOptional(),

bio: f.text({ mode: "text" }),

description: f.textarea().localized(),
notes: f.textarea(),

email: f.email().required(),

website: f.url(),

username: f.text(50).required().trim().lowercase().pattern(/^[a-z0-9_]+$/),

// Integer (default)
quantity: f.number().required(),

// Specific integer modes
port: f.number("smallint"),
totalViews: f.number("bigint"),

// Floating point
rating: f.number("real").min(0).max(5),
longitude: f.number("double"),

// Decimal (fixed precision)
price: f.number({ mode: "decimal", precision: 10, scale: 2 }).required(),

price: f.number({ mode: "decimal", precision: 10, scale: 2 }).positive().step(0.01),
rating: f.number().min(1).max(5),

isActive: f.boolean().default(true).required(),
isPublished: f.boolean().default(false),

publishedAt: f.date(),
birthDate: f.date().required(),

scheduledAt: f.datetime().required(),
createdAt: f.datetime({ precision: 6 }).autoNow().inputFalse(),

startTime: f.time(),
openAt: f.time({ precision: 3 }),

createdAt: f.datetime().autoNow().inputFalse(),
updatedAt: f.datetime().autoNowUpdate().inputFalse(),

// Simple string options
status: f.select(["draft", "published", "archived"]).default("draft").required(),

// Options with labels (supports i18n)
status: f.select([
  { value: "pending", label: { en: "Pending", sk: "Cakajuce" } },
  { value: "confirmed", label: { en: "Confirmed", sk: "Potvrdene" } },
  { value: "completed", label: { en: "Completed", sk: "Dokoncene" } },
]).required().default("pending"),

tags: f.select(["frontend", "backend", "devops", "design"]).array(),

status: f.select(["active", "inactive", "suspended"]).enum("user_status"),

address: f.object({
  street: f.text(),
  city: f.text().required(),
  zip: f.text(10),
  country: f.text(2).required(),
}),

workingHours: f.object({
  monday: f.object({
    isOpen: f.boolean().default(true),
    start: f.time(),
    end: f.time(),
  }),
  tuesday: f.object({
    isOpen: f.boolean().default(true),
    start: f.time(),
    end: f.time(),
  }),
}),

.fields(({ f }) => {
  const daySchedule = {
    isOpen: f.boolean().default(true),
    start: f.time(),
    end: f.time(),
  };

  return {
    workingHours: f.object({
      monday: f.object(daySchedule),
      tuesday: f.object(daySchedule),
      // ...
    }),
  };
})

socialLinks: f.object({
  platform: f.select(["instagram", "facebook", "twitter"]),
  url: f.url(),
}).array().maxItems(5),

metadata: f.json(),
config: f.json({ mode: "json" }),  // use PG json instead of jsonb

// Simple belongs-to
author: f.relation("users"),
barber: f.relation("barbers").required(),

posts: f.relation("posts").hasMany({ foreignKey: "authorId" }),

services: f.relation("services").manyToMany({
  through: "barberServices",
  sourceField: "barberId",
  targetField: "serviceId",
}),

assignees: f.relation("users").multiple(),

commentable: f.relation({
  post: "posts",
  page: "pages",
}),

author: f.relation("users").required().onDelete("set null"),
category: f.relation("categories").onDelete("cascade"),

// Simple upload (defaults to "assets" collection)
avatar: f.upload(),

// With constraints
avatar: f.upload({
  to: "assets",
  mimeTypes: ["image/*"],
  maxSize: 5_000_000,  // 5MB
}),

gallery: f.upload({
  to: "assets",
  through: "productImages",
  mimeTypes: ["image/*"],
}),

import { pgTable, citext } from "drizzle-orm/pg-core";

handle: f.from(citext, z.string().min(3).max(30)),