GoldHoo/doc/调整记录/已更新正式环境/2020-11-30 14.18.sql

USE [befri_Goldhoo]
GO

/****** Object:  Table [Discount].[DiscountAcc]    Script Date: 2020/12/1 14:44:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [Discount].[DiscountAcc](
	[WarehouseId] [int] NOT NULL,
	[InventoryId] [int] NOT NULL,
	[Quantity] [numeric](9, 0) NOT NULL,
	[DiscountCoef] [numeric](5, 2) NULL,
 CONSTRAINT [PK_DISCOUNTACC] PRIMARY KEY CLUSTERED 
(
	[WarehouseId] ASC,
	[InventoryId] 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'Discount', @level1type=N'TABLE',@level1name=N'DiscountAcc', @level2type=N'COLUMN',@level2name=N'WarehouseId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'存货内码' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAcc', @level2type=N'COLUMN',@level2name=N'InventoryId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAcc', @level2type=N'COLUMN',@level2name=N'Quantity'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'折扣系数' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAcc', @level2type=N'COLUMN',@level2name=N'DiscountCoef'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'折扣管理.折扣产品账务' , @level0type=N'SCHEMA',@level0name=N'Discount', @level1type=N'TABLE',@level1name=N'DiscountAcc'
GO