SonarQube Snapshot Table

CREATE TABLE [dbo].[snapshots](
	[id] [INT] IDENTITY(1,1) NOT NULL,
	[status] [NVARCHAR](4) NOT NULL,
	[islast] [BIT] NOT NULL,
	[version] [NVARCHAR](500) NULL,
	[purge_status] [INT] NULL,
	[period1_mode] [NVARCHAR](100) NULL,
	[period1_param] [NVARCHAR](100) NULL,
	[period2_mode] [NVARCHAR](100) NULL,
	[period2_param] [NVARCHAR](100) NULL,
	[period3_mode] [NVARCHAR](100) NULL,
	[period3_param] [NVARCHAR](100) NULL,
	[period4_mode] [NVARCHAR](100) NULL,
	[period4_param] [NVARCHAR](100) NULL,
	[period5_mode] [NVARCHAR](100) NULL,
	[period5_param] [NVARCHAR](100) NULL,
	[created_at] [BIGINT] NULL,
	[build_date] [BIGINT] NULL,
	[period1_date] [BIGINT] NULL,
	[period2_date] [BIGINT] NULL,
	[period3_date] [BIGINT] NULL,
	[period4_date] [BIGINT] NULL,
	[period5_date] [BIGINT] NULL,
	[component_uuid] [NVARCHAR](50) NOT NULL,
	[uuid] [NVARCHAR](50) NOT NULL,
 CONSTRAINT [pk_snapshots] 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]