Database Examples/Pubs/Titleauthor

< Database Examples < Pubs

Fields

Field Name Field Type Length Index Constraint Default
au_id Integer Primary Key Not Null
title_id Text 6 Yes Foreign Key
au_ord Integer
royaltyper Integer

Data

au_id title_id au_ord royaltyper
1 PS3333 1 100
2 BU1032 2 40
2 BU2075 1 100
3 PC1035 1 100
4 BU1111 2 40
4 TC7777 2 30
5 BU7832 1 100
7 BU1032 1 60
8 PC8888 1 50
9 TC7777 3 30
10 PC9999 1 100
10 PS7777 1 100
12 TC4203 1 100
13 TC7777 1 40
14 MC2222 1 100
15 MC3021 1 75
16 BU1111 1 60
16 PS1372 2 25
18 PS1372 1 75
19 TC3218 1 100
20 PC8888 2 50
22 MC3021 2 25
22 PS2091 2 50
23 PS2091 1 50
23 PS2106 1 100
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.