Export (0) Print
Expand All

titleauthor

SQL Server 2000
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

Show:
© 2014 Microsoft