Any example of a necessary nullable foreign key?

by

Imagine a table that holds the TODOs of a team. If a TODO is not yet assigned to a member of the team, its user_id is NULL. If it is not NULL it is a foreign key to the users table.

More Related Contents:

  1. Should each and every table have a primary key?
  2. Database, Table and Column Naming Conventions? [closed]
  3. In Firebase, is there a way to get the number of children of a node without loading all the node data?
  4. What are the performance improvement of Sequential Guid over standard Guid? [closed]
  5. When and why are database joins expensive?
  6. Normalization: What does “repeating groups” mean?
  7. Copying data from one SQLite database to another
  8. Difference Between Firestore Set with {merge: true} and Update
  9. Can HTML5 databases and localStorage be shared across subdomains?
  10. What is a database transaction?
  11. Calculate distance between Zip Codes… AND users.
  12. Relational table naming convention [closed]
  13. When I should use one to one relationship?
  14. What’s the difference between findAndModify and update in MongoDB?
  15. PostgreSQL: Drop PostgreSQL database through command line [closed]
  16. How SID is different from Service name in Oracle tnsnames.ora
  17. Are foreign keys really necessary in a database design?
  18. GUID vs INT IDENTITY [duplicate]
  19. Difference between a theta join, equijoin and natural join
  20. How to parse the data from Google Alerts?
  21. Database of common name aliases / nicknames of people
  22. Storing an image into an Attachment field in an Access database
  23. Best representation of an ordered list in a database?
  24. Business Logic: Database or Application Layer
  25. NULL permitted in Primary Key – why and in which DBMS?
  26. SQL LIKE operator in Cloud Firestore?
  27. Can I download an SQLite db on /sdcard and access it from my Android app?
  28. Creating test data in a database [closed]
  29. What are some best practices and “rules of thumb” for creating database indexes?
  30. Personal names in a global application: What to store [closed]

Leave a Comment