正文
关注被关注表设计-UserFollowMapping
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
-- ----------------------------
-- Table structure for UserFollowMapping
-- ----------------------------
DROP TABLE [dbo].[UserFollowMapping]
GO
CREATE TABLE [dbo].[UserFollowMapping] (
[UserId] bigint NOT NULL ,
[FollowUserID] bigint NOT NULL
) GO -- ----------------------------
-- Records of UserFollowMapping
-- ----------------------------
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO
INSERT INTO [dbo].[UserFollowMapping] ([UserId], [FollowUserID]) VALUES (N'', N'')
GO
GO -------------------------------------------------------
select * from dbo.UserFollowMapping -- 1 的 粉丝列表
select * from dbo.UserFollowMapping where UserId=1
-- 1 的关注列表
select * from dbo.UserFollowMapping where FollowUserID=1 -- 1 的 互粉列表 （双向的关注列表 取交集）
select UserId,FollowUserID from dbo.UserFollowMapping where UserId=1
INTERSECT
select FollowUserID,UserId from dbo.UserFollowMapping where FollowUserID=1
