[dbo].[usm_request_status]
CREATE TABLE [dbo].[usm_request_status]
(
[request_status_id] [int] NOT NULL,
[request_id] [int] NOT NULL,
[subscription_detail_id] [int] NULL,
[status] [int] NOT NULL,
[status_date] [datetime] NOT NULL,
[user_id] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status_old] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_request_status] ADD CONSTRAINT [XPKusm_request_status] PRIMARY KEY CLUSTERED ([request_status_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_request_status] ADD CONSTRAINT [XFK01usm_request_status] FOREIGN KEY ([request_id]) REFERENCES [dbo].[usm_request] ([request_id])
GO
ALTER TABLE [dbo].[usm_request_status] ADD CONSTRAINT [XFK02usm_request_status] FOREIGN KEY ([subscription_detail_id]) REFERENCES [dbo].[usm_subscription_detail] ([id])
GO
GRANT SELECT ON [dbo].[usm_request_status] TO [usmgroup]
GRANT INSERT ON [dbo].[usm_request_status] TO [usmgroup]
GRANT DELETE ON [dbo].[usm_request_status] TO [usmgroup]
GRANT UPDATE ON [dbo].[usm_request_status] TO [usmgroup]
GO
![Foreign Keys XFK01usm_request_status: [dbo].[usm_request].request_id](../../Images/fk.gif)
