Project Variables

_id
accountId
projectId
key
value
createdTime
modifiedTime
projects

_id (Primary Key) objectid

Requires a Non-Null Value

accountId objectid

Requires a Non-Null Value

projectId objectid

Requires a Non-Null Value

key string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

value string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

createdTime datetime

System managed property. Set to the timestamp of when the record is created.

Requires a Non-Null Value	Yes
Default Value	__auto__

modifiedTime datetime

System managed property. Set to the timestamp of when the record is updated.

Requires a Non-Null Value	Yes
Default Value	__auto__

projects join

Data Model	projects
Local Property	projectVariables.projectId
Foreign Property	projects._id