Project Management: The Application

The main project management application that we will examine deals with maintaining user state (tracking users) and all major events that make the application useful, such as adding, removing, and editing projects. It will also enable users to assign tasks and add or remove project staff, as well as maintain files for a particular project.

TABLE OF CONTENTS:

By: David Web

Poor Best

Rating:

/ 5

June 02, 2008

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

The Database Tables

The application relies on four database tables and their fields:

projects

pid - sets the project ID
title - name of the project
project_description - describes the project in some detail
status - status of a project; can be 'completed,' 'pending,' or 'overdue'
create_dt - date the project was created
due_dt - date by which the project must be completed
u_id - ID of the user that created the project

tasks

tid - task id number
task_description - describes the task
complete_by - date field that takes the date on which the task should be completed
p_id - the ID of the project that requires the task

files