Field types reference
Use these field types when you create a table schema in Play. Pick the type that matches the kind of data you want to store, then add required or unique constraints only when you create the table.
Type | What it stores | Example |
|---|---|---|
Text | Any string | "Acme Corp" |
Number | Numeric values | 2500 |
Email addresses | ||
Phone | Phone numbers | +15550123 |
Boolean | True or false | Yes / No |
Date | Calendar date | March 15, 2026 |
Datetime | Date + time | March 15, 2026 at 2:30 PM |
Select | Predefined options (single or multiple) | "Active", "Churned" |
JSON | Structured data objects | Nested metadata |
Field constraints
Required - Every record must include a value
Unique - No two records can have the same value
These can only be set during initial table creation.
Was this helpful?