1. ZenTao API development guides
1.1 Configuration and FAQ
1.2 Examples of the calling SDK
1.3. Department interface
1.3.1 Get the department list
1.3.2 Batch create departments
1.4. User interface
1.4.1 Get patameters of adding users
1.4.2 Add a single user
1.4.3 Get the user list
1.5. Product interface
1.5.1 Get the product list
1.5.2 Optional information for adding a single product
1.5.3 Create a single product
1.6. Project interface
1.6.1 Get the project list
1.6.2 Optional information for adding a single project
1.6.3 Create a single project
1.7. Task interface
1.7.1 Get the task list
1.7.2 Optional information for adding a single task
1.7.3 Create a single task
1.7.4 Optional information for finishing a single task
1.7.5 Finish a single task
1.8. Bug interface
1.8.1 Get the bug list
1.8.2 Optional information for reporting a single bug
1.8.3 Report a single bug
1.8.4 Optional information for resolving a single bug
1.8.5 Resolve a single bug
2. ZenTao API documents (V1.0)
2.1. Token
2.1.1 Get Token
2.2. Department
2.2.1 Get the department list
2.2.2 Get department details
2.3. User
2.3.1 Access to my profile
2.3.2 Get the user list
2.3.3 Get user information
2.3.4 Edit user information
2.3.5 Delete users
2.3.6 Create users
2.4. Program
2.4.1 Get the program list
2.4.2 Edit programs
2.4.3 Access to program details
2.4.4 Delete programs
2.4.5 Create programs
2.5. Product
2.5.1 Get the product list
2.5.2 Create products
2.5.3 Get product details
2.5.4 Edit products
2.5.5 Delete products
2.6. Product plan
2.6.1 Get the list of product plans
2.6.2 Create plans
2.6.3 Get plan details
2.6.4 Edit plans
2.6.5 Delete plans
2.6.6 Link the stories to the product plan
2.6.7 Cancel the link between the product plans and stories
2.6.8 Link the bugs to the product plan
2.6.9 Cancel the link between the product plan and bugs
2.7. Release
2.7.1 Get the release list of product
2.7.2 Get the release list of project
2.8. Story
2.8.1 Get the story list of product
2.8.2 Get the story list of project
2.8.3 Get the story list of execution
2.8.4 Create story
2.8.5 Get story details
2.8.6 Change a story
2.8.7 Change some other fileds of story
2.8.8 Delete a story
2.9. Project
2.9.1 Get project list
2.9.2 Create a project
2.9.3 Get project details
2.9.4 Modify a project
2.9.5 Delete a project
2.10. Build
2.10.1 Get the build list of project
2.10.2 Get the build list of execution
2.10.3 Create a build
2.10.4 Get build details
2.10.5 Modify a build
2.10.6 Delete a build
2.11. Execution
2.11.1 Get the execution list of project
2.11.2 Create execution
2.11.3 Check the details of execution
2.11.4 Modify execution
2.11.5 Delete execution
2.12. Task
2.12.1 Get the task list of execution
2.12.2 Create task
2.12.3 Get task details
2.12.4 Modify task
2.12.5 Delete task
2.12.6 Start task
2.12.7 Suspend task
2.12.8 Continue task
2.12.9 Finish task
2.13. Bug
2.13.1 Get the bug list of product
2.13.2 Create bug
2.13.3 Get bug details
2.13.4 Modify bug
2.13.5 Delete bug
2.14. Use case
2.14.1 Get use case list of product
2.14.2 Create use case
2.14.3 Get use case details
2.14.4 Modify test case
2.14.5 Delete test case
2.14.6 Run test case
2.15. Test request
2.15.1 Get test request list
2.15.2 Get the test request of project
2.15.3 Get the details of test reuqest
2.16. Feedback
2.16.1 Create feedback
2.16.2 Assign feedback
2.16.3 Close feedback
2.16.4 Delete feedback
2.16.5 Modify feedback
2.16.6 Get feedback details
2.16.7 Get feedback list
2.17. Ticket
2.17.1 Get the ticket list
2.17.2 Get the ticket details
2.17.3 Modify a ticket
2.17.4 Create a ticket
2.17.5 Delete a ticket
3. Customized development
3.1 Secondary development mechanism
3.2 The directory structure of ZenTao
3.3 Find your target file to be modified
3.4 The database structure of ZenTao
3.5 Public module - common
3.6 How to register on menu
3.7 How to register on permission
3.8 Example: how to modify the prompt
3.9 Example: priority field setting when creating bugs
3.10 The online extension editor
3.11 Secondary development editor and translation function restrictions instructions
3.12 ZenTao project management software packaging specification (V1.1)

