1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| USE [Enterprise]
GO
/****** Object: Table [dbo].[Instrument] Script Date: 04/30/2012 13:56:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Instrument](
[instrument_id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_Instrument_instrument_id] DEFAULT (newid()),
[instrumenttype_id] [uniqueidentifier] NOT NULL,
[instrumentmodel_id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Instrument_instrumentmodel_id] DEFAULT ('{ED4C8260-DA1B-4C43-AB25-B69812B9CF4E}'),
[identifier] [nvarchar](50) NOT NULL,
[description] [nvarchar](80) NULL,
[location_id] [uniqueidentifier] NOT NULL,
[serial_number] [nvarchar](20) NULL,
[network_address] [nvarchar](200) NOT NULL,
[socket_number] [int] NOT NULL,
[hardware_port] [nvarchar](20) NULL,
[last_calibration] [datetime] NULL,
[next_calibration_planned] [datetime] NULL,
[next_calibration_required] [datetime] NULL,
[max_tests_allowed] [int] NULL,
[max_curves] [int] NULL,
[curve_saved_color] [nvarchar](20) NULL,
[curve_gradient_color] [nvarchar](20) NULL,
[panel_layout] [nvarchar](2048) NULL,
[queue_display_fields] [nvarchar](200) NULL,
[queue_filter] [nvarchar](200) NULL,
[parameter] [nvarchar](1024) NULL,
[product_no] [int] NULL,
[in_use_host] [nvarchar](50) NULL,
[in_use_user_id] [uniqueidentifier] NULL,
[heartbeat] [datetime] NULL,
[x_date] [datetime] NOT NULL,
[x_user_id] [uniqueidentifier] NOT NULL,
[x_deleted] [bit] NOT NULL,
CONSTRAINT [PK_Instrument] PRIMARY KEY CLUSTERED
(
[instrument_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] |
Partager