Skip to content

[5pt] Foreign keys #2628

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.

Sign up for GitHub

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

Jump to bottom
Closed
2 tasks
Tracked by #2606
art-dr opened this issue Jan 25, 2022 · 0 comments · Fixed by #2955
Closed
2 tasks
Tracked by #2606

[5pt] Foreign keys #2628

art-dr opened this issue Jan 25, 2022 · 0 comments · Fixed by #2955
Assignees
@p7nov
Labels
feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality

Comments

@art-dr
Copy link
Contributor

art-dr commented Jan 25, 2022 •
edited by patiencedaur
Loading

Related dev. issue(s): tarantool/tarantool#6436

Product: Tarantool
Since: 2.10.0
SME: @ alyapunov

Details

https://docs.google.com/document/d/1EtqfFSIMi6fDqj2y-9WgpunkHsszU65p6LfNly5E9Ag/

Space constraints are needed to ensure that tuples in a space satisfy the specified conditions. Normal constraints define a function that defines the correctness of a tuple. Foreign keys describe the relationship between tables by requiring an external tuple in another spacer with specific fields.

Foreign keys are set for a tuple field or for the tuple as a whole.
Foreign keys for a field work much faster, and for a tuple they allow you to make connections across multiple fields.

This issue derives from #2627

Definition of done

  • describe how foreign key is set for fields
  • describe how foreign key is set for tuples
@art-dr art-dr added feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality sql [location] SQL manual labels Jan 25, 2022
@art-dr art-dr mentioned this issue Jan 25, 2022
Closed
2 tasks
@p7nov p7nov self-assigned this Jun 16, 2022
@p7nov p7nov mentioned this issue Jun 17, 2022
Merged
@p7nov p7nov removed the sql [location] SQL manual label Jun 17, 2022
@p7nov p7nov changed the title [3pt] Foreign keys [5pt] Foreign keys Jun 21, 2022
@p7nov p7nov added 5sp and removed 3sp labels Jun 21, 2022
@patiencedaur patiencedaur added 3sp and removed 5sp labels Jun 22, 2022
p7nov added a commit that referenced this issue Jun 24, 2022
@p7nov
Merge remote-tracking branch 'origin/gh-2628-foreign-keys' into gh-2628…
d1debfc 
…-foreign-keys

# Conflicts:
#	doc/book/box/data_model.rst
p7nov added a commit that referenced this issue Jun 24, 2022
@p7nov
Merge remote-tracking branch 'origin/gh-2628-foreign-keys' into gh-2628…
35ec2cf 
…-foreign-keys
p7nov added a commit that referenced this issue Jun 24, 2022
@p7nov
Merge branch 'latest' into gh-2628-foreign-keys
1c31a7d
p7nov added a commit that referenced this issue Jun 24, 2022
@p7nov @patiencedaur
Add foreign keys docs (#2955)
dae6dc3 
Resolves #2628

Co-authored-by: Dia Patience Daur <[email protected]>
This was referenced Mar 1, 2023
Closed
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@p7nov p7nov

Labels
feature A new functionality reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add foreign keys docs tarantool/doc
3 participants
@art-dr @patiencedaur @p7nov