USE [mdb]
GO

/****** Object:  Table [dbo].[act_log]    Script Date: 7/5/2022 7:30:59 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[act_log](
	[id] [int] NOT NULL,
	[persid] [nvarchar](30) NULL,
	[call_req_id] [nvarchar](30) NULL,
	[last_mod_dt] [int] NULL,
	[time_spent] [int] NULL,
	[time_stamp] [int] NULL,
	[system_time] [int] NULL,
	[analyst] [binary](16) NULL,
	[description] [ntext] NULL,
	[action_desc] [ntext] NULL,
	[type] [nvarchar](30) NULL,
	[knowledge_session] [nvarchar](80) NULL,
	[knowledge_tool] [nvarchar](12) NULL,
	[internal] [int] NULL,
	[tenant] [binary](16) NULL,
	[rel_ticket_type] [nvarchar](12) NULL,
	[zClarityLastSync] [int] NULL,
 CONSTRAINT [XPKact_log] PRIMARY KEY CLUSTERED 
(
	[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] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO