[dbo].[secure_machine]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

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

Last Modified

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

Name	Data Type	Max Length (Bytes)
id	int	4
screenname	varchar(32)	32
description	varchar(32)	32
buildingid	int	4
coord_x	float	8
coord_y	float	8
coord_z	float	8
floor	varchar(32)	32
class	varchar(32)	32
rating	int	4
ratingtime	datetime	8
starttime	datetime	8
endtime	datetime	8
createdby	int	4
lastupdated	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

int

screenname

varchar(32)

description

varchar(32)

buildingid

int

coord_x

float

coord_y

float

coord_z

float

floor

varchar(32)

class

varchar(32)

rating

int

ratingtime

datetime

starttime

datetime

endtime

datetime

createdby

int

lastupdated

datetime

SQL Script

CREATE TABLE [dbo].[secure_machine]
(
[id] [int] NULL,
[screenname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[buildingid] [int] NULL,
[coord_x] [float] NULL,
[coord_y] [float] NULL,
[coord_z] [float] NULL,
[floor] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[class] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[rating] [int] NULL,
[ratingtime] [datetime] NULL,
[starttime] [datetime] NULL,
[endtime] [datetime] NULL,
[createdby] [int] NULL,
[lastupdated] [datetime] NULL
) ON [PRIMARY]
GO