ASP. NET startkits: ASP. NET issue tracker Starter Kit-Database

Follow the twenty-four painters
Learning ASP. NET startkits

The ASP. NET issue tracker Starter Kit
Enables you to track issues (bugs) associated with software applications. It also demonstrates a host of developer
"Best practices" to follow when building ASP. NET applications.

ASP. NET issue tracker starter kit is a member of ASP. NET starter kits, which tracks the progress of project task execution.

The following table is involved:

Login table:
User table: issuetrackerusers, role table: issuetrackerroles

Store the user's uploaded file information table
Issuetracker_issueattachments

Two key content tables
Project info table: issuetracker_projects, task info table: issuetracker_issues

Tables related to the project information table (issuetracker_projects)
Project info table: issuetracker_projects

Issuetracker_projectcustomerfields: Project custom attribute table

Issuetracker_projectcustomerfieldvalues: Table of custom attribute values
Issuetracker_projectmembers: project owner table

Issuetracker_projectcategories: project category table

Issuetracker_projectstatus: project status table

Issuetracker_projectpriorities: project permission level table

Issuetracker_projectmilestones: Project Schedule

Issuetracker_issues: task table included in the project

Issuetracker_queries: Project query table

Issuetracker_queryclses: Project query statement table

Table related to task information (issuetracker_issues)
Issuetracker_relatedissues: Task relationship table

Issuetracker_issuenotifications: Task user notification table

Issuetracker_issuehistory: task history table

Issuetracker_issuecomments: task description table

The attachment is related to the installation program and the database. The database relationship is obtained by powerdesigner in reverse phase.