Create DDL to support the Oncology Extension Proposal.

[mgurley]

No description provided.

[dimshitc]

Did we decide who's doing this?

[mgurley]

@dimshitc @rimusia @AEW0330
Yes, we decided that Rimma would first work on PostgreSQL and then hand off the results to Andrew/Robert to do Microsoft SQL Server. Task has been assigned to both.

[rimusia]

PostgreSQL Oncology Module DDL.txt

[rtmill]

SqlServerOncologyModuleDDL.txt

Notable differences from PostgreSQL version (above)

• Changed all [int] fields to [bigint] per CDMv6
• Created primary key for episode table
• Removed duplicate constraint statement (fk episode.person_id -> person.person_id appears twice)

[rimusia]

Robert,

Thank you for fixing the pk and duplicate fk. I must have duplicated the fk entry in place of pk.

As for the change of IDs to BIGINT, I believe that the change applies only to the patient data tables (e.g. Person, Condition_Occurrence, etc.) but not to the vocabulary tables:

https://github.com/OHDSI/CommonDataModel/blob/master/PostgreSQL/OMOP%20CDM%20postgresql%20ddl.txt
and
https://github.com/OHDSI/CommonDataModel/wiki

The updated PostgreSQL file is attached.

PostgreSQL.Oncology.Module.DDL 2019-01-29.txt

Thanks.

[mgurley]

This is done. Any problems will be brought out in the beta testing.