CREATE TABLE [dbo].[STATMOD]
(
[UDOMID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[MDOMID] [int] NOT NULL,
[MOID] [int] NOT NULL,
[STATUS] [int] NULL,
[STCOUNT] [int] NULL,
[STQCOUNT] [int] NULL,
[STDATE] [int] NULL,
[STELAPSE] [int] NULL,
[STTEXT] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STREV] [int] NULL,
[STFLAG] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[STATMOD] ADD CONSTRAINT [STATMOD_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [MOID], [UDOMID], [MDOMID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [STATMOD_SK1] ON [dbo].[STATMOD] ([UNITID]) ON [PRIMARY]
GO
[dbo].[STATMOD]
