Animal Crossing New Horizons Catalog

name Name	award_criteria Award Criteria	n #	internal_id Internal ID	internal_name Internal Name	internal_category Internal Category	num_of_tiers Num Of Tiers	tier_1 Tier 1	tier_2 Tier 2	tier_3 Tier 3	tier_4 Tier 4	tier_5 Tier 5	reward_tier_1 Reward Tier 1	reward_tier_2 Reward Tier 2	reward_tier_3 Reward Tier 3	reward_tier_4 Reward Tier 4	reward_tier_5 Reward Tier 5	sequential Sequential	version Version	unique_entry_id Unique Entry ID
(island name) Miles!	Awarded when Nook Miles program is first unlocked	1	53	ImmigratetoIsland	Event	1	1					500	500	1000	2000	3000	Yes	1.0.0	QvQq6d4qJgCiBkMLX
Angling for Perfection!	Number of total fish caught	2		CatchFish	Fish	5	10	100	500	2000	5000	300	500	1000	2000	3000	Yes	1.0.0	wkj9WzycBpxtq6CDG
Island Ichthyologist	Number of unique fish caught	3	3	FillFishList	Fish	5	10	20	40	60	80	300	500	1000	2000	3000	Yes	1.0.0	Ajpkv8wXcZLqM8bMT
Island Togetherness	Number of days in which you've talked to every one of your villagers	4	68	GreetAllVillager	Communication	5	1	10	20	30	50	300	500	1000	2000	3000	Yes	1.0.0	syoxyxWL7ymwpKpGN
You've Got the Bug	Number of total bugs caught	5	1	CatchInsect	Insect	5	10	100	500	2000	5000	300	500	1000	2000	3000	Yes	1.0.0	weJ4f9MDdBuzLBrBM
Bugs Don't Bug Me	Number of unique bugs caught	6	4	FillInsectList	Insect	5	10	20	40	60	80	300	500	1000	2000	3000	Yes	1.0.0	ttRSm74XC4MzSHgnX
Have a Nice DIY!	Number of DIY recipes collected	7	55	FillRecipeList	DIY	5	10	50	100	150	200	300	500	1000	2000	3000	Yes	1.0.0	fsanquagmfwNCY8wW
DIY Tools	Number of tools you've crafted	8	72	DIYTool	DIY	5	5	50	200	1000	3000	300	500	1000	2000	3000	Yes	1.0.0	6k5CnRgbm55m93jMT
DIY Furniture	Number of furniture pieces you've crafted	9	73	DIYFurniture	DIY	5	5	50	200	1000	3000	300	500	1000	2000	3000	Yes	1.0.0	TprrYjwsCvZbDdcvK
Furniture Freshener	Number of times you've customized furniture at a workbench	10	14	RemakeFurniture	DIY	5	5	20	50	100	200	300	500	1000	2000	3000	Yes	1.0.0	viHJXo8XB8C3h259Q


CREATE TABLE achievements (
  "name" VARCHAR,
  "award_criteria" VARCHAR,
  "n" BIGINT,
  "internal_id" BIGINT,
  "internal_name" VARCHAR,
  "internal_category" VARCHAR,
  "num_of_tiers" BIGINT,
  "tier_1" BIGINT,
  "tier_2" BIGINT,
  "tier_3" BIGINT,
  "tier_4" BIGINT,
  "tier_5" BIGINT,
  "reward_tier_1" BIGINT,
  "reward_tier_2" BIGINT,
  "reward_tier_3" BIGINT,
  "reward_tier_4" BIGINT,
  "reward_tier_5" BIGINT,
  "reward_tier_6" BIGINT,
  "sequential" VARCHAR,
  "version" VARCHAR,
  "unique_entry_id" VARCHAR
);