This is just for reference, I think that this is usable but it may need modification. I included Excel files which are exact copies of what is stored in the database now.
1) Have a main file where a general information of every phobos file will be kept. There will be one entry/file. FILE_LOG
2) For MC files we will have a MC-specific table with detailed MC information. The entries will be linked to table 1) MCFILES
3) For every DATA file we will have Data-specifica table. The entries will be linked to table 1) Not done yet
4) For each file there will be a record of storage locations. There could be more than one entry per file FILE_LOCATIONS
5) Various utility tables to make sure that the whole package is self-consistent (dictionaries of "legal" file types etc) MCTYPES, FILETYPES
Initially we need to do manual entry, the easiest is to fill out the Excel files and insert them into the database using some windows utilities
It is perfectly possible that each job Monte Carlo or DAQ writes automatically a record in tables 1), 2) and 3) and possibly in 4)
Once the data is entered we can then make nice displays. Not all the data needs to be displayed and the data can be proceesed (string manipulations etc etc)