NOT NULL constraint fails when filling tables

[CBreton026]

Dear @stefanpauliuk,

I am currently recreating a local version of the IEDC database. I have no problems creating the tables. However, when I try to fill the following tables using the 'IEDC_LooukupTable_fill' files, I encounter a 'NOT NULL constraint failed':

• source_type.description, provenance.description, licenses.description (see website)
• stats_array.description (see website)
• layers.description ([see website]https://www.database.industrialecology.uni-freiburg.de/datatypes.aspx))
• units.unitcode

For units.unitcode, it is because the 'reserved' codes from the csv_files differ from those on the database website. There are also more records on the website.

I also encountered an exception in layers_data, where the 27th line of the .csv file has one too many fields (I removed a ';' to make it work).

To summarize, I have two questions:

• Was there a change to the IEDC database schema to remove the 'NOT NULL' constraint on descriptions?
• What would be the best way to have the most recent lookup tables (e.g. units, types_data)?

[stefanpauliuk]

Good evening @CBreton026,

thanks for your message! There have been changes in the meantime indeed. The best solution is probably to give you read access to the current live version of the IEDC on our server so that you can create a local dump, or to share with you the latest backup/dump that you can then recreate the db from. Will send an email on that in a minute!

Cheers, Stefan