< Database Examples < Pubs
Database Examples/Pubs/Publishers
Fields
| Field Name | Field Type | Length | Index | Constraint | Default |
|---|---|---|---|---|---|
| pub_ID | Integer | Primary Key | Not Null | ||
| pub_Name | Text | 40 | Unique | Not Null | |
| city | Text | 25 | Yes | ||
| state | Text | 2 | Yes | ||
| country | Text | 30 | Yes |
Data
| pub_ID | pub_name | city | state | country |
|---|---|---|---|---|
| 736 | New Moon Books | Boston | MA | USA |
| 877 | Binnet & Hardley | Washington | DC | USA |
| 1389 | Algodata Infosystems | Berkeley | CA | USA |
| 1622 | Five Lakes Publishing | Chicago | IL | USA |
| 1756 | Ramona Publishers | Dallas | TX | USA |
| 9901 | GGG&G | Mnchen | Germany | |
| 9952 | Scootney Books | New York | NY | USA |
| 9999 | Lucerne Publishing | Paris | France |
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.