CREATE TABLE [dbo].[usm_queue_item_detail]
(
[queue_item_detail_id] [int] NOT NULL,
[queue_item_id] [int] NOT NULL,
[created_time] [datetime] NOT NULL CONSTRAINT [DF__usm_queue__creat__7B1204DF] DEFAULT ('today'),
[status] [int] NOT NULL,
[status_time] [datetime] NULL,
[guinode_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[label] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[details1] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[details2] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[details3] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[details4] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[details5] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_queue_item_detail] ADD CONSTRAINT [XPKusm_queue_item_detail] PRIMARY KEY CLUSTERED ([queue_item_detail_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_queue_item_detail_idx_01] ON [dbo].[usm_queue_item_detail] ([queue_item_id], [created_time]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_queue_item_detail] ADD CONSTRAINT [$usm_q_r0000285b00000000] FOREIGN KEY ([queue_item_id], [created_time]) REFERENCES [dbo].[usm_queue_item] ([queue_item_id], [created_time])
GO
ALTER TABLE [dbo].[usm_queue_item_detail] ADD CONSTRAINT [$usm_q_r00002e0f00000000] FOREIGN KEY ([queue_item_id], [created_time]) REFERENCES [dbo].[usm_queue_item] ([queue_item_id], [created_time])
GO
GRANT SELECT ON  [dbo].[usm_queue_item_detail] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_queue_item_detail] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_queue_item_detail] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_queue_item_detail] TO [usmgroup]
GO