Database Structure
- 2015-09-14 15:05:28
- azalea
- 11521
- Last edited by Taotao on 2020-03-19 20:11:20
- Share links
The naming of ZenTao databases is quite simple and concise. You can guess the purposes and functions of each table by the names. If you are not clear of it, find them in the corresponding language files of tables.
1. Product related tables
zt_product //product-reated information;zt_productPlan //product-related plans;
zt_story //an important table recording all the stories; zt_storySpec records the history of stories;
zt_release // records release information of the product. This table is also mutually associated to zt_build.
2. Project related tables
zt_project //project tables;zt_projectProduct //the correlations between projects and products;
zt_proejctStory //all the stories that will be done in the projects;
zt_task //task tables;
zt_burn //data lof the Burndown chart, which is generated based on the data in this table;
zt_team // the team members in the project;
zt_build //records the build lists of the products in the project.
3. Test related tables
zt_bug //bug tables;zt_case //test case tables; zt_caseStep records the history and steps of cases;
zt_testTask //test task tables;
zt_testRun //executions of test cases corresponded to test tasks;
zt_testResult //the execution results of each test case.
4. Document library related tables
zt_docLib //lists of the custom document libraries;zt_doc //all the documents.
5. Company related tables
zt_user //user tables;zt_group //group tables;
zt_userGroup //correlations between users and groups;
zt_groupPriv //group previleges;
zt_dept //department structure tables;
zt_userQuery //custom query tables;
zt_userTPL //custom templates tables;
zt_todo //to-do tables;
6. Common tables
zt_company //a root table recording the information about the company;zt_module //an important table which maintains the data of the division of modules in ZenTao;
zt_action //action history tables, recording all the change history of each object;
zt_history //records the value changes before and after actions;
zt_file //file tables.
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