Scott Rohde

So if there is more than one file in that directory, how will you know which one it is? Or will it just be assumed there is exactly one file...

Constraint ``` sql CREATE UNIQUE INDEX author_year_title ON citations (LOWER(author), year, LOWER(title)); ``` has been added to db/migrate/PROPOSED_CONSTRAINTS. All necessary cleanup for this has been done.

@dlebauer There still two pairs of duplicates because of new citations created in April: ``` sql SELECT ARRAY_AGG(id), author, year, title FROM citations GROUP BY author, year, title HAVING count(*)...

@serbinsh If you go to http://bety-dev:3000/schemas?partial=citations_table, you can see all the tables that have a `citation_id` column. (Check Show One Degree and uncheck Show Two Degree to get a simplified...

Sorry, I meant https://www.betydb.org/schemas?partial=citations_table.

Actually, though, it's only the traits table you have to worry about. We have foreign-key constaints in place for all of the other tables, so you wouldn't be able to...

Slight correction to my earlier remark: Not only do you have to worry about traits referring to the deleted citations. It is also the case that if the `citations_sites` or...

@dlebauer All constraints have already been added except for minimum year. ``` sql select * from citations where year < 1900; ``` returns ``` id | author | year |...

@echeng7 I've given you access to the Bulk Data Upload wizard. This will allow you to check the data files you are creating to make sure they are in the...

Even if you group by not only date and mgmttype but level and units as well, there are plenty of duplicates even among managements associated with a common treatment. Try...