PROJECT – This table is used to store the project information for the Track-IT pro database.
Ÿ ID – The unique ID for a project. (PK)
Ÿ CLIENT – The client ID for the client this project is assigned to. (FK)
Ÿ NAME – The name of the project.
Ÿ LEADER – The employee ID for the leader of the project. (FK)
Ÿ DESC – The description for the project.
Ÿ STATUS – The status of the Project “A” for active, “E” for Estimate etc.
Ÿ GROUP – The group ID for the project group this project belongs to. (FK)
Ÿ START – The start date for the project.
Ÿ END – The end date for the project.
Ÿ BILL – The billing for the project. “E” for Estimated Hours, “F” for Fixed Cost etc.
Ÿ COST – The fixed cost for a project.
Ÿ TARGET – The target for a project.
Ÿ LINK – “T” if the project is linked, “F” otherwise.
Ÿ LINKPATH – If the project is linked, this field contains the path to the MS Project file.
Ÿ ARCHIVE – “T” if the project is flagged for archive, “F” otherwise.
Ÿ OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.
Ÿ HIDE – “T” if the item is to be hidden in project lists, “F” otherwise.