chop-dbhi / data-models

Collection of various biomedical data models in parseable formats.
https://data-models-service.research.chop.edu
28 stars 8 forks source link

Data Model service not generating timestamp fields for oracle DDL #168

Closed burrowse closed 7 years ago

burrowse commented 7 years ago

The _time fields for the oracle DDL are being created as "DATE" type as opposed to timestamp. @aaron0browne @murphyke

Example below:

CREATE TABLE adt_occurrence (
    adt_date DATE, 
    adt_occurrence_id NUMBER(10) NOT NULL, 
    adt_time DATE, 
    adt_type_concept_id NUMBER(10) NOT NULL, 
    adt_type_source_value VARCHAR2(256 CHAR), 
    care_site_id NUMBER(10) NOT NULL, 
    next_adt_occurrence_id NUMBER(10), 
    person_id NUMBER(10) NOT NULL, 
    prior_adt_occurrence_id NUMBER(10), 
    service_concept_id NUMBER(10) NOT NULL, 
    service_source_value VARCHAR2(256 CHAR), 
    visit_occurrence_id NUMBER(10) NOT NULL, 
    CONSTRAINT xpk_adt_occurrence PRIMARY KEY (adt_occurrence_id)
);

Found here

gracebrownecodes commented 7 years ago

Fixed.