Windows SQL Server MSSQL创建数据表

原创

cqs_jition 2022-02-28 18:15:32 博主文章分类：数据库DATABASE ©著作权

文章标签 修改时间 ide 文章分类 SQL Server 数据库

©著作权归作者所有：来自51CTO博客作者cqs_jition的原创作品，请联系作者获取转载授权，否则将追究法律责任

CREATE TABLE [dbo].[E_CMS_Article_User_Reward](

[Id] [int] IDENTITY(1,1) NOT NULL,
[BusinessId] varchar NULL,

[RewardAmount] decimal NULL,

[RewardUserId] varchar NOT NULL,

[Status] int NOT NULL default 0,
[CreateTime] [datetime] NOT NULL,
[CreateUserId] varchar NOT NULL,

[UpdateTime] [datetime] NULL,
[UpdateUserId] varchar NULL,

constraint pk_user_reward primary key (id)
)
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务ID(帖子)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'BusinessId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'打赏用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'RewardUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'打賞金額' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'RewardAmount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态（0 未回复 1已回复）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'CreateUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改人Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'UpdateUserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_Article_User_Reward', @level2type=N'COLUMN',@level2name=N'UpdateTime'
GO