[dbo].[secure

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

Name	Data Type	Max Length (Bytes)
id	int	4
fullname	varchar(32)	32
rating	int	4
ratingtime	datetime	8
starttime	datetime	8
endtime	datetime	8
createdby	int	4
lastupdated	datetime	8
badgeresid	int	4
firstname	varchar(32)	32
lastname	varchar(32)	32
department	varchar(32)	32
address	varchar(64)	64
phone	char(16)	16
email	char(32)	32
title	varchar(32)	32
officeno	varchar(32)	32
dateofhire	varchar(32)	32

SQL Script

CREATE TABLE [dbo].[secure_person]
(
[id] [int] NULL,
[fullname] [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,
[badgeresid] [int] NULL,
[firstname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lastname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[department] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[phone] [char] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[email] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[title] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[officeno] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dateofhire] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO