Add comment of Table or Column Name by OpenAI API #265
stella0320
started this conversation in
Ideas
Replies: 1 comment 1 reply
-
You can technically use an LLM to generate the whole diagram |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
After designing the structure, I need to type the comments myself. It spent lot of time.....
Because of that, it reminds me a new idea.
If I have a button to trigger, it makes openAI help me automatically generate comment based on colomn name, it's convenient.
My artificial action now is
Step1. Design Sechma on draw.io
Step2. copy sql script text into chatGPT and add some prompt after sql script.
`"CREATE TABLE "V_AGENT_GOUP_AUTH_MENU" (
"ID" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,
"AGENT_GROUP_ID" INTEGER NOT NULL,
"AUTH_MENU_ID" INTEGER NOT NULL,
PRIMARY KEY("ID")
);
CREATE TABLE "AUTH_MENU" (
"AUTH_MENU_ID" INTEGER NOT NULL UNIQUE GENERATED BY DEFAULT AS IDENTITY,
"MENU_NAME" TEXT NOT NULL,
"URL" TEXT NOT NULL,
PRIMARY KEY("AUTH_MENU_ID")
);"please filled in by adding comments based on the column name and table name and use English
Step3. ChatGPT help fill up comment based on the column name,and then I copy the comment from chatGPT reponse to my drawdb
I think the comments given by ChatGPT are almost exactly what I had in mind.
Beta Was this translation helpful? Give feedback.
All reactions