2423 (musicdb draft)

table field format
title tid int auto increment primary key
tname varchar 255
sid int foreign key
fid int foreign key
yid int foreign key
lid int foreign key
atrelation atrid int auto increment primary key
aid int foreign key
tid int foreign key
artist aid int auto increment primary key
aname varchar 255
songs sid int auto increment primary key
sname varchar 255
tid int foreign key
format fid int auto increment primary key
fname varchar 255
year yid int auto increment primary key
yearno varchar 4
label lid int auto increment primary key
lname varchar 255
alternative
atrelation
title aid int foreign key
Advertisements

About this entry