[Feature] [doc] Update table schema for task-structure and metadata

[zhongjiajie]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

I find out task-structure and metadata table schema is out of dated. I would confuse users when they read them. I think we should update them in the next version release.

BTW, I think we should find a good way to auto-update the table schema to just do not show them in our doc. When some PR upgrade the schema by without update the doc, will make our doc out-of-date

What you expected to happen

ATT

How to reproduce

ATT

Anything else

No response

Version

2.0.4

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

Hi:

• Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
• In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
• If you haven't received a reply for a long time, you can subscribe to the developer's email，Mail subscription steps reference https://dolphinscheduler.apache.org/en-us/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.

[QuakeWang]

Please assign this to me, I will do it.

[zhongjiajie]

@QuakeWang I assinged to you, but maybe we should find some ways to auto -generate table schema base on our SQL file to make our docs update from code. WDYT

[QuakeWang]

@QuakeWang I assinged to you, but maybe we should find some ways to auto -generate table schema base on our SQL file to make our docs update from code. WDYT

Good idea! I will be looking for tools on how to automate the generation.

[zhongjiajie]

Thanks and I looking forward about it

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.