Databases > pubs > Tables > authors

pubs

authors

Created: Modified:

Columns

  • au_id
    [id] NOT NULL
    //
    USER-DEFINED DATA TYPE
    [varchar](11) NOT NULL
    //
    CONSTRAINT
    ([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]')
  • au_lname
    [varchar](40) NOT NULL
  • au_fname
    [varchar](20) NOT NULL
  • phone
    [char](12) NOT NULL DEFAULT ('UNKNOWN')
  • address
    [varchar](40) NULL
  • city
    [varchar](20) NULL
  • state
    [char](2) NULL
  • zip
    [char](5) NULL
    //
    CONSTRAINT
    ([zip] like '[0-9][0-9][0-9][0-9][0-9]')
  • contract
    [bit] NOT NULL

Indexes

  • UPKCL_auidind
    UNIQUE CLUSTERED
    au_id
  • aunmind
    NONCLUSTERED
    au_lname , au_fname

Sample Data

au_id
au_lname
au_fname
phone
address
city
state
zip
contract
172-32-1176
White
Johnson
408 496-7223
10932 Bigge Rd.
Menlo Park
CA
94025
true
213-46-8915
Green
Marjorie
415 986-7020
309 63rd St. #411
Oakland
CA
94618
true
238-95-7766
Carson
Cheryl
415 548-7723
589 Darwin Ln.
Berkeley
CA
94705
true
267-41-2394
O'Leary
Michael
408 286-2428
22 Cleveland Av. #14
San Jose
CA
95128
true
274-80-9391
Straight
Dean
415 834-2919
5420 College Av.
Oakland
CA
94609
true
341-22-1782
Smith
Meander
913 843-0462
10 Mississippi Dr.
Lawrence
KS
66044
NULL
409-56-7008
Bennet
Abraham
415 658-9932
6223 Bateman St.
Berkeley
CA
94705
true
427-17-2319
Dull
Ann
415 836-7128
3410 Blonde St.
Palo Alto
CA
94301
true
472-27-2349
Gringlesby
Burt
707 938-6445
PO Box 792
Covelo
CA
95428
true
486-29-1786
Locksley
Charlene
415 585-4620
18 Broadway Av.
San Francisco
CA
94130
true
527-72-3246
Greene
Morningstar
615 297-2723
22 Graybar House Rd.
Nashville
TN
37215
NULL
648-92-1872
Blotchet-Halls
Reginald
503 745-6402
55 Hillsdale Bl.
Corvallis
OR
97330
true
672-71-3249
Yokomoto
Akiko
415 935-4228
3 Silver Ct.
Walnut Creek
CA
94595
true
712-45-1867
del Castillo
Innes
615 996-8275
2286 Cram Pl. #86
Ann Arbor
MI
48105
true
722-51-5454
DeFrance
Michel
219 547-9982
3 Balding Pl.
Gary
IN
46403
true
724-08-9931
Stringer
Dirk
415 843-2991
5420 Telegraph Av.
Oakland
CA
94609
NULL
724-80-9391
MacFeather
Stearns
415 354-7128
44 Upland Hts.
Oakland
CA
94612
true
756-30-7391
Karsen
Livia
415 534-9219
5720 McAuley St.
Oakland
CA
94609
true
807-91-6654
Panteley
Sylvia
301 946-8853
1956 Arlington Pl.
Rockville
MD
20853
true
846-92-7186
Hunter
Sheryl
415 836-7128
3410 Blonde St.
Palo Alto
CA
94301
true
893-72-1158
McBadden
Heather
707 448-4982
301 Putnam
Vacaville
CA
95688
NULL
899-46-2035
Ringer
Anne
801 826-0752
67 Seventh Av.
Salt Lake City
UT
84152
true
998-72-3567
Ringer
Albert
801 826-0752
67 Seventh Av.
Salt Lake City
UT
84152
true