Jump to content

Database Examples/Pubs/Publishers

From Wikiversity

Fields

[edit | edit source]
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