[dbo].[station]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:31 AM Wednesday, March 07, 2007
Last Modified	11:09:45 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:07:31 AM Wednesday, March 07, 2007

Last Modified

11:09:45 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_station: id\type$	id	char(20)	20
$Indexes baseidx_station: id\type$	type	smallint	2
	max_prn_pages	int	4
	max_prn_time	int	4
	time_zone	smallint	2
	cci_node	varchar(64)	64
	crt_date	int	4
	crt_time	int	4
	crt_id	varchar(32)	32
	upd_date	int	4
	upd_time	int	4
	upd_id	varchar(32)	32
	descr	varchar(255)	255
	node_type	smallint	2

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes baseidx_station: id\type$

char(20)

$Indexes baseidx_station: id\type$

type

smallint

max_prn_pages

int

max_prn_time

int

time_zone

smallint

cci_node

varchar(64)

crt_date

int

crt_time

int

crt_id

varchar(32)

upd_date

int

upd_time

int

upd_id

varchar(32)

descr

varchar(255)

255

node_type

smallint

Name	Columns	Unique
baseidx_station	id, type

Name

Columns

Unique

baseidx_station

id, type

SQL Script

CREATE TABLE [dbo].[station]
(
[id] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [smallint] NULL,
[max_prn_pages] [int] NULL,
[max_prn_time] [int] NULL,
[time_zone] [smallint] NULL,
[cci_node] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[crt_date] [int] NULL,
[crt_time] [int] NULL,
[crt_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[upd_date] [int] NULL,
[upd_time] [int] NULL,
[upd_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[descr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[node_type] [smallint] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_station] ON [dbo].[station] ([id], [type]) ON [PRIMARY]
GO