deviseで作られるカラムとインデックス

devise.md

environment

• rails 4.0.1
• devise 3.2.2

columns

helper	type	column	null	default	index	remarks
authenticatable	string	email	false	""	unique
^	string	encrypted_password	false	""
recoverable	string	reset_password_token			unique
^	datetime	reset_password_sent_at
rememberable	datetime	remember_created_at
trackable	integer	sign_in_count	false	0
^	datetime	current_sign_in_at
^	datetime	last_sign_in_at
^	string	current_sign_in_ip
^	string	last_sign_in_ip
confirmable	string	confirmation_token			unique
^	datetime	confirmed_at
^	datetime	confirmation_sent_at
^	string	unconfirmed_email				Only if using reconfirmable
lockable	integer	failed_attempts	false	0		Only if lock strategy is :failed_attempts
^	string	unlock_token			unique	Only if unlock strategy is :email or :both
^	datetime	locked_at