USE [期日前当日投票_STD]


/* 選挙人台帳 */
GO
CREATE NONCLUSTERED INDEX [IX_バーコード] ON [dbo].[選挙人台帳] 
(
	[バーコード] ASC
)ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [IX_氏名] ON [dbo].[選挙人台帳] 
(
	[カナ氏名] ASC,
	[生年月日] ASC,
	[性別] ASC
)ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [IX_名簿番号] ON [dbo].[選挙人台帳] 
(
	[執行日] ASC,
	[投票区コード] ASC,
	[簿冊番号] ASC,
	[頁番号] ASC,
	[行番号] ASC,
	[性別] ASC
)ON [PRIMARY]


/* 投票情報 */
GO
CREATE NONCLUSTERED INDEX [IX_不在一括] ON [dbo].[投票情報] 
(
	[名簿区分] ASC,
	[執行日] ASC,
	[選挙ID] ASC,
	[不在施設番号] ASC,
	[不在交付一括処理ID] ASC,
	[不在受理一括処理ID] ASC,
	[不在返票一括処理ID] ASC
)ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [IX_不在連番] ON [dbo].[投票情報] 
(
	[個人番号] ASC,
	[名簿区分] ASC,
	[執行日] ASC,
	[選挙ID] ASC,
	[不在交付日] ASC,
	[不在交付処理日時] ASC,
	[不在受理日] ASC,
	[不在受理処理日時] ASC
)ON [PRIMARY]


/* 外字変換マスタ */

GO
CREATE NONCLUSTERED INDEX [IX_外字] ON [dbo].[外字変換マスタ] 
(
	[外字] ASC
)ON [PRIMARY]


/* KEN_add */

GO
CREATE NONCLUSTERED INDEX [IX_郵便番号] ON [dbo].[KEN_add] 
(
	[f3] ASC
)ON [PRIMARY]


