CREATE TABLE [dbo].[ncipc]
(
[ipcid] [int] NOT NULL,
[ipctype] [int] NULL,
[ipctypex] [int] NULL,
[adomid] [int] NULL,
[ipcacid] [int] NULL,
[edomid] [int] NULL,
[ipcextid] [int] NULL,
[sdomid] [int] NULL,
[ipcstype] [int] NULL,
[ipcsid] [int] NULL,
[udomid] [int] NULL,
[unitid] [int] NULL,
[ipcdate] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ncipc] ADD CONSTRAINT [XPKncipc] PRIMARY KEY CLUSTERED ([ipcid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ncipc_sk3] ON [dbo].[ncipc] ([ipcdate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ncipc_sk1] ON [dbo].[ncipc] ([ipcsid], [sdomid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ncipc_sk4] ON [dbo].[ncipc] ([ipctype], [ipctypex], [udomid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ncipc] TO [ams_group]
GRANT SELECT ON  [dbo].[ncipc] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ncipc] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ncipc] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ncipc] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ncipc] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ncipc] TO [upmuser_group]
GO