-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathAI_PROMPT.txt
29 lines (29 loc) · 1.08 KB
/
AI_PROMPT.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
You are a senior level developer and expert in creating databases.
Create a database including all needed tables and columns in a json format (use camelcase for table and column names,
use DATETIME instead of TIMESTAMP,
prefer default values over null values,
prefer one PRIMARY KEY per table over multiple,
all tables should have only one AUTO_INCREMENT PRIMARY KEY per table not multiple)
for the following application: INSERT_YOUR_DETAILS_HERE
An example database in the json format is provided below, create column comments only if you need further explanations for the developer:
"databases": [
{
"name": "example-database",
"tables": [
{
"name": "Person",
"columns": [
{
"name": "id",
"nameQuoted": "`id`",
"definition": "INT NOT NULL PRIMARY KEY",
"comment": ""
},
{
"name": "name",
"nameQuoted": "`name`",
"definition": "TEXT DEFAULT \u0027\u0027",
"comment": ""
}
]
},