Database Examples/Pubs/Publishers
From Wikiversity
Jump to navigation
Jump to search
| 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
|
|
|
| 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
|
