[dbo].[personalias]

(local) > mdb > Tables > dbo.personalias

Properties
Columns
SQL Script
Uses
Used By

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

Columns

Name	Data Type	Max Length (Bytes)
id	int	4
personid	int	4
type	varchar(32)	32
name	varchar(32)	32
domain	varchar(32)	32
starttime	datetime	8
endtime	datetime	8
createdby	int	4

SQL Script

CREATE TABLE [dbo].[personalias]
(
[id] [int] NULL,
[personid] [int] NULL,
[type] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[domain] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[starttime] [datetime] NULL,
[endtime] [datetime] NULL,
[createdby] [int] NULL
) ON [PRIMARY]
GO

Uses

Used By

[dbo].[anomalycommentview]
[dbo].[eventview]
[dbo].[personview]