[ci skip] Add a section to the Active Record Migration Guide on creating tables with composite primary keys #49186
Conversation
| @@ -623,6 +623,26 @@ NOTE: Active Record only supports single column foreign keys. `execute` and | |||
| `structure.sql` are required to use composite foreign keys. See | |||
| [Schema Dumping and You](#schema-dumping-and-you). | |||
|
|
|||
| ### Composite Primary Keys | |||
|
|
|||
| Sometimes a single column's value isn't enough to uniquely identify every row of a table, but a combination of two or more columns *does* uniquely identify it. This can be the case when using a legacy database schema without a single `id` column as a primary key, or when altering schemas for sharding or multitenancy. | |||
There was a problem hiding this comment.
New docs should wrap to 80 characters. I haven't been pushing for that on older docs that are updated. but any new ones should follow that convention.
There was a problem hiding this comment.
I've just re-wrapped it.
| ``` | ||
|
|
||
| INFO: Tables with composite primary keys require passing array values rather | ||
| than integer IDs to many methods. See also the [Active Record Querying][] |
There was a problem hiding this comment.
The link isn't rendering properly for me right now. I think we need to specify the URL below, ie.
[Active Record Querying]: active_record_querying.htmlThere was a problem hiding this comment.
I copied the syntax from elsewhere in the guide. But that might be too optimistic. The Active Record Associations guide is linked that way, though.
There was a problem hiding this comment.
I think that one works because it's defined below 😄
(You can tophat the guides by doing cd guides; rake guides:generate:html ONLY=active_record_migrations, and then previewing the html file it generates!)
There was a problem hiding this comment.
D'oh! Okay, I'll fix that quick.
There was a problem hiding this comment.
Should be fixed now.
|
Can you squash your commits into one? We prefer to merge single commits into Rails. |
noahgibbs
force-pushed
the
migration_guide_cpk_create
branch
from
955cfd4
to
5ee23cb
Compare
|
Squashed. |
No description provided.