Composite keys are very powerful tool for partitioning the data in a table. STSdb owns the ability to set a complex primary key
- In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Each attribute that makes up the compound key is a simple key in its own right.
- A composite key is also a key that consists of 2 or more attributes that uniquely identify an entity occurrence, but at least one attribute tha makes up the composite key is not a simple key in its own right.
Sections