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.