Table2
An exemplar schema demonstrating foreign key relationships and additional constraints
Primary Key
id
Foreign Keys
| Fields | Reference Resource | Reference Fields |
|---|---|---|
table1Id
|
table1
|
id
|
Fields
| Name | Definition | Type |
|---|---|---|
id
|
Unique identifier for the record Constraints
|
string
|
table1Id?
|
Reference to the parent table1 record. If not provided, the record is independent Examples
|
string
|
title
|
Title or name of the item Constraints
|
string
|
amount
|
Monetary or numeric amount Constraints
|
number
|
priority
|
Priority level of the item Constraints
|
string
|
percentage?
|
Percentage value between 0 and 100 Constraints
|
number
|
notes?
|
Additional notes or comments Constraints
|
string
|
isActive
|
Whether the item is currently active Constraints
|
boolean
|