Could someone who is familiar with the phpMyAdmin interface (or MySQL in general), tell me whether or not primary keys also need to be indicated as foreign keys within the relevant table.
client_id (primary key)
upload_id (primary key)
client_id (foreign key)
In the above scenario, client_id in Table B is a of course a foreign key, as it lies in a child table that belongs to the parent table: Table A.
However, does 'client_id' in Table A, therefore also need to be indicated as a foreign key (in effect becoming both a primary and a foreign key) ?
I'm just curious, because I don't want to build the database, if afterwards it turns out I've made an error with this.
This is a bit of a silly question I guess...but it is one of those 'should be simple to answer' ones that has been bugging me.