34,837
社区成员




CREATE TABLE [dbo].[J_Product](
[ItemID] [uniqueidentifier] NOT NULL,
[ItemCode] [varchar](100) NOT NULL,
[ItemType] [int] NOT NULL,
[Name_CN] [nvarchar](1000) NULL,
[Name_EN] [nvarchar](1000) NULL,
[UOM] [nvarchar](50) NULL,
[IsImported] [bit] NULL,
[ApplicationScope] [nvarchar](max) NULL,
[Description] [nvarchar](max) NULL,
[REF] [nvarchar](max) NULL,
[SPEC] [nvarchar](max) NULL,
[Material] [nvarchar](1000) NULL,
[KeyProductFlag] [bit] NOT NULL,
[NewProductFlag] [bit] NOT NULL,
[KitFlag] [bit] NOT NULL,
[CompanyCategory1] [nvarchar](1000) NULL,
[CompanyCategory2] [nvarchar](1000) NULL,
[J1] [nvarchar](1000) NULL,
[J2] [nvarchar](1000) NULL,
[J3] [nvarchar](1000) NULL,
[Manufacturer] [nvarchar](max) NULL,
[MinPrice] [decimal](18, 2) NULL,
[MaxPrice] [decimal](18, 2) NULL,
[AlertPrice] [decimal](18, 2) NULL,
[DivisionID] [uniqueidentifier] NULL,
[StructureAndComposition] [nvarchar](max) NULL,
[LifeDescription] [nvarchar](max) NULL,
[TradeName] [nvarchar](1000) NULL,
[OneTimeUsage] [bit] NULL,
[AgentRegAddress] [nvarchar](1000) NULL,
[AgentName] [nvarchar](1000) NULL,
[AgentTelNumber] [nvarchar](50) NULL,
[StandardCode] [nvarchar](max) NULL,
[ManufacturerAddress1] [nvarchar](1000) NULL,
[ManufacturerAddress2] [nvarchar](1000) NULL,
[RegProductName] [nvarchar](1000) NULL,
[PriceBuffer1] [decimal](18, 2) NULL,
[PriceBuffer2] [decimal](18, 2) NULL,
[Indication] [nvarchar](max) NULL,
[ManufacturerEN] [nvarchar](1000) NULL,
[MinSPEC] [nvarchar](1000) NULL,
[Contraindication] [nvarchar](max) NULL,
[Memo] [nvarchar](500) NULL,
[StorageCondition] [nvarchar](max) NULL,
[ServiceProvider] [nvarchar](max) NULL,
[OriginalCountry] [nvarchar](max) NULL,
[Brand] [nvarchar](50) NULL,
[IsEquipment] [bit] NULL,
[IsImplantation] [bit] NULL,
[IsConsumptive] [bit] NULL,
[ValuePeriod] [varchar](50) NULL,
[PackageMaterial] [nvarchar](50) NULL,
[PackageRate] [decimal](18, 2) NULL,
[Sterilization] [nvarchar](max) NULL,
[InspectionReportNumber] [nvarchar](50) NULL,
[InspectionReportDate] [date] NULL,
[DT] [datetime] NULL,
[ST] [int] NOT NULL,
[MinPricingSPEC] [nvarchar](50) NULL,
[SterilizationMethod] [nvarchar](max) NULL,
[JNJUnitRate] [decimal](18, 2) NULL,
[MinPackageRate] [decimal](18, 2) NULL,
[MinPackageName] [nvarchar](50) NULL,
[JNJOutboundPackageName] [nvarchar](50) NULL,
[JNJStandardUnitRate] [decimal](18, 2) NULL,
CONSTRAINT [PK_J_Product] PRIMARY KEY CLUSTERED
(
[ItemID] 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 OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 单品 2组件 3组套' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'ItemType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1:进口 2:国产' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'IsImported'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'适用范围' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'ApplicationScope'
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_ItemType] DEFAULT ((1)) FOR [ItemType]
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_IsImported] DEFAULT ((1)) FOR [IsImported]
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_KeyProductFlag] DEFAULT ((0)) FOR [KeyProductFlag]
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_NewProductFlag] DEFAULT ((0)) FOR [NewProductFlag]
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_KitFlag] DEFAULT ((0)) FOR [KitFlag]
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_OneTimeUsage] DEFAULT ((0)) FOR [OneTimeUsage]
GO
ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_ST] DEFAULT ((1)) FOR [ST]
GO