Database Examples/Pubs/Employees
< Database Examples < Pubs
Fields
| 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 | |||
Data
| 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 | |