GoldHoo/doc/调整记录/2021-07-26 14.10.sql

USE [befri_Goldhoo]
GO

/****** Object:  Table [basedata].[ShopShowFunction]    Script Date: 2021/7/26 14:10:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [basedata].[ShopShowFunction](
	[ShowFunctionId] [int] NOT NULL,
	[ShowFunctionName] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](200) NULL,
 CONSTRAINT [PK_SHOPSHOWFUNCTION] PRIMARY KEY CLUSTERED 
(
	[ShowFunctionId] 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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'展示功能内码' , @level0type=N'SCHEMA',@level0name=N'basedata', @level1type=N'TABLE',@level1name=N'ShopShowFunction', @level2type=N'COLUMN',@level2name=N'ShowFunctionId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'展示功能名称' , @level0type=N'SCHEMA',@level0name=N'basedata', @level1type=N'TABLE',@level1name=N'ShopShowFunction', @level2type=N'COLUMN',@level2name=N'ShowFunctionName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'basedata', @level1type=N'TABLE',@level1name=N'ShopShowFunction', @level2type=N'COLUMN',@level2name=N'Description'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'基础数据.前台展示功能' , @level0type=N'SCHEMA',@level0name=N'basedata', @level1type=N'TABLE',@level1name=N'ShopShowFunction'
GO