← All tables and views
Pubs table
employee
Employees, their job levels, hire dates, and publisher assignments.
43rows
8 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
emp_id | CHAR(10) | no | PK | — |
fname | VARCHAR(20) | no | — | — |
minit | CHAR(1) | yes | — | — |
lname | VARCHAR(30) | no | — | — |
job_id | INTEGER | no | — | jobs.job_id |
job_lvl | INTEGER | yes | — | — |
pub_id | CHAR(4) | no | — | publishers.pub_id |
hire_date | TEXT | no | — | — |
Data preview
Sample records
| emp_id | fname | minit | lname | job_id | job_lvl | pub_id |
|---|---|---|---|---|---|---|
| A-C71970F | Aria | Cruz | 10 | 87 | 1389 | |
| A-R89858F | Annette | Roulet | 6 | 152 | 9999 | |
| AMD15433F | Ann | M | Devon | 3 | 200 | 9952 |
| ARD36773F | Anabela | R | Domingues | 8 | 100 | 0877 |
| CFH28514M | Carlos | F | Hernadez | 5 | 211 | 9999 |
| CGS88322F | Carine | G | Schmitt | 13 | 64 | 1389 |
| DBT39435M | Daniel | B | Tonini | 11 | 75 | 0877 |
| DWR65030M | Diego | W | Roel | 6 | 192 | 1389 |
Interactive explorer