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

• fid - file ID

• p_id - ID of the project to which the file belongs

• filename - name of the file

 staff

 

 

• sid - staff member ID

• name - name of staff member

• p_id - ID of the project to which the staff member belongs

Next: The SQL >>
 

More PHP Articles
More By David Web

Comments On: Project Management: The Application

· a very good code to give an idea of Project management , one can easily understand...   >>> Post your comment now!