Jump to content

Database Examples/Pubs/Employees

From Wikiversity

Fields

[edit | edit source]
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