Tabelle: PROJECT (Tabellenbeschreibung) |
---|
Spaltenname
|
Datentyp
|
Länge
|
Genauigkeit
|
Kommastellen
|
Nullable
|
---|---|---|---|---|---|
PROJNO
|
CHARACTER
|
6
|
-
|
-
|
Not Null
|
PROJNAME
|
VARCHAR
|
24
|
-
|
-
|
Not Null
|
DEPTNO
|
CHARACTER
|
3
|
-
|
-
|
Not Null
|
RESPEMP
|
CHARACTER
|
6
|
-
|
-
|
Not Null
|
PRSTAFF
|
DECIMAL
|
5
|
5
|
2
|
Null
|
PRSTDATE
|
DATE
|
-
|
-
|
-
|
Null
|
PRENDATE
|
DATE
|
-
|
-
|
-
|
Null
|
MAJPROJ
|
CHARACTER
|
6
|
-
|
-
|
Null
|
Tabelle: PROJECT (Dateninhalte) |
---|
PROJNO | PROJNAME | DEPTNO | RESPEMP | PRSTAFF | PRSTDATE | PRENDATE | MAJPROJ |
AD3100 | ADMIN SERVICES | D01 | 000010 | 6.50 | 1982-01-01 | 1983-02-01 | |
AD3110 | GENERAL ADMIN SYSTEMS | D21 | 000070 | 6.00 | 1982-01-01 | 1983-02-01 | AD3100 |
AD3111 | PAYROLL PROGRAMMING | D21 | 000230 | 2.00 | 1982-01-01 | 1983-02-01 | AD3110 |
AD3112 | PERSONNEL PROGRAMMING | D21 | 000250 | 1.00 | 1982-01-01 | 1983-02-01 | AD3110 |
AD3113 | ACCOUNT PROGRAMMING | D21 | 000270 | 2.00 | 1982-01-01 | 1983-02-01 | AD3110 |
IF1000 | QUERY SERVICES | C01 | 000030 | 2.00 | 1982-01-01 | 1983-02-01 | |
IF2000 | USER EDUCATION | C01 | 000030 | 1.00 | 1982-01-01 | 1983-02-01 | |
MA2100 | WELD LINE AUTOMATION | D01 | 000010 | 12.00 | 1982-01-01 | 1983-02-01 | |
MA2110 | W L PROGRAMMING | D11 | 000060 | 9.00 | 1982-01-01 | 1983-02-01 | MA2100 |
MA2111 | W L PROGRAM DESIGN | D11 | 000220 | 2.00 | 1982-01-01 | 1982-12-01 | MA2110 |
MA2112 | W L ROBOT DESIGN | D11 | 000150 | 3.00 | 1982-01-01 | 1982-12-01 | MA2110 |
MA2113 | W L PROD CONT PROGS | D11 | 000160 | 3.00 | 1982-02-15 | 1982-12-01 | MA2110 |
OP1000 | OPERATION SUPPORT | E01 | 000050 | 6.00 | 1982-01-01 | 1983-02-01 | |
OP1010 | OPERATION | E11 | 000090 | 5.00 | 1982-01-01 | 1983-02-01 | OP1000 |
OP2000 | GEN SYSTEMS SERVICES | E01 | 000050 | 5.00 | 1982-01-01 | 1983-02-01 | |
OP2010 | SYSTEMS SUPPORT | E21 | 000100 | 4.00 | 1982-01-01 | 1983-02-01 | OP2000 |
OP2011 | SCP SYSTEMS SUPPORT | E21 | 000320 | 1.00 | 1982-01-01 | 1983-02-01 | OP2010 |
OP2012 | APPLICATIONS SUPPORT | E21 | 000330 | 1.00 | 1982-01-01 | 1983-02-01 | OP2010 |
OP2013 | DB/DC SUPPORT | E21 | 000340 | 1.00 | 1982-01-01 | 1983-02-01 | OP2010 |
PL2100 | WELD LINE PLANNING | B01 | 000020 | 1.00 | 1982-01-01 | 1982-09-15 | MA2100 |
Tabelle: STAFF (Tabellenbeschreibung) |
---|
Spaltenname
|
Datentyp
|
Länge
|
Genauigkeit
|
Kommastellen
|
Nullable
|
---|---|---|---|---|---|
ID
|
SMALLINT
|
-
|
-
|
-
|
Not Null
|
NAME
|
VARCHAR
|
9
|
-
|
-
|
Null
|
DEPT
|
SMALLINT
|
-
|
-
|
-
|
Null
|
JOB
|
CHARACTER
|
5
|
-
|
-
|
Null
|
YEARS
|
SMALLINT
|
-
|
-
|
-
|
Null
|
SALARY
|
DECIMAL
|
7
|
7
|
2
|
Null
|
COMM
|
DECIMAL
|
7
|
7
|
2
|
Null
|
Tabelle: STAFF (Dateninhalte) |
---|
ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
10 | Sanders | 20 | Mgr | 7 | 18357.50 | |
20 | Pernal | 20 | Sales | 8 | 18171.25 | 612.45 |
30 | Marenghi | 38 | Mgr | 5 | 17506.75 | |
40 | O'Brien | 38 | Sales | 6 | 18006.00 | 846.55 |
50 | Hanes | 15 | Mgr | 10 | 20659.80 | |
60 | Quigley | 38 | Sales | 16808.30 | 650.25 | |
70 | Rothman | 15 | Sales | 7 | 16502.83 | 1152.00 |
80 | James | 20 | Clerk | 13504.60 | 128.20 | |
90 | Koonitz | 42 | Sales | 6 | 18001.75 | 1386.70 |
100 | Plotz | 42 | Mgr | 7 | 18352.80 | |
110 | Ngan | 15 | Clerk | 5 | 12508.20 | 206.60 |
120 | Naughton | 38 | Clerk | 12954.75 | 180.00 | |
130 | Yamaguchi | 42 | Clerk | 6 | 10505.90 | 75.60 |
140 | Fraye | 51 | Mgr | 6 | 21150.00 | |
150 | Williams | 51 | Sales | 6 | 19456.50 | 637.65 |
160 | Molinare | 10 | Mgr | 7 | 22959.20 | |
170 | Kermisch | 15 | Clerk | 4 | 12258.50 | 110.10 |
180 | Abrahams | 38 | Clerk | 3 | 12009.75 | 236.50 |
190 | Sneider | 20 | Clerk | 8 | 14252.75 | 126.50 |
200 | Scoutten | 42 | Clerk | 11508.60 | 84.20 | |
210 | Lu | 10 | Mgr | 10 | 20010.00 | |
220 | Smith | 51 | Sales | 7 | 17654.50 | 992.80 |
230 | Lundquist | 51 | Clerk | 3 | 13369.80 | 189.65 |
240 | Daniels | 10 | Mgr | 5 | 19260.25 | |
250 | Wheeler | 51 | Clerk | 6 | 14460.00 | 513.30 |
260 | Jones | 10 | Mgr | 12 | 21234.00 | |
270 | Lea | 66 | Mgr | 9 | 18555.50 | |
280 | Wilson | 66 | Sales | 9 | 18674.50 | 811.50 |
290 | Quill | 84 | Mgr | 10 | 19818.00 | |
300 | Davis | 84 | Sales | 5 | 15454.50 | 806.10 |
310 | Graham | 66 | Sales | 13 | 21000.00 | 200.30 |
320 | Gonzales | 66 | Sales | 4 | 16858.20 | 844.00 |
330 | Burke | 66 | Clerk | 1 | 10988.00 | 55.50 |
340 | Edwards | 84 | Sales | 7 | 17844.00 | 1285.00 |
350 | Gafney | 84 | Clerk | 5 | 13030.50 | 188.00 |