| Column_name | Data type | Nullable | Default | Check | Key/index |
|---|---|---|---|---|---|
| au_id | id | no | Composite PK, clust. 1, FK authors(au_id) 2 | ||
| title_id | tid | no | Composite PK, clust. 1, FK titles(title_id) 3 | ||
| au_ord | tinyint | yes | |||
| royaltyper | int | yes |
1 The composite, primary key, clustered index is defined on au_id and title_id.
2 This foreign key also has a nonclustered index on au_id.
3 This foreign key also has a nonclustered index on title_id.
This table shows the contents of the titleauthor table.
| 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 |
| 427-17-2319 | PC8888 | 1 | 50 |
| 472-27-2349 | TC7777 | 3 | 30 |
| 486-29-1786 | PC9999 | 1 | 100 |
| 486-29-1786 | PS7777 | 1 | 100 |
| 648-92-1872 | TC4203 | 1 | 100 |
| 672-71-3249 | TC7777 | 1 | 40 |
| 712-45-1867 | MC2222 | 1 | 100 |
| 722-51-5454 | MC3021 | 1 | 75 |
| 724-80-9391 | BU1111 | 1 | 60 |
| 724-80-9391 | PS1372 | 2 | 25 |
| 756-30-7391 | PS1372 | 1 | 75 |
| 807-91-6654 | TC3218 | 1 | 100 |
| 846-92-7186 | PC8888 | 2 | 50 |
| 899-46-2035 | MC3021 | 2 | 25 |
| 899-46-2035 | PS2091 | 2 | 50 |
| 998-72-3567 | PS2091 | 1 | 50 |
| 998-72-3567 | PS2106 | 1 | 100 |