Tables [dbo].[ToolLogs]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created12:44:45 PM Thursday, October 04, 2007
Last Modified12:44:45 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key pk_toollogs: toolLogIDtoolLogIDint4
No
1 - 1
Foreign Keys fk_toollogs_tool: [dbo].[Tools].toolIDtoolIDint4
No
logStartdatetime8
Yes
logEnddatetime8
Yes
toolDatantextmax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_toollogs: toolLogIDpk_toollogstoolLogID
Yes
Foreign Keys Foreign Keys
NameColumns
fk_toollogs_tooltoolID->[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
Uses
Used By