ACF stores data for custom field related to posts in the post_meta table, just like standard wp custom fields. It stores custom fields for everything else in the options table. Every field has two database rows associated with it.