< Database Examples < Pubs

Database Examples/Pubs/Titleauthor

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.