On May 24, 2019, at 11:43 AM, Bruce Johnson <xxxxxx@Pharmacy.Arizona.EDU> wrote:

FS_ tables are the T4 version, named ‘First Survey’ as it is circa year M0 of the 3I.  All the other tables are based on the M1100 data from the Genie files. TL_DIFFS has TL data for each world from both sets. Numworlds, I THINK, are just the UWP’s for each system in the sectors, I don’t remember what I made that table for :-/

I have a view that breaks out the UWP individually for the FS_ data I believe it’s in there.

It’s been a long time since I looked at these files…I have them loaded into our Oracle DB at work where they’re my ‘testing things’ schema. 

I have a much newer version of DBVisualizer now that should make proper SQL dumps with inserts instead of having to massage the data. I’ll strip out the oracle-specific syntax in the DDL and post it where the other one is.  That’ll make it a lot easier to load up!