The database structure of ZenTao
- 2022-12-21 11:26:31
- Kelsea
- 1242
- 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
Support
- Book a Demo
- Tech Forum
- GitHub
- SourceForge
About Us
- Company
- Privacy Policy
- Term of Use
- Blogs
- Partners
Contact Us
- Leave a Message
- Email Us: support@zentaoalm.com