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