Tables [dbo].[ca_replication_status]
Properties
PropertyValue
Row Count0
Created11:07:59 AM Wednesday, March 07, 2007
Last Modified9:08:10 PM Friday, December 05, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKca_replication_status: replication_conf_uuid\domain_uuidForeign Keys $ca_re_r0000091600000000: [dbo].[ca_replication_conf].replication_conf_uuidreplication_conf_uuidbinary(16)16
No
Cluster Primary Key XPKca_replication_status: replication_conf_uuid\domain_uuiddomain_uuidbinary(16)16
No
modified_statusbinary(8)8
Yes
deleted_statusbinary(8)8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKca_replication_status: replication_conf_uuid\domain_uuidXPKca_replication_statusreplication_conf_uuid, domain_uuid
Yes
Foreign Keys Foreign Keys
NameColumns
$ca_re_r0000091600000000replication_conf_uuid->[dbo].[ca_replication_conf].[replication_conf_uuid]
Permissions
TypeActionOwning Principal
GrantDeleteca_itrm_group
GrantInsertca_itrm_group
GrantSelectca_itrm_group
GrantUpdateca_itrm_group
GrantSelectregadmin
GrantSelectupmuser_group
GrantSelectca_itrm_group_ams
SQL Script
CREATE TABLE [dbo].[ca_replication_status]
(
[replication_conf_uuid] [binary] (16) NOT NULL,
[domain_uuid] [binary] (16) NOT NULL,
[modified_status] [binary] (8) NULL,
[deleted_status] [binary] (8) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_replication_status] ADD CONSTRAINT [XPKca_replication_status] PRIMARY KEY CLUSTERED ([replication_conf_uuid], [domain_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_replication_status] ADD CONSTRAINT [$ca_re_r0000091600000000] FOREIGN KEY ([replication_conf_uuid]) REFERENCES [dbo].[ca_replication_conf] ([replication_conf_uuid])
GO
GRANT SELECT ON  [dbo].[ca_replication_status] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_replication_status] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_replication_status] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_replication_status] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_replication_status] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_replication_status] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_replication_status] TO [upmuser_group]
GO
Uses