USE [logging2006]
GO

/****** Object:  Table [dbo].[Asset_ServiceContract]    Script Date: 10-05-2020 21:04:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Asset_ServiceContract](
	[Id] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[Number] [nvarchar](50) NULL,
	[Name] [nvarchar](128) NULL,
	[Description] [text] NULL,
	[StartDate] [bigint] NULL,
	[EndDate] [bigint] NULL,
	[Type] [nvarchar](50) NULL,
	[Status] [int] NULL,
	[CreatedBy] [nvarchar](50) NULL,
	[RenewDate] [bigint] NULL,
	[RenewedBy] [nvarchar](50) NULL,
	[VendorID] [nvarchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE [dbo].[Asset_ServiceContract] ADD  CONSTRAINT [DF_Asset_ServiceContract_Id]  DEFAULT (newid()) FOR [Id]
GO