LinkinStars commented on issue #1381: URL: https://github.com/apache/answer/issues/1381#issuecomment-3183677606
@brocaar Thanks for the question. Firstly and most fundamentally, we hate using foreign keys. Foreign key constraints are too rigid for us, and in practice they often lead to a lot of unworkability when the table structure changes. There is no doubt about the performance loss of foreign keys. Secondly, `xorm` does not support the use of foreign keys. For sure, users can set up their own if needed, but we don't take the initiative to set up foreign keys. Finally, from a business point of view, we don't believe that questions should always be deleted when the user doesn't exist. We allow for a situation that the author of a question no longer exists in the system, but his Q&A remains. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
