Database Examples/Pubs/Publishers
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
|