documentation:cdm:cdm:data_model_conventions
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
documentation:cdm:cdm:data_model_conventions [2014/11/14 13:00] cgreich created |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Data Model Conventions ====== | ||
| - | The CDM is platform-independent. Data types are defined generically using ANSI SQL data types (VARCHAR, INTEGER, FLOAT, DATE, TIME, CLOB). Precision is provided only for VARCHAR. It reflects the minimal required string length and can be expanded within a CDM instantiation. The CDM does not prescribe the date and time format. Standard queries against CDM may vary for local instantiations and date/time configurations. | ||
| - | |||
| - | In most cases, the first field in each table ends in "_id", containing a record identifier that can be used as a foreign key in another table. | ||
documentation/cdm/cdm/data_model_conventions.1415970059.txt.gz ยท Last modified: 2014/11/14 13:00 by cgreich
Page Tools
