search

tristan-sebens / metl

An R package developed by and for the AFSC MESA group for extracting and standardizing data from telemetry tags.
GNU General Public License v3.0
0 stars 0 forks source link

move Tag_Type to first column in TAG_DATA_INSTANT #111

Closed kechave closed 1 month ago

kechave commented 2 months ago

Move TAG_TYPE to first column in table TAG_DATA_INSTANT...tables should always open to the Tag Type and Tag Number seen clearly.

kechave commented 2 months ago

Same for TAG_DATA_SUMMARY

tristan-sebens commented 1 month ago

Table columns rearranged so that TAG_TYPE, then TAG_NUM are always first two columns. Also rearranged timestamp fields to be more orderly.

tristan-sebens commented 1 month ago

Turns out I only temporarily reordered the columns.

Research tells me that the only way to permanently reorder the columns is to recreate the table.

tristan-sebens commented 1 month ago

Like issue #114, this will need to be done concurrently with the release of the 0.4 update, so as to minimize disruption.

tristan-sebens commented 1 month ago

I now realize that, because of the network of constraints which bind these tables together, in order to perform this change I would have to drop ALL of the tables, then recreate them one by one.

While this is technically possible, I feel at this time that the risk of breaking the DB system is too great to justify the benefit of reorganizing the DB columns.