[cohesion].[cc_platform]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	42
Created	11:18:09 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:18:09 AM Friday, April 20, 2007

Last Modified

11:18:10 AM Friday, April 20, 2007

Name	Data Type	Max Length (Bytes)	Default
platform_id	int	4
platform_name	varchar(90)	90
os_type	varchar(90)	90
os_version	varchar(90)	90
processor	varchar(90)	90
device_type	smallint	2	((1))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

platform_id

int

platform_name

varchar(90)

os_type

varchar(90)

os_version

varchar(90)

processor

varchar(90)

device_type

smallint

((1))

	Name	Columns	Unique
	PK__cc_platform__7C8480AE	platform_id

Name

Columns

Unique

PK__cc_platform__7C8480AE

platform_id

SQL Script

CREATE TABLE [cohesion].[cc_platform]
(
[platform_id] [int] NOT NULL,
[platform_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[os_type] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[os_version] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[processor] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[device_type] [smallint] NULL CONSTRAINT [DF__cc_platfo__devic__7D78A4E7] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_platform] ADD CONSTRAINT [PK__cc_platform__7C8480AE] PRIMARY KEY CLUSTERED ([platform_id]) ON [PRIMARY]
GO