TableA (int(10) id, varchar(50) title, varchar(20) author) key (id, title) foreign key (id) reference (blah) in TableB... and explain what your variables mean if necessary. TableB (.....) I just found this much easier to read than SQL statements :)