Cases

CREATE TABLE [dbo].[Cases]

( [Asset_ID] [varchar](18) NOT NULL, [Cases_ID] [varchar](18) NOT NULL, [Asset_OwnerId] [varchar](18) NOT NULL, [CreatedById] [varchar](18) NOT NULL, [ClosedDate] [datetime] NULL, [CreatedDate] [datetime] NOT NULL, [AdditionalPhone] [varchar](255) NULL, [Description] [text] NOT NULL, [IsEscalated] [bit] NULL, [Case_ParentId] [varchar](18) NULL, [Priority] [varchar](18) NOT NULL, [Case_Status] [varchar](18) NOT NULL, [LastModifiedDate] [timestamp] NOT NULL, [Subject] [varchar](255) NOT NULL, [LastModifiedById] [varchar](18) NOT NULL)

CREATE TABLE [dbo].[Case_Comments]

( [CaseComments_ID] [varchar](18) NOT NULL, [Comments] [text] NOT NULL, [Case_ID] [varchar](18) NOT NULL, [Resolved] [bit] NULL, [Casecomments_Status] [varchar](18) NOT NULL, [CreatedById] [varchar](18) NOT NULL, [CreatedDate] [datetime] NOT NULL, [LastModifiedDate] [timestamp] NOT NULL)