Database Connections

_id
name
accountId
projectId
engine
host
port
user
password
options
databaseName
requestTimeout
createdTime
modifiedTime
projects

_id (Primary Key) objectid

Requires a Non-Null Value

name string

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

accountId objectid

Requires a Non-Null Value

projectId objectid

Requires a Non-Null Value

engine options

Requires a Non-Null Value	Yes
Allowed Values	mysql, postgresql, mssql, oracledb
Default Value	mysql

host string

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

port string

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

user string

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

password string

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

options string

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

databaseName string

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

requestTimeout integer

Requires a Non-Null Value	Yes
Default Value	15000

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	databaseConnections.projectId
Foreign Property	projects._id