Tables [dbo].[request_pki]
(local) > mdb > Tables > dbo.request_pki
Properties
PropertyValue
Row Count0
Created11:08:01 AM Wednesday, March 07, 2007
Last Modified11:09:58 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKrequest_pki: requestidrequestidint4
No
Foreign Keys $reque_r00003dba00000000: [dbo].[requesttype].requesttyperequesttypeint4
Yes
requesttimedatetime8
Yes
resolutiontimedatetime8
Yes
requeststatusint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKrequest_pki: requestidXPKrequest_pkirequestid
Yes
Foreign Keys Foreign Keys
NameColumns
$reque_r00003dba00000000requesttype->[dbo].[requesttype].[requesttype]
SQL Script
CREATE TABLE [dbo].[request_pki]
(
[requestid] [int] NOT NULL,
[requesttype] [int] NULL,
[requesttime] [datetime] NULL,
[resolutiontime] [datetime] NULL,
[requeststatus] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[request_pki] ADD CONSTRAINT [XPKrequest_pki] PRIMARY KEY CLUSTERED ([requestid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[request_pki] ADD CONSTRAINT [$reque_r00003dba00000000] FOREIGN KEY ([requesttype]) REFERENCES [dbo].[requesttype] ([requesttype])
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved