IF NOT EXISTS
(
    SELECT name
    FROM sysobjects
    WHERE name = 'GoodsSupportiveCompanies'
)
    CREATE TABLE [dbo].[GoodsSupportiveCompanies]
    (
        [IncrementalDeductionId] [SMALLINT] NOT NULL,
        [GoodsCode] [VARCHAR](15) NOT NULL,
        [PatientPercent] [FLOAT] NULL
            DEFAULT ((0)),
        [PatientPrice] [MONEY] NULL
            DEFAULT ((0)),
        [DifferPercent] [FLOAT] NULL
            DEFAULT ((0)),
        [DifferPrice] [MONEY] NULL
            DEFAULT ((0)),
        [Kind] [SMALLINT] NULL,
        CONSTRAINT [PK_GoodsSupportiveCompanies]
            PRIMARY KEY CLUSTERED (
                                      [IncrementalDeductionId] ASC,
                                      [GoodsCode] ASC
                                  )
    ) ON [PRIMARY];
