CREATE TABLE [dbo].[amephis]
(
[domainid] [int] NULL,
[epid] [int] NULL,
[eparea] [int] NULL,
[epevent] [int] NULL,
[hdate] [int] NULL,
[hpri] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hpritype] [int] NULL,
[hpridid] [int] NULL,
[hpriid] [int] NULL,
[hsec] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hsectype] [int] NULL,
[hsecdid] [int] NULL,
[hsecid] [int] NULL,
[hter] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[htertype] [int] NULL,
[hterdid] [int] NULL,
[hterid] [int] NULL,
[huser] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[huserdid] [int] NULL,
[huserid] [int] NULL,
[hold] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hnew] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[epvfmt] [int] NULL,
[hpriuuid] [binary] (16) NULL,
[hsecuuid] [binary] (16) NULL,
[hteruuid] [binary] (16) NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_amephis] ON [dbo].[amephis] ([huserdid], [huserid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[amephis] ADD CONSTRAINT [$ameph_r0000085a00000000] FOREIGN KEY ([epid], [domainid]) REFERENCES [dbo].[amepdef] ([epid], [domainid])
GO
GRANT SELECT ON  [dbo].[amephis] TO [ams_group]
GRANT SELECT ON  [dbo].[amephis] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[amephis] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[amephis] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[amephis] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[amephis] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[amephis] TO [upmuser_group]
GO