/*
 Navicat Premium Dump SQL

 Source Server         : luxerify
 Source Server Type    : SQL Server
 Source Server Version : 16004175 (16.00.4175)
 Source Host           : sql.luxerify.com:1433
 Source Catalog        : items
 Source Schema         : basecamp

 Target Server Type    : SQL Server
 Target Server Version : 16004175 (16.00.4175)
 File Encoding         : 65001

 Date: 07/08/2025 13:34:03
*/


-- ----------------------------
-- Table structure for delegation
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[basecamp].[delegation]') AND type IN ('U'))
	DROP TABLE [basecamp].[delegation]
GO

CREATE TABLE [basecamp].[delegation] (
  [ID] int  IDENTITY(1,1) NOT NULL,
  [Task] nvarchar(400) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [Doer_HR1] nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [DueDate] date  NULL,
  [Links] nvarchar(500) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [RelatedDirector] nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [ProjectID] nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [CreatedAt] datetime2(7) DEFAULT sysdatetime() NOT NULL,
  [bc_userid] varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [bc_taskid] varchar(30) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [bc_status] varchar(30) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [is_archive] bit  NULL,
  [QueueType] AS (case when [projectid]='8827500300' then 'Captured' when [projectid]='8821236584' then 'Delegated' when [projectid]='8930336664' then 'Someday' when [projectid] IS NULL OR [projectid]='' then 'Inbox'  end) PERSISTED,
  [eventid] nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [basecamp].[delegation] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Auto increment value for delegation
-- ----------------------------
DBCC CHECKIDENT ('[basecamp].[delegation]', RESEED, 184)
GO


-- ----------------------------
-- Primary Key structure for table delegation
-- ----------------------------
ALTER TABLE [basecamp].[delegation] ADD CONSTRAINT [PK__delegati__3214EC27F1FDB30E] PRIMARY KEY CLUSTERED ([ID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO