论坛临时用户的数据模型
我创建了一个论坛，但现在发现为了创造更多流量，我需要允许匿名用户添加帖子。
这个想法是，没有帐户的用户可以撰写帖子，并填写以下字段（就像使用 stackoverflow 一样）：
[UserName][Email][Message]
数据模型看起来像这样（有点简化）：
ForumThread/ForumPost: [Id][CreatedDate][Title][Message][UserId]...
User: [Name][Email][CreatedDate][Address][City]...
现在的问题是，扩展现有数据模型以支持匿名用户的最佳方法是什么。匿名用户不需要像常规用户那样需要所有字段，例如地址等。实用的方法是创建一个描述不同类型用户的 UserType，或者我可以使用用户的一些继承，但这需要相当多的重做。
还有我忘记的第三个选择吗？
I have created a forum, but have now found out that to create more traffic I need to enable anonymous users to add posts.
The idea is that a user who doesn't have an account, can write a post, and fill out the following fields (as you can with stackoverflow):
[UserName][Email][Message]
The datamodel is looking something like this (A bit simplified):
ForumThread/ForumPost: [Id][CreatedDate][Title][Message][UserId]...
User: [Name][Email][CreatedDate][Address][City]...
The question is now, what is the best way to extend the existing datamodel to support anonymous users. Anonymous users don't need all the fields as the regular users e.g. Address etc. The pragmatic way would be to create a UserType describing the different types of users, or I could use some inheritance of a user, but this requires quite a bit of redoing.
Is there a third option I have forgotten?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
将角色属性添加到用户并具有匿名和注册角色。将与匿名用户无关的属性保留为空。虽然就我个人而言，我只会重构为子类型。
Add a Role property to the User and have Anonymous and Registered as roles. Leave the properties null that are irrelevant to anonymous users. Although personally, I would just refactor into subtypes.
在 Users 表中创建一个“匿名”用户，并在该用户的 userid 下发布匿名帖子。
Create a user in the Users table that is an "anonymous" user, and make anonymous posts under that user's userid.