Project Management: The Application (
Page 1 of 4 ) 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.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
staff
|
/ 5 
