基于.Net Core3.1 与signalR实现一个即时通讯工具(二)——数据库设计

基于.Net Core3.1 与signalR实现一个即时通讯工具(二)——数据库设计

源码下载地址

  • 本次一共用到三张表
    请输入图片描述

Base_HistoryMeeting 会话表

USE [SRFIM20200806]
GO

/****** Object:  Table [dbo].[Base_HistoryMeeting]    Script Date: 2021/5/21 14:40:15 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Base_HistoryMeeting](
    [HistoryId] [VARCHAR](50) NOT NULL,
    [UserId] [VARCHAR](50) NULL,
    [HistoryDate] [DATETIME] NULL,
    [MeetingOwn] [VARCHAR](50) NULL,
    [UserCID] [VARCHAR](50) NULL,
    [OwnCID] [VARCHAR](50) NULL,
 CONSTRAINT [PK_Base_HistoryMeeting] PRIMARY KEY CLUSTERED 
(
    [HistoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Base_Msg 历史消息

USE [SRFIM20200806]
GO

/****** Object:  Table [dbo].[Base_Msg]    Script Date: 2021/5/21 14:40:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Base_Msg](
    [MsgId] [VARCHAR](50) NOT NULL,
    [MsgContent] [VARCHAR](500) NULL,
    [MsgSendDate] [DATETIME] NULL,
    [MsgStatus] [INT] NULL,
    [FromUser] [VARCHAR](50) NULL,
    [ToUser] [VARCHAR](50) NULL,
    [UserCID] [VARCHAR](50) NULL,
    [OwnCID] [VARCHAR](50) NULL,
 CONSTRAINT [PK_Base_Msg] PRIMARY KEY CLUSTERED 
(
    [MsgId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Base_User 用户表

USE [SRFIM20200806]
GO

/****** Object:  Table [dbo].[Base_User]    Script Date: 2021/5/21 14:40:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Base_User](
    [UserId] [VARCHAR](50) NOT NULL,
    [LoginName] [VARCHAR](50) NULL,
    [Password] [VARCHAR](50) NULL,
    [Enable] [INT] NULL,
    [UserName] [VARCHAR](50) NULL,
    [ConnectId] [VARCHAR](50) NULL,
    [LoginDate] [VARCHAR](50) NULL,
    [IsOnline] [INT] NULL,
    [LoginStatus] [INT] NULL,
    [UserHeadpic] [VARCHAR](500) NULL,
 CONSTRAINT [PK_Base_User] PRIMARY KEY CLUSTERED 
(
    [UserId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


本文来自投稿,不代表本站立场,如若转载,请注明出处:https://www.zfjsec.com/690.html
-- 展开阅读全文 --
基于.Net Core3.1 与signalR实现一个即时通讯工具(一)
« 上一篇 05-21
基于.Net Core3.1 与signalR实现一个即时通讯工具(三)——项目创建
下一篇 » 05-21

发表评论