Database Examples/Pubs/Employees
From Wikiversity
Jump to navigation
Jump to search
| Field Name
|
Field Type
|
Length
|
Index
|
Constraint
|
Default
|
| emp_id
|
Integer
|
|
Primary Key
|
Not Null
|
|
| fname
|
Text
|
20
|
Yes
|
Not Null
|
|
| minit
|
Text
|
1
|
|
|
|
| lname
|
Text
|
30
|
Yes
|
Not Null
|
|
| job_id
|
Integer
|
|
Yes
|
Foreign Key
|
|
| job_lvl
|
Integer
|
|
|
|
|
| pub_id
|
Integer
|
|
Yes
|
Foreign Key
|
|
| hire_date
|
Date
|
|
|
Not Null
|
|
| emp_id
|
fname
|
minit
|
lname
|
job_id
|
job_lvl
|
pub_id
|
hire_date
|
| A-C71970F
|
Aria
|
|
Cruz
|
10
|
87
|
1389
|
10/26/2021
|
| AMD15433F
|
Ann
|
M
|
Devon
|
3
|
200
|
9952
|
7/16/2018
|
| A-R89858F
|
Annette
|
|
Roulet
|
6
|
152
|
9999
|
2/21/2020
|
| ARD36773F
|
Anabela
|
R
|
Domingues
|
8
|
100
|
877
|
1/27/2023
|
| CFH28514M
|
Carlos
|
F
|
Hernadez
|
5
|
211
|
9999
|
4/21/2019
|
| CGS88322F
|
Carine
|
G
|
Schmitt
|
13
|
64
|
1389
|
7/7/2022
|
| DBT39435M
|
Daniel
|
B
|
Tonini
|
11
|
75
|
877
|
1/1/2020
|
| DWR65030M
|
Diego
|
W
|
Roel
|
6
|
192
|
1389
|
12/16/2021
|
| ENL44273F
|
Elizabeth
|
N
|
Lincoln
|
14
|
35
|
877
|
7/24/2020
|
| F-C16315M
|
Francisco
|
|
Chang
|
4
|
227
|
9952
|
11/3/2018
|
| GHT50241M
|
Gary
|
H
|
Thomas
|
9
|
170
|
736
|
8/9/2018
|
| HAN90777M
|
Helvetius
|
A
|
Nagy
|
7
|
120
|
9999
|
3/19/2023
|
| HAS54740M
|
Howard
|
A
|
Snyder
|
12
|
100
|
736
|
11/19/2018
|
| H-B39728F
|
Helen
|
|
Bennett
|
12
|
35
|
877
|
9/21/2019
|
| JYL26161F
|
Janine
|
Y
|
Labrune
|
5
|
172
|
9901
|
5/26/2021
|
| KFJ64308F
|
Karin
|
F
|
Josephs
|
14
|
100
|
736
|
10/17/2022
|
| KJJ92907F
|
Karla
|
J
|
Jablonski
|
9
|
170
|
9999
|
3/11/2024
|
| LAL21447M
|
Laurence
|
A
|
Lebihan
|
5
|
175
|
636
|
6/3/2020
|
| L-B31947F
|
Lesley
|
|
Brown
|
7
|
120
|
877
|
2/3/2021
|
| MAP77183M
|
Miguel
|
A
|
Paolino
|
11
|
112
|
1389
|
12/7/2022
|
| MAS70474F
|
Margaret
|
A
|
Smith
|
9
|
78
|
1389
|
9/29/2018
|
| MFS52347M
|
Martin
|
F
|
Sommer
|
10
|
165
|
736
|
4/13/2020
|
| MGK44605M
|
Matti
|
G
|
Karttunen
|
6
|
220
|
736
|
5/1/2024
|
| MJP25939M
|
Maria
|
J
|
Pontes
|
5
|
246
|
1756
|
3/1/2019
|
| M-L67958F
|
Maria
|
|
Larsson
|
7
|
135
|
1389
|
3/27/2022
|
| MMS49649F
|
Mary
|
M
|
Saveley
|
8
|
175
|
736
|
6/29/2023
|
| M-P91209M
|
Manuel
|
|
Pereira
|
8
|
101
|
9999
|
1/9/2019
|
| M-R38834F
|
Martine
|
|
Rance
|
9
|
75
|
877
|
2/5/2022
|
| PCM98509F
|
Patricia
|
C
|
McKenna
|
11
|
150
|
9999
|
8/1/2019
|
| PDI47470M
|
Palle
|
D
|
Ibsen
|
7
|
195
|
736
|
5/9/2023
|
| PHF38899M
|
Peter
|
H
|
Franken
|
10
|
75
|
877
|
5/17/2022
|
| PMA42628M
|
Paolo
|
M
|
Accorti
|
13
|
35
|
877
|
8/27/2022
|
| POK93028M
|
Pirkko
|
O
|
Koskitalo
|
10
|
80
|
9999
|
11/29/2023
|
| PSA89086M
|
Pedro
|
S
|
Afonso
|
14
|
89
|
1389
|
12/24/2020
|
| PSP68661F
|
Paula
|
S
|
Parente
|
8
|
125
|
1389
|
1/19/2024
|
| PTC11962M
|
Philip
|
T
|
Cramer
|
2
|
215
|
9952
|
11/11/2017
|
| PXH22250M
|
Paul
|
X
|
Henriot
|
5
|
159
|
877
|
8/19/2023
|
| RBM23061F
|
Rita
|
B
|
Muller
|
5
|
198
|
1622
|
10/9/2023
|
| R-M53550M
|
Roland
|
|
Mendel
|
11
|
150
|
736
|
9/5/2021
|
| SKO22412M
|
Sven
|
K
|
Ottlieb
|
5
|
150
|
1389
|
4/5/2021
|
| TPO55093M
|
Timothy
|
P
|
O'Rourke
|
13
|
100
|
736
|
6/19/2018
|
| VPA30890F
|
Victoria
|
P
|
Ashworth
|
6
|
140
|
877
|
9/13/2020
|
| Y-L77953M
|
Yoshi
|
|
Latimer
|
12
|
32
|
1389
|
6/11/2019
|
