Tables [dbo].[C2ODocument]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count72
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
DocumentTypevarchar(255)255
Yes
CheckedOutByvarchar(255)255
Yes
Cluster Primary Key PK_C2ODocument_ObjectID: ObjectIDObjectIDint4
No
1 - 1
MinFailedint4
Yes
LatestVersionIDvarchar(50)50
Yes
LogicalNamevarchar(255)255
Yes
MinAgeint4
Yes
Descriptionvarchar(255)255
Yes
DateModifieddatetime8
Yes
Statevarchar(255)255
Yes
CurrentVersionIDvarchar(50)50
Yes
IsDeletedtinyint1
Yes
MinRecentint4
Yes
DateCreateddatetime8
Yes
Ownervarchar(255)255
Yes
DiscriminatorTypevarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_C2ODocument_ObjectID: ObjectIDPK_C2ODocument_ObjectIDObjectID
Yes
SQL Script
CREATE TABLE [dbo].[C2ODocument]
(
[DocumentType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CheckedOutBy] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ObjectID] [int] NOT NULL IDENTITY(1, 1),
[MinFailed] [int] NULL,
[LatestVersionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LogicalName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MinAge] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateModified] [datetime] NULL,
[State] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CurrentVersionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsDeleted] [tinyint] NULL,
[MinRecent] [int] NULL,
[DateCreated] [datetime] NULL,
[Owner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscriminatorType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[C2ODocument] ADD CONSTRAINT [PK_C2ODocument_ObjectID] PRIMARY KEY CLUSTERED ([ObjectID]) ON [PRIMARY]
GO
Uses