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