Skip to content

Table1

An exemplar schema demonstrating various field types and constraints

Primary Key

id

Fields

Name Definition Type
id

Unique identifier for the record

Constraints
  • required: true
  • pattern: ^t1-[0-9]{3}$
Examples
  • t1-001
  • t1-002
  • t1-003
string
name

Name of the entity

Constraints
  • required: true
  • minLength: 3
  • maxLength: 100
Examples
  • Example Entity
  • Sample Item
string
status

Current status of the entity

Constraints
  • required: true
  • enum: active, inactive, pending
Categories
  • active
  • inactive
  • pending
Examples
  • active
  • inactive
  • pending
string
value

Numeric value associated with the entity

Constraints
  • required: true
  • minimum: 0
Examples
  • 100.5
  • 250.75
  • 500
number
itemCount?

Count of items

Constraints
  • minimum: 0
  • maximum: 1000
Examples
  • 5
  • 10
  • 25
integer
isVerified

Whether the entity has been verified

Constraints
  • required: true
Examples
  • true
  • false
boolean
createdDate

Date when the entity was created

Constraints
  • required: true
Examples
  • 2024-01-15
  • 2024-03-20
date
description?

Optional description of the entity

Examples
  • This is a sample description
  • Additional notes about the entity
string