Tables [dbo].[upm_download]
Properties
PropertyValue
Row Count3167
Created11:08:11 AM Wednesday, March 07, 2007
Last Modified6:12:02 PM Monday, May 04, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
statustinyint1
Yes
when_scheduledint4
Yes
when_startedint4
Yes
when_completedint4
Yes
attemptsint4
Yes
Cluster Primary Key XPKupm_download: download_file_uuidForeign Keys $upm_d_r0000062f00000000: [dbo].[ca_download_file].download_file_uuiddownload_file_uuidbinary(16)16
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKupm_download: download_file_uuidXPKupm_downloaddownload_file_uuid
Yes
Foreign Keys Foreign Keys
NameColumns
$upm_d_r0000062f00000000download_file_uuid->[dbo].[ca_download_file].[download_file_uuid]
Permissions
TypeActionOwning Principal
GrantDeleteupmadmin_group
GrantInsertupmadmin_group
GrantDeleteupmuser_group
GrantInsertupmuser_group
GrantSelectca_itrm_group
GrantSelectupmadmin_group
GrantUpdateupmadmin_group
GrantSelectupmuser_group
GrantUpdateupmuser_group
SQL Script
CREATE TABLE [dbo].[upm_download]
(
[status] [tinyint] NULL,
[when_scheduled] [int] NULL,
[when_started] [int] NULL,
[when_completed] [int] NULL,
[attempts] [int] NULL,
[download_file_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_download] ADD CONSTRAINT [XPKupm_download] PRIMARY KEY CLUSTERED ([download_file_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_download] ADD CONSTRAINT [$upm_d_r0000062f00000000] FOREIGN KEY ([download_file_uuid]) REFERENCES [dbo].[ca_download_file] ([download_file_uuid])
GO
GRANT SELECT ON  [dbo].[upm_download] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[upm_download] TO [upmadmin_group]
GRANT INSERT ON  [dbo].[upm_download] TO [upmadmin_group]
GRANT DELETE ON  [dbo].[upm_download] TO [upmadmin_group]
GRANT UPDATE ON  [dbo].[upm_download] TO [upmadmin_group]
GRANT SELECT ON  [dbo].[upm_download] TO [upmuser_group]
GRANT INSERT ON  [dbo].[upm_download] TO [upmuser_group]
GRANT DELETE ON  [dbo].[upm_download] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[upm_download] TO [upmuser_group]
GO
Uses