← All tables and views
Pubs table
titleauthor
Links authors to publications and records author order and royalty percentage.
25rows
4 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
au_id | CHAR(11) | no | PK 1/2 | authors.au_id |
title_id | CHAR(6) | no | PK 2/2 | titles.title_id |
au_ord | INTEGER | yes | — | — |
royaltyper | INT | yes | — | — |
Data preview
Sample records
| au_id | title_id | au_ord | royaltyper |
|---|---|---|---|
| 172-32-1176 | PS3333 | 1 | 100 |
| 213-46-8915 | BU1032 | 2 | 40 |
| 213-46-8915 | BU2075 | 1 | 100 |
| 238-95-7766 | PC1035 | 1 | 100 |
| 267-41-2394 | BU1111 | 2 | 40 |
| 267-41-2394 | TC7777 | 2 | 30 |
| 274-80-9391 | BU7832 | 1 | 100 |
| 409-56-7008 | BU1032 | 1 | 60 |
Interactive explorer