search

NREL / disco

DISCO
BSD 3-Clause "New" or "Revised" License
10 stars 5 forks source link

Create a table for snapshot time points per job #56

Closed daniel-thom closed 2 years ago

daniel-thom commented 2 years ago

Here is output for a run with 2 jobs.

image

jgu2 commented 2 years ago

I am thinking we may still need ForeignKey in other tables to refer to timepoints in this table. name may be not unique, as time-series and snapshot jobs could have same job name, right?

daniel-thom commented 2 years ago

I am thinking we may still need ForeignKey in other tables to refer to timepoints in this table. name may be not unique, as time-series and snapshot jobs could have same job name, right?

Would that get created by the db ingestion process? I don't know what would get inserted as a column here. Also, note that time-series jobs will not produce this table.

jgu2 commented 2 years ago

I am thinking we may still need ForeignKey in other tables to refer to timepoints in this table. name may be not unique, as time-series and snapshot jobs could have same job name, right?

Would that get created by the db ingestion process? I don't know what would get inserted as a column here. Also, note that time-series jobs will not produce this table.

yy, okay, the foreign key in time-series records would be NULL then.