Introduction
Here is a quick overview of the table structure used for projects and issues in The Bug Genie.Scoped data
Keep in mind that almost all data in The Bug Genie is scoped, by using a scope column on all tables containing scoped data. This means that if you want to import data into multiple scopes, be aware of the scope id for the scope valid for the desired hostname(s). This scope id must be used to populate the scope column when importing data into any tables.The default scope (scope id 1) can be used to import data into the default scope valid for all hostnames (default setup).
Tables
This is a list of all tables, in the following format:Table description
Table name used in database
Table overview
Projects
<table_prefix>projectsColumn name | Type | Description |
---|---|---|
name | string (200) | The name of the project |
key | string (200) | The key, used for project and issue URLs |
prefix | string (5) | An (optional) 5-character prefix for issue numbers |
deleted | boolean, default false | Whether or not the project is deleted. Deleted projects are not available |