5DThinking_通用框架学习【一】

数据库设计Base_UserInfo（基本用户信息）

该表可以通过SQL语句来进行新建（代码如下：）
拓展：SQL Server如何导出建表语句

USE [Sam_DB]
GO
/****** Object:  Table [dbo].[Base_UserInfo]    Script Date: 2021/5/24 12:55:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Base_UserInfo](
    [User_ID] [varchar](50) NOT NULL CONSTRAINT [DF_Base_UserInfo_User_ID]  DEFAULT (newid()),
    [User_Code] [varchar](50) NULL,
    [User_Account] [varchar](50) NULL,
    [User_Pwd] [varchar](50) NULL,
    [User_Name] [varchar](50) NULL,
    [User_Sex] [varchar](10) NULL,
    [Title] [varchar](50) NULL,
    [Email] [varchar](20) NULL,
    [Theme] [varchar](50) NULL,
    [DeleteMark] [int] NULL CONSTRAINT [DF_Base_UserInfo_DeleteMark]  DEFAULT ((1)),
    [CreateDate] [date] NULL CONSTRAINT [DF_Base_UserInfo_CreateDate]  DEFAULT (getdate()),
    [CreateUserId] [varchar](50) NULL,
    [CreateUserName] [varchar](50) NULL,
    [ModifyDate] [date] NULL,
    [ModifyUserId] [varchar](50) NULL,
    [ModifyUserName] [varchar](50) NULL,
    [User_Remark] [varchar](max) NULL,
 CONSTRAINT [PK_BASE_USERINFO] PRIMARY KEY NONCLUSTERED 
(
    [User_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

我是SQL文件：
Add_Base_Userinfo.sql