USE [befri_Goldhoo] GO /****** Object: Table [replenish].[ReplenishOrder] Script Date: 2021/3/27 20:58:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [replenish].[ReplenishOrder]( [ReplenishOrderId] [int] NOT NULL, [OrderNumber] [varchar](20) NOT NULL, [OrderedOn] [datetime] NOT NULL, [RequiredOn] [datetime] NULL, [ShopId] [int] NOT NULL, [CreditType] [int] NULL, [ShippingMode] [int] NOT NULL, [ReceiptedAt] [nvarchar](100) NULL, [PreparedBy] [nvarchar](50) NOT NULL, [PreparedOn] [datetime] NOT NULL, [OrderStatus] [int] NULL, [VersionNumber] [int] NOT NULL, [CreatedBy] [nvarchar](20) NOT NULL, [CreatedOn] [datetime] NOT NULL, [ModifiedBy] [nvarchar](20) NULL, [ModifiedOn] [datetime] NOT NULL, [Description] [nvarchar](200) NULL, CONSTRAINT [PK_REPLENISHORDER] PRIMARY KEY CLUSTERED ( [ReplenishOrderId] 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 ON GO ALTER TABLE [replenish].[ReplenishOrder] ADD DEFAULT (getdate()) FOR [PreparedOn] GO ALTER TABLE [replenish].[ReplenishOrder] ADD DEFAULT ((0)) FOR [VersionNumber] GO ALTER TABLE [replenish].[ReplenishOrder] ADD DEFAULT (getdate()) FOR [CreatedOn] GO ALTER TABLE [replenish].[ReplenishOrder] ADD DEFAULT (getdate()) FOR [ModifiedOn] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'������������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'ReplenishOrderId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'������������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'OrderNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'OrderedOn' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����ʱ��' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'RequiredOn' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ר��������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'ShopId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���ÿۿʽ' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'CreditType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���˷�ʽ -- ���չ������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'ShippingMode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�ջ���ַ' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'ReceiptedAt' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Ƶ���' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'PreparedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Ƶ�����--ϵͳ�Զ���䵱ǰ����' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'PreparedOn' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'����״̬' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'OrderStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼�汾' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'VersionNumber' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'CreatedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼����ʱ��' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'CreatedOn' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼����' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'ModifiedBy' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��¼��ʱ��' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'ModifiedOn' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��ע' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder', @level2type=N'COLUMN',@level2name=N'Description' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��������' , @level0type=N'SCHEMA',@level0name=N'replenish', @level1type=N'TABLE',@level1name=N'ReplenishOrder' GO