uniform_resource_participant
| Column |
Type |
PK |
Required |
Default |
| participant_id |
TEXT |
No |
No |
|
| study_id |
TEXT |
No |
No |
|
| site_id |
TEXT |
No |
No |
|
| diagnosis_icd |
TEXT |
No |
No |
|
| med_rxnorm |
TEXT |
No |
No |
|
| treatment_modality |
TEXT |
No |
No |
|
| gender |
TEXT |
No |
No |
|
| race_ethnicity |
TEXT |
No |
No |
|
| age |
TEXT |
No |
No |
|
| bmi |
TEXT |
No |
No |
|
| baseline_hba1c |
TEXT |
No |
No |
|
| diabetes_type |
TEXT |
No |
No |
|
| study_arm |
TEXT |
No |
No |
|
| tenant_id |
TEXT |
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE uniform_resource_participant(
participant_id TEXT,
study_id TEXT,
site_id TEXT,
diagnosis_icd TEXT,
med_rxnorm TEXT,
treatment_modality TEXT,
gender TEXT,
race_ethnicity TEXT,
age TEXT,
bmi TEXT,
baseline_hba1c TEXT,
diabetes_type TEXT,
study_arm TEXT,
tenant_id TEXT
)