PRIMARY KEY isn't restricted to a single column, it can be composite, usually based on two or more foreign key columns. The composite can have its own index.
Hello! I'm a technical content writer at Educative who, unsurprisingly, loves documentation. I'm always learning, so if you see any errors in my posts, let me know!
PRIMARY KEY isn't restricted to a single column, it can be composite, usually based on two or more foreign key columns. The composite can have its own index.
Thanks for catching that for me! I went ahead and updated the post.