Comments (5)
Regarding this, I just posted an example of a possible JSON format to PEDSnet/pedsnetcdms#9:
Some comments about that sample:
- I assumed the possibility of multi-column unique constraints and multi-column indexes, should those be in the offing.
- Right now fks are duped in references.csv and
definitions
-- is that intentional, or a refactoring-in-progress? - Foreign key constraints are treated specially with their own top-level references.csv, but somehow I expect them under
constraints/
.
from data-models.
Right now, multi-column variants are represented using multiple lines with the name as the grouper. Of course this requires name to be provided.
ref_table
and ref_field
in the definition files are not the same thing as foreign keys. Obviously there is a large overlap, but I kept them because of this edge case.. a subject_id
could reference records in multiple tables, but there is not foreign key constraint applied.
We can move the references.csv
under constraints. I kept them separate simply because the file structure is different. That being said, the code that produces the various views relies on the file structure to determine the contents, not the directory structure.
from data-models.
Sounds good. What do you feel about the JSON sample in PEDSnet/pedsnetcdms#9 as an implicit spec? I created that based on changes that Aaron suggested to the original JSON format that he created for pedsnetcdms.
from data-models.
Sure, that looks straightforward.
from data-models.
Implemented in 71e206d
from data-models.
Related Issues (20)
- Organize files by table
- Downstream packages to start requiring type-specific attributes
- Issues in creating pcornet schema from automated ddl HOT 3
- OHDSI added new column in drug_strength, denominator value HOT 3
- Separate OMOP Vocabulary data model? HOT 2
- Updates to PCORnet v3 field lengths
- Maybe create additional indexes for pedsnet, pcornet
- Allow two PEDSnet vocabulary columns to be NULL
- Missing concept_id constraints from PEDSnet v2.2/v2.3 HOT 1
- Re-add pedsnet foreign key indexes
- OHDSI added box_size to the drug_strength table HOT 5
- Final tweak to pedsnet 2.4.0 era table additions HOT 3
- Add PCORNET v3.1 model
- Add version 5.1 of OMOP
- Add version 2.5 of PEDSnet
- CI configuration HOT 3
- Fix omop 5.0.0 HOT 2
- Possible Changes for Data Models Generator HOT 1
- Data Model service not generating timestamp fields for oracle DDL HOT 1
- Table: hash_token | data type: varchar(18) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from data-models.