CREATE TABLE [dbo].[tplmemo]
(
[domainid] [int] NOT NULL,
[tpid] [int] NOT NULL,
[tpver] [int] NOT NULL,
[tpcont] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[tplmemo] ADD CONSTRAINT [XPKtplmemo] PRIMARY KEY CLUSTERED ([tpid], [tpver], [domainid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tplmemo] ADD CONSTRAINT [tplmemo_fk01] FOREIGN KEY ([tpid], [domainid]) REFERENCES [dbo].[nctpldef] ([tpid], [domainid])
GO
GRANT SELECT ON  [dbo].[tplmemo] TO [ams_group]
GRANT SELECT ON  [dbo].[tplmemo] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[tplmemo] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[tplmemo] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[tplmemo] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[tplmemo] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[tplmemo] TO [upmuser_group]
GO