Databases > pubs > Tables > stores

pubs

stores

Created: Modified:

Columns

  • stor_id
    [char](4) NOT NULL
  • stor_name
    [varchar](40) NULL
  • stor_address
    [varchar](40) NULL
  • city
    [varchar](20) NULL
  • state
    [char](2) NULL
  • zip
    [char](5) NULL

Indexes

  • UPK_storeid
    UNIQUE CLUSTERED
    stor_id

Sample Data

stor_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