BuddyPress.org

I’m working on making a plugin for WP/BP and I was looking at the code for buddy press to see how things have been implemented.

While looking at the sql query that created the initial database tables, I noticed that some of the lines say KEY. For example, KEY creator_id (creator_id).

I tried looking around to see what that did but I couldn’t find an answer. The only thing that I could conclude is that KEY is the same as FOREIGN KEY. Also if it is a FOREIGN KEY isn’t supposed to have a reference to another table?

Am close to the right answer?

Thanks for any responses.

EDIT: Accidentally clicked on the wrong forum section. Could someone move this to the appropriate section?