← All tables and views
Pubs table
titles
Books and other publications with catalogue details and list prices.
18rows
10 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
title_id | CHAR(6) | no | PK | — |
title | VARCHAR(80) | no | — | — |
type | CHAR(12) | no | — | — |
pub_id | CHAR(4) | yes | — | publishers.pub_id |
price | NUMERIC | yes | — | — |
advance | NUMERIC | yes | — | — |
royalty | INT | yes | — | — |
ytd_sales | INT | yes | — | — |
notes | VARCHAR(200) | yes | — | — |
pubdate | TEXT | no | — | — |
Data preview
Sample records
| title_id | title | type | pub_id | price | advance | royalty |
|---|---|---|---|---|---|---|
| BU1032 | The Busy Executive's Database Guide | business | 1389 | 19.99 | 5000 | 10 |
| BU1111 | Cooking with Computers: Surreptitious Balance Sheets | business | 1389 | 11.95 | 5000 | 10 |
| BU2075 | You Can Combat Computer Stress! | business | 0736 | 2.99 | 10125 | 24 |
| BU7832 | Straight Talk About Computers | business | 1389 | 19.99 | 5000 | 10 |
| MC2222 | Silicon Valley Gastronomic Treats | mod_cook | 0877 | 19.99 | 0 | 12 |
| MC3021 | The Gourmet Microwave | mod_cook | 0877 | 2.99 | 15000 | 24 |
| MC3026 | The Psychology of Computer Cooking | UNDECIDED | 0877 | NULL | NULL | NULL |
| PC1035 | But Is It User Friendly? | popular_comp | 1389 | 22.95 | 7000 | 16 |
Interactive explorer