Assets

CREATE TABLE [dbo].[assets]

( [asset_ID] [varchar](18) NOT NULL, [order_ID] [varchar](18) NOT NULL, [product_ID] [varchar](18) NOT NULL, [contact_ID] [varchar](18) NOT NULL, [serial_NO] [int] NOT NULL, [asset_status] [varchar](15) NOT NULL, [comments] [varchar](255) NULL, [LastUpdated] [date] NULL, [asset_name] [varchar](255) NULL, [Description] [varchar](255) NULL)