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
|
string
|
table1Id?
|
Reference to the parent table1 record. If not provided, the record is independent |
string
|
title
|
Title or name of the item Constraints
|
string
|
amount
|
Monetary or numeric amount Constraints
|
number
|
priority
|
Priority level of the item Constraints
|
categorical
|
percentage?
|
Percentage value between 0 and 100 Constraints
|
number
|
notes?
|
Additional notes or comments Constraints
|
string
|
isActive
|
Whether the item is currently active |
boolean
|