Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Decide on semantics for keys, foreign keys, and indexes #609

Closed
ajcvickers opened this issue Sep 3, 2014 · 1 comment
Closed

Decide on semantics for keys, foreign keys, and indexes #609

ajcvickers opened this issue Sep 3, 2014 · 1 comment
Labels
closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-unknown
Milestone

Comments

@ajcvickers
Copy link
Member

Currently the model has the following first-class elements:

  • Keys, one of which can be marked as the primary key, and which are assumed to have unique values
  • Foreign keys, each of which references a key, and which can be marked as having unique values
  • Indexes, which can be marked as unique

We should decide if:

  • The use and placing of uniqueness flags is correct
  • Whether an index object is always required if an index is to be created, or whether an annotation on a key or foreign key can indicate that it also represents an index
  • Whether there is really a need to have separate elements for indexes and keys, or whether they can be combined.

Keep in mind that we explicitly wanted to have addressable items for use by Migrations so we don't have the same index naming/existence problems we had previously.

@rowanmiller rowanmiller added this to the 1.0.0-beta1 milestone Sep 5, 2014
@ajcvickers
Copy link
Member Author

Forgot I filed this. :-) Filed a new issue #700 based on outcome of design meeting discussions, so closing this one.

@ajcvickers ajcvickers added the closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. label Oct 15, 2022
@ajcvickers ajcvickers modified the milestones: 1.0.0-beta1, 1.0.0 Oct 15, 2022
@ajcvickers ajcvickers removed their assignment Sep 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-unknown
Projects
None yet
Development

No branches or pull requests

2 participants