Databases > pubs > Tables > employee

pubs

employee

Created: Modified:

Columns

  • emp_id
    [empid] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [char](9) NOT NULL
    //
    CONSTRAINT
    ([emp_id] like '[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]' OR [emp_id] like '[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][FM]')
  • fname
    [varchar](20) NOT NULL
  • minit
    [char](1) NULL
  • lname
    [varchar](30) NOT NULL
  • job_id
    [smallint] NOT NULL DEFAULT ((1))
  • job_lvl
    [tinyint] NULL DEFAULT ((10))
  • pub_id
    [char](4) NOT NULL DEFAULT ('9952')
  • hire_date
    [datetime] NOT NULL DEFAULT (getdate())

Indexes

  • employee_ind
    CLUSTERED
    fname , minit , lname
  • PK_emp_id
    UNIQUE NONCLUSTERED
    emp_id

Foreign Keys

  • FK__employee__job_id__48CFD27E
    jobs
    job_id ⥱ job_id
  • FK__employee__pub_id__4BAC3F29
    publishers
    pub_id ⥱ pub_id

Sample Data

emp_id
fname
minit
lname
job_id
job_lvl
pub_id
hire_date
PMA42628M
Paolo
M
Accorti
13
35
0877
PSA89086M
Pedro
S
Afonso
14
89
1389
VPA30890F
Victoria
P
Ashworth
6
140
0877
H-B39728F
Helen
Bennett
12
35
0877
L-B31947F
Lesley
Brown
7
120
0877
F-C16315M
Francisco
Chang
4
227
9952
PTC11962M
Philip
T
Cramer
2
215
9952
A-C71970F
Aria
Cruz
10
87
1389
AMD15433F
Ann
M
Devon
3
200
9952
ARD36773F
Anabela
R
Domingues
8
100
0877
PHF38899M
Peter
H
Franken
10
75
0877
PXH22250M
Paul
X
Henriot
5
159
0877
CFH28514M
Carlos
F
Hernadez
5
211
9999
PDI47470M
Palle
D
Ibsen
7
195
0736
KJJ92907F
Karla
J
Jablonski
9
170
9999
KFJ64308F
Karin
F
Josephs
14
100
0736
MGK44605M
Matti
G
Karttunen
6
220
0736
POK93028M
Pirkko
O
Koskitalo
10
80
9999
JYL26161F
Janine
Y
Labrune
5
172
9901
M-L67958F
Maria
Larsson
7
135
1389
Y-L77953M
Yoshi
Latimer
12
32
1389
LAL21447M
Laurence
A
Lebihan
5
175
0736
ENL44273F
Elizabeth
N
Lincoln
14
35
0877
PCM98509F
Patricia
C
McKenna
11
150
9999
R-M53550M
Roland
Mendel
11
150
0736