1 Introduction
1.1  About ZenTao
1.2  How to get support
2 How to Install ZenTao
2.1  Choose the best installation
2.2  ZenTao Cloud
2.3  One-click Installation Package for Windows (Recommended)
2.4  One-click Installation Package for Linux
2.5  Source Code Installation Package (for all Systems)
2.6  Set up Virtualbox for ZenTao
2.7  Softaculous service
3 Upgrade ZenTao
3.1  Choose Upgrade
3.2  Upgrade by source codes (General for all systems)
3.3  Upgrade for one-click installation package for windows users (xampp)
3.4  Upgrade for one-click installation package for Linux
4 Users and Groups
5 Simple Application
6 Basic Application
6.1  Basic Workflow
6.2  Agile and Scrum
6.3  ZenTao and Scrum
6.4  ZenTao Tutorial for Rookies
6.5  Create a Product
6.6  Create a Story
6.7  Create a Project
6.8  Confirm Stories
6.9  Decompose Tasks
6.10  Report a Bug
6.11  Manage Contacts
6.12  Customization
7 Advanced Application
7.1 Workflow
7.1.1  ZenTao Workflow
7.2 Personal management
7.2.1  My To-dos
7.2.2  My Task, Story and Bug
7.2.3  My Profile
7.3 Product Manager
7.3.1  Manage a Product
7.3.2  Create and Review a Story
7.3.3  Change and Review a Story
7.3.4  Story Status
7.3.5  Notes for Writing a Story
7.3.6  Product Module
7.3.7  Release Plan
7.3.8  Create a Release
7.3.9  Roadmap
7.3.10  Manage Documents
7.3.11  Product Meetings
7.3.12  Project Management, Presentation and Summary
7.3.13  Story Reports
7.4 Project Manager
7.5 Development Team
7.5.1  Project planning meeting and decompose tasks
7.5.2  Claim and update Tasks
7.5.3  Create a Build
7.5.4  Test Task
7.5.5  Resolve a Bug
7.5.6  Manage Documents
7.5.7  Confirm Bugs
7.6 Testing Team
7.6.1  Bug Management
7.6.2  Submit a Bug
7.6.3  Confim and Close a Bug
7.6.4  Activate a Bug
7.6.5  Find a Bug
7.6.6  Test Case
7.6.7  Create a Test Case
7.6.8  Manage a Test Task
7.6.9  Execute Cases and Report Bugs
7.6.10  Reports
8 Configuration
8.1 Maintain ZenTao
8.1.1  Initialize scripts
8.1.2  Back up ZenTao
8.1.3  Recover the deleted
8.1.4  Update Burndown charts
8.2 Deploy ZenTao
8.2.1  Guest Login
8.2.2  Cnfigure Email
8.2.3  Set Super Admin
8.2.4  Configure Static Access
8.2.5  Delete "zentao" from your address
8.2.6  Integrate ZenTao with SVN
8.2.7  Integrate ZenTao with Git
9 Custom Development
9.1  ZenTao Mechanism of Developing
9.2  ZenTao Directory
9.3  Modify files
9.4  ZenTao Database
9.5  Common Modules
9.6  Add features to navigation bar
9.7  Examples: Modify Language Prompt
9.8  Examples: set priority when creating bugs
9.9  Web Editor
9.10  Packaging Standards of ZenTao 1.1
10 Other Relevant Issues
10.1  About third-party code
10.2  ZenTao FAQ
10.3  How to Help ZenTao
10.4  ZenTao Business Service
10.5  Acknowledgement

ZenTao Database

2015-09-14 15:05:28
azalea
7675
Last edited by xiying guan on 2018-12-06 10:10:34
The naming of ZenTao databases is quite simple and concise. You can guess their purposes and functions by the names. You can find them in the corresponding language files.

1. Product related lists

zt_product   //product-reated information;
zt_productPlan  //product-related planning information;
zt_story  //an important table recording all the stories;
zt_release: records release information of the product. This table is also mutually associated to zt_build.

2. Project related lists

zt_project  //project lists;
zt_projectProduct  //the correlations between projects and products;
zt_proejctStory  //all the story lists in the projects;
zt_task  //task lists
zt_burn  //data lists of the Burndown chart, which is generated based on the data in the list;
zt_team  // the team members in the project;
zt_build  //records the build lists of the products in the project.

3. Test related lists

zt_bug  //bug lists
zt_case  //test case lists
zt_testTask  //test task lists
zt_testRun  //executions of test cases corresponded to test tasks;
zt_testResult  //the execution results of each test case.

4. Document library related lists

zt_docLib  //lists of the user-defined document library;
zt_doc  //all the documents.

5. Organization management related lists

zt_user  //user lists;
zt_group  //group lists;
zt_userGroup  //correlations between users and groups
zt_groupPriv  //group previleges
zt_dept //department structure lists;
zt_userQuery //user-defined query lists;
zt_userTPL //user-defined templates;
zt_todo  //to-do lists;

6. Common lists

zt_company //a root list recording the information about the current company;
zt_module  //an important list which maintains the data of modules in ZenTao;
zt_action  //action history lists, recording all the modification histories of every object;
zt_history  //the value changes before and after actions;
zt_file  //attachment lists.
Write a Comment
Comment will be posted after it is reviewed.