CREATE TABLE [dbo].[ap_nm_notify_item]
(
[nikey] [int] NOT NULL,
[nianswer] [int] NOT NULL,
[niexpire_tst] [int] NOT NULL,
[niask_txt] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[nitell_txt] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[nilkey] [int] NOT NULL,
[niekey] [int] NOT NULL,
[nisend_tst] [int] NOT NULL,
[niprogress] [int] NOT NULL,
[nireply_txt] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_ap_nm_notify_item] ON [dbo].[ap_nm_notify_item] ([nikey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ap_nm_notify_item_x1] ON [dbo].[ap_nm_notify_item] ([nilkey], [niekey]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ap_nm_notify_item] TO [apnm_admin]
GRANT INSERT ON  [dbo].[ap_nm_notify_item] TO [apnm_admin]
GRANT DELETE ON  [dbo].[ap_nm_notify_item] TO [apnm_admin]
GRANT UPDATE ON  [dbo].[ap_nm_notify_item] TO [apnm_admin]
GRANT SELECT ON  [dbo].[ap_nm_notify_item] TO [apnm_user]
GO