Top "Composite-primary-key" questions

Composite primary key is a primary key, which consists of more than one column.

What are the pros and cons of using multi column primary keys?

I would like to see an example of: When this is appropriate When this is not appropriate Is there a …

sql primary-key composite-primary-key
SQL Primary Key - is it necessary?

I have a list of items. Most of these items will not be in stock. The item table has id, …

sql key primary-key composite-key composite-primary-key
Creating index/pk in a huge table is taking too long. I am using Oracle. How do I know if it is going well?

I have a really huge table, with ~200 million rows. It had no index/pk at all. Selects in this table …

oracle indexing primary-key composite-primary-key
How to specify a composite primary key using EFCore Code First Migrations

I'm using Asp.Net Core 2.1, Mvc, c#, EF Core with Code First and Migrations. I'm trying to build a table …

asp.net-core entity-framework-migrations composite-primary-key asp.net-core-2.1 ef-core-2.1
Laravel: How to add a composite key (2 or more columns) as the $primaryKey in the related model?

Name of the primary key column in any model in Laravel framework is id protected $primaryKey = 'id'; And I know …

php laravel composite-primary-key
Hibernate n:m extractHashCode throws NullPointerException

I get the following exception while inserting an object with hibernate. Reading from the database works like a charm. I …

mysql hibernate gethashcode composite-primary-key
EF Composite key fluent API

I am trying to map a composite key for an entity. public class Customer { public int CustomerId { get; set; } public …

c# entity-framework fluent composite-key composite-primary-key
Reference to composite primary key in Access 2007

I have looked around and found some questions similar but they were for SQL Server instead. Here is a small …

ms-access foreign-keys ms-access-2007 foreign-key-relationship composite-primary-key
Composite Primary Key equivalent in Redis

I'm new to nosql databases so forgive my sql mentality but I'm looking to store data that can be 'queried' …

redis composite-primary-key nosql
IN clause with a composite primary key in JPA criteria

I have a table named group_table in MySQL with only two columns user_group_id and group_id (both …

hibernate jpa eclipselink composite-primary-key jpa-2.1