Database Examples/Pubs/Stores

Fields

edit
Field Name Field Type Length Index Constraint Default
store_id Integer Primary Key Not Null
stor_name Text 40 Yes Not Null
stor_address Text 40
city Text 20 Yes
state Text 2 Yes
zip Text 5 Yes

Data

edit
store_id stor_name stor_address city state zip
6380 Eric the Read Books 788 Catamaugus Ave. Seattle WA 98056
7066 Barnum's 567 Pasadena Ave. Tustin CA 92789
7067 News & Brews 577 First St. Los Gatos CA 96745
7131 Doc-U-Mat: Quality Laundry and Books 24-A Avogadro Way Remulade WA 98014
7896 Fricative Bookshop 89 Madison St. Fremont CA 90019
8042 Bookbeat 679 Carson St. Portland OR 89076