Adam Black

Here's the similar thing on postgres. ``` r library(dplyr, warn.conflicts = F) library(DatabaseConnector) cd Inserting data took 0.0251 secs test_current_query % dplyr::tibble() return(result) } # run the test 1000 times...

Woah yes very nice Chris! So my next task on this issue is to write a test that I want to run on all OHDSI databases. I'll try to get...

It's not easy to quickly tell what the change in the cost table is from 5.4 to 6.0.

Would a single claim ever be associated with more than one person? I think this would only happen in context of a birth right? My understanding is that most or...

> The problem is it would violate the so-called 2NF database normalization rule: Eliminate Redundant Data. Domain tables like `condition_occurrence` have foreign keys `person_id`, `visit_occurrence_id`, and `visit_detail_id`. Both the `visit_detail`...

So costs must have an associated event. A single event can have more than one cost record which is why costs need their own table to support the one-to-many relationship....

Is the "DOSE_ERA" SQL available on the CDM website? I don't see it here https://ohdsi.github.io/CommonDataModel/sqlScripts.html.

> the two axioms (everything that happened has a record, if there is no record it didn't happen) I think the second axiom is equivalent to the first. In logic...

Linking related issue to add era scripts to the DDL https://github.com/OHDSI/CommonDataModel/issues/551

The script can be found on one of the historical branches. https://github.com/OHDSI/CommonDataModel/blob/v5-historical/PostgreSQL/VocabImport/OMOP%20CDM%20vocabulary%20load%20-%20PostgreSQL.sql @clairblacketer is this script part of the current version of the CommonDataModel package?