| 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 |