Tables [cohesion].[cc_proxy]
(local) > cohesion > Tables > cohesion.cc_proxy
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:18:09 AM Friday, April 20, 2007
Last Modified11:18:09 AM Friday, April 20, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__cc_proxy__07F6335A: proxy_idproxy_idint4
No
Foreign Keys FK__cc_proxy__host_i__08EA5793: [cohesion].[cc_host].host_idhost_idint4
Yes
proxy_portint4
No
proxy_typesmallint2
Yes
accountvarchar(90)90
Yes
passwordvarchar(90)90
Yes
certificatetextmax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cc_proxy__07F6335A: proxy_idPK__cc_proxy__07F6335Aproxy_id
Yes
Foreign Keys Foreign Keys
NameColumns
FK__cc_proxy__host_i__08EA5793host_id->[cohesion].[cc_host].[host_id]
SQL Script
CREATE TABLE [cohesion].[cc_proxy]
(
[proxy_id] [int] NOT NULL,
[host_id] [int] NULL,
[proxy_port] [int] NOT NULL,
[proxy_type] [smallint] NULL,
[account] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[password] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[certificate] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_proxy] ADD CONSTRAINT [PK__cc_proxy__07F6335A] PRIMARY KEY CLUSTERED ([proxy_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_proxy] ADD CONSTRAINT [FK__cc_proxy__host_i__08EA5793] FOREIGN KEY ([host_id]) REFERENCES [cohesion].[cc_host] ([host_id])
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved