Skip to content

Table2

Primary Key

id

Foreign Keys

Columns Reference Resource Reference Columns
table1Id table1 id

Columns

Name Definition Type
id

Unique identifier for the record

Constraints
  • pattern: ^t2-[0-9]{3}$
string
table1Id?

Reference to the parent table1 record. If not provided, the record is independent

string
title

Title or name of the item

Constraints
  • minLength: 1
  • maxLength: 200
string
amount

Monetary or numeric amount

Constraints
  • minimum: 0
number
priority

Priority level of the item

Constraints
  • enum: low, medium, high
Categories
  • low
  • medium
  • high
categorical
percentage?

Percentage value between 0 and 100

Constraints
  • minimum: 0
  • maximum: 100
number
notes?

Additional notes or comments

Constraints
  • maxLength: 500
string
isActive

Whether the item is currently active

boolean