labours_master.sql 443 B

1234567891011121314
  1. CREATE TABLE [dbo].[labours_master] (
  2. [source] [varchar](50) NOT NULL,
  3. [source_number] [int] NULL,
  4. [labour_number] [varchar](50) NOT NULL,
  5. [mapping_code] [varchar](50) NOT NULL
  6. CONSTRAINT [DF__labours_m__mappi__797309D9] DEFAULT (''),
  7. [text] [varchar](255) NULL,
  8. [client_db] [varchar](20) NOT NULL
  9. ,CONSTRAINT [labours_master$0] PRIMARY KEY CLUSTERED ([source], [labour_number], [mapping_code], [client_db])
  10. )
  11. GO