[dbo].[ToolLogs]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:45 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity
toolLogID	int	4	1 - 1
toolID	int	4
logStart	datetime	8
logEnd	datetime	8
toolData	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

toolLogID

int

1 - 1

toolID

int

logStart

datetime

logEnd

datetime

toolData

ntext

max

	Name	Columns	Unique
	pk_toollogs	toolLogID

Name

Columns

Unique

pk_toollogs

toolLogID

Name	Columns
fk_toollogs_tool	toolID->[dbo].[Tools].[toolID]

Name

Columns

fk_toollogs_tool

toolID->[dbo].[Tools].[toolID]

SQL Script

CREATE TABLE [dbo].[ToolLogs]
(
[toolLogID] [int] NOT NULL IDENTITY(1, 1),
[toolID] [int] NOT NULL,
[logStart] [datetime] NULL,
[logEnd] [datetime] NULL,
[toolData] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToolLogs] ADD CONSTRAINT [pk_toollogs] PRIMARY KEY CLUSTERED ([toolLogID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToolLogs] ADD CONSTRAINT [fk_toollogs_tool] FOREIGN KEY ([toolID]) REFERENCES [dbo].[Tools] ([toolID])
GO