vehicle_accessories_dealer.sql 574 B

1234567891011121314151617
  1. CREATE TABLE [dbo].[vehicle_accessories_dealer] (
  2. [dealer_vehicle_type] [varchar](10) NOT NULL,
  3. [dealer_vehicle_number] [int] NOT NULL,
  4. [sequence] [bigint] NOT NULL,
  5. [code] [varchar](100) NULL,
  6. [description] [varchar](100) NULL,
  7. [package_reference] [varchar](100) NULL,
  8. [optional] [smallint] NULL,
  9. [price] [numeric](9,2) NULL,
  10. [discountable] [smallint] NULL,
  11. [client_db] [varchar](20) NOT NULL
  12. ,CONSTRAINT [vehicle_accessories_dealer$0] PRIMARY KEY CLUSTERED ([dealer_vehicle_type], [dealer_vehicle_number], [sequence], [client_db])
  13. )
  14. GO