ZenTao ManualBook Info
1 Introduction
1.1 About ZenTao
1.2 Introduction PPT
1.3 Technical Support
1.4 Follow Us
2 How to Install ZenTao
2.1 Choose the best installation
2.2 ZenTao Cloud
2.3 One-click Installation for Windows
2.4 One-click Installation for Linux
2.5 Installation with Lampp
2.6 Source Code Installation (for all Systems)
2.7 Set up Virtualbox for ZenTao
2.8 Softaculous service
3 Upgrade ZenTao
3.1 Upgrade ZenTao
3.2 Upgrade by source code (for all systems)
3.3 Upgrade for one-click installation for Windows (xampp)
3.4 Upgrade for one-click installation package for Linux
4 Users and Groups
4.1 Organization Structure
4.2 Add a User
4.3 Batch Manage Users
4.4 Groups and Privileges
5 Simple Application
5.1 Project and Task Management
5.2 Bug Management
5.3 Product Management
5.4 Individual Task Management
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 Story Breakdown
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 Todo
7.2.2 My Task, Story and Bug
7.2.3 My Profile
7.3 For Product Owner
7.3.1 Manage a Product
7.3.2 Manage a Product Line
7.3.3 Create and Review a Story
7.3.4 Change and Review a Story
7.3.5 Story Status
7.3.6 Notes for Writing a Story
7.3.7 Product Modules
7.3.8 Release Plan
7.3.9 Create a Release
7.3.10 Roadmap
7.3.11 Manage Documents
7.3.12 Product Planning Meetings
7.3.13 Daily Scrum, Review and Retrospective Meetings
7.3.14 Story Reports
7.4 For Project Manager
7.4.1 Create a Project
7.4.2 Set up a Team
7.4.3 Confirm Stories
7.4.4 Story Breakdown
7.4.5 Daily Standup Meetings
7.4.6 Check Project Progress via Burndown Chart
7.4.7 Check Project Progress via Lists
7.4.8 Review and Retrospective Meetings
7.4.9 Basic reports on tasks
7.5 For Development Team
7.5.1 Project planning meeting and task breakdown
7.5.2 Claim tasks and update
7.5.3 Kanban and Tree Diagram
7.5.4 Create a Build
7.5.5 Test Task
7.5.6 Resolve a Bug
7.5.7 Manage Documents
7.5.8 Confirm Bugs
7.6 For QA Team
7.6.1 Bug Management
7.6.2 Report a Bug
7.6.3 Confim and Close a Bug
7.6.4 Activate a Bug
7.6.5 Locate a Bug
7.6.6 Test Cases
7.6.7 Create and Review Test Cases
7.6.8 Manage Test Tasks
7.6.9 Test Suites, Public Case Libs and Reports
7.6.10 Manage Test Tasks
7.6.11 Execute Cases and Report Bugs
7.6.12 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.1.5 ZenTao remote host
8.2 Deploy ZenTao
8.2.1 Guest Login
8.2.2 Email Notification
8.2.3 Set Super Admin
8.2.4 Configure Static Access
8.2.5 Delete "zentao" from the address
8.2.6 Integrate ZenTao with SVN
8.2.7 Integrate ZenTao with Git
8.2.8 Integrate webhook
9 Custom Development
9.1 ZenTao customization
9.2 ZenTao Directory
9.3 Locate and Change Files
9.4 ZenTao Database Structure
9.5 Common Modules
9.6 Add Features to Menu
9.7 Set Privileges to Modules
9.8 Examples: Modify Language Prompt
9.9 Examples: set priority when creating bugs
9.10 Web Editor
9.11 Packaging Standards of ZenTao 1.1
10 Other Relevant Issues
10.1 About third-party code
10.2 How to Help ZenTao
10.3 ZenTao Business Service
10.4 Acknowledgement

ZenTao Database Structure

2015-09-14 15:05:28
Last edited by Renee on 2018-01-12 14:05:32

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. Organization management 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
Comment will be posted once reviewed.