CREATE TABLE [dbo].[{TABLE_NAME}](
	[lottery_id] [int] IDENTITY(1,1) NOT NULL,
	[lottery_name] [varchar](100) NOT NULL,
	[status] [varchar](20) NOT NULL,
	[number_min] [int] NOT NULL,
	[number_max] [int] NOT NULL,
	[numbers_required] [int] NOT NULL,
	[ticket_cost] [int] NOT NULL,
	[currency_slug] [varchar](50) NOT NULL,
	[credit_config_id] [int] NULL,
	[prize_6_pct] [decimal](5,2) NOT NULL,
	[prize_5_pct] [decimal](5,2) NOT NULL,
	[prize_4_pct] [decimal](5,2) NOT NULL,
	[jackpot_amount] [bigint] NOT NULL,
	[draw_schedule] [varchar](30) NOT NULL,
	[draw_at] [int] NULL,
	[next_draw_at] [int] NULL,
	[winning_numbers] [varchar](50) NULL,
	[created_at] [int] NOT NULL,
	[updated_at] [int] NOT NULL,
 CONSTRAINT [PK_{TABLE_NAME}] PRIMARY KEY CLUSTERED ([lottery_id] ASC)
) ON [PRIMARY]
