CREATE TABLE [dbo].[nm_claims_variables]
(
[nmcv_variable_id] [int] NOT NULL,
[nmcv_variable_code] [dbo].[ais_code_short] NOT NULL,
[nmcv_l1] [nvarchar] (64) COLLATE French_CI_AS NOT NULL,
[nmcv_l2] [nvarchar] (64) COLLATE French_CI_AS NULL,
[nmcv_l3] [nvarchar] (64) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[nm_claims_variables] ADD CONSTRAINT [CK_nm_claims_variables_neg_id] CHECK (([nmcv_variable_id]<(0)))
GO
ALTER TABLE [dbo].[nm_claims_variables] ADD CONSTRAINT [PK_nm_claims_variables] PRIMARY KEY CLUSTERED  ([nmcv_variable_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[nm_claims_variables] ADD CONSTRAINT [IX_nm_claims_variables] UNIQUE NONCLUSTERED  ([nmcv_variable_code]) ON [PRIMARY]
GO
