Q.PROJECT
This table provides information about project schedules.
The columns are as follows:
- PROJNO
- Number of the project (must be unique)
- PRODNUM
- Number of the product
- DEPT
- Number of the department responsible for the project
- STARTD
- Date the project is to start
- ENDD
- Date the project is to end
- TIMESTAMP
- Year, month, day, and time of the report
The Q.PROJECT table includes date/time data, showing dates
and times in ISO format. This format is an arbitrary choice. The table
you see depends on the choice made by your administrator. The
Q.PROJECT table is shown in the following figure: Figure 1. The Q.PROJECT table
PROJNO PRODNUM DEPT STARTD ENDD TIMESTAMP
------ ------- ------ ---------- ---------- --------------------------
1401 10 20 1996-01-01 1998-03-31 1994-12-18-10.14.44.000001
1402 50 66 1996-01-30 1997-06-30 1994-12-18-10.15.01.999998
1403 150 51 1996-02-02 1999-05-29 1994-12-18-10.22.23.000001
1404 190 38 1997-01-04 1999-06-30 1994-12-18-10.25.43.999999
1405 160 15 1997-04-29 1999-10-30 1995-12-31-14.23.00.999999
1406 20 20 1997-07-11 1998-12-31 1996-01-05-13.31.18.009999
1407 50 42 1997-12-12 2000-06-15 1996-01-05-13.42.27.000000
1408 30 42 1999-03-13 2000-09-30 1996-01-05-13.44.16.999999
1409 10 66 1998-06-15 1999-12-31 1996-03-13-09.12.57.149572
1410 190 10 1998-09-29 2000-03-31 1996-03-13-12.18.23.402917
1501 30 51 1999-01-04 1999-12-31 1996-03-13-12.22.14.201966
1502 150 38 1999-03-01 2000-07-17 1996-03-13-13.17.48.948276