vehicle_accessories_customer.sql 492 B

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