< Database Examples < Pubs
Database Examples/Pubs/Authors
Fields
| 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 |
Data
| 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 |
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.