The database structure of ZenTao

2022-12-21 11:26:31
Last edited by Hongyan on 2023-01-04 14:33:21
Share links

The database naming in ZenTao is kind of simple, it's easy to find the meaning through reading the names. If you think it's not clear, no worries, just go to the lists below to search their names and check the descriptions.

Or you can go to Admin - Develop - Database to check the description of each item.

1. List about My

  • zt_todo: todo list

2. List about Product

  • zt_product: here you can find product-related information
  • zt_productplan: here you can find the plan information about product
  • zt_story: it is a very important list that records all the requirement records in the system.
  • zt_storyspec: here you can find the specific description of stories.
  • zt_storystage: here you can find the stages of story.
  • zt_release: here you can find the product release information. At the same time, it's associated with zt_build.
  • zt_branch: here you can find the branch and platform of product.

3. List about Project

  • zt_project: project list.
  • zt_projectproduct: here you can find the relationship between project and product.
  • zt_projectstory: here you can find the story lists that need to be done in the project.
  • zt_task: task list.
  • zt_burn: the list of burn down chart data. The burndown chart is drawn based on the data in this list.
  • zt_team: here you can find the team member in project.
  • zt_build: here you can find the build list of product.
  • zt_taskestimate: here you can find the list of working hours record.

4. List about QA

  • zt_bug: bug list. It's a list that everyone is very familiar with.
  • zt_case: case list. Here you can find all the test case.
  • zt_casestep: here you can find the steps related to the use case, which including history.
  • zt_testtask: test build list. Here you can find the test tasks for each build.
  • zt_testrun: here you can find the execution of the use cases corresponding to each test task.
  • zt_testresult: here you can find the result of each execution of each use case.
  • zt_testsuite: test suite list.
  • zt_suitecase: suite case list.
  • zt_testreport: test report list.

5. List about Doc

  • zt_doclib: here you can find the customized document library list.
  • zt_doc: here you can find all the documents.
  • zt_doccontent: here you can find the content list of the document.

6. List about System

  • zt_user: user list.
  • zt_group: group list.
  • zt_usergroup: correspondence between users and groups.
  • zt_grouppriv: privileges of the groups.
  • zt_dept: the list of departments.
  • zt_userquery: user-defined query list.
  • zt_usertpl: user-defined template list.
  • zt_usercontact: user contacts list.
  • zt_company: here you can find the company information on this list and is the top one.

7. List about Admin

  • zt_action: the list of system logs.
  • zt_cron: cron task list.
  • zt_extension: extension list.
  • zt_history: dynamic history list. Here you can find all the change records of any object, including the changes of values before and after.
  • zt_lang: language definitions list.

8. List about other modules

  • zt_module: it's one of the most important lists in ZenTao. Here you can find the module division data in ZenTao system, such as the module division of requirements.
  • zt_effort: effort list.
  • zt_entry: application list.
  • zt_log: interface log list.
  • zt_mailqueue: mailing list.
  • zt_module: module list. Here you can find the information of modules.
  • zt_notify: notification list.
  • zt_score: score list.
  • zt_file: attached file list.
  • zt_block: block list. Here you can find the block information about My-Dashboard, Product-Dashboard, Project-Dashboard, and QA-Dashboard.
  • zt_config: configuration list.
  • zt_webhook: here you can find the webhook information.
  • zt_webhookdatas: here you can find the webhook data list.
Write a Comment
Comment will be posted after it is reviewed.