Good morning, Trisha
Firstly, you are absolutely right that only when you enabled the ACTIVE and/or the DEFAULT files, in the database a value of 1 will be set. This is because you enabled the field. Equally, if you disable, then a value of 0 will be set. This is standard.
There can be many aliases that are active, but only one can be default. The default is the one that you will see where this is displayed in reference to the asset.
You also said that you enabled eAudit for the field, however, you did not mention that you had done the same for the object. The object plus any fields that you wish to monitor/capture through eAudit must be enabled together.

Looking at this screenshot from the object, it will tell you what underlying table will the audit values be captured. Please have a look at that table.
You also mentioned that you observed that the "PLUSTASSETALIAS table does not directly indicate the current asset alias". Yes, it does, Current alias are those marked as ACTIVE. Of those, active aliases, one can be marked as DEFAULT which as already mentioned is used where you see it in relation to the asset.


So, base answer, is to enable eAudit for the object and attribute(s), then make a change and go look at the corresponding eAudit table.