Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| analysis_id | Unknown | 0 | null |
|
|
Foreign key referencing the cm_analysis table. |
||
| comparator_id | Unknown | 0 | null |
|
|
The identifier for the comparator cohort. |
||
| comparator_max_date | Unknown | 0 | null |
|
|
The last start date of the comparator cohort observed in the data (after applying all restrictions). |
||
| comparator_max_days | Unknown | 0 | null |
|
|
The maximum number of observation days for a person in the comparator group. |
||
| comparator_median_days | Unknown | 0 | null |
|
|
The median number of observation days for a person in the comparator group. |
||
| comparator_min_date | Unknown | 0 | null |
|
|
The first start date of the comparator cohort observed in the data (after applying all restrictions). |
||
| comparator_min_days | Unknown | 0 | null |
|
|
The minimum number of observation days for a person in the comparator group. |
||
| comparator_p_10_days | Unknown | 0 | null |
|
|
The 10^th^ percentile of number of observation days for a person in the comparator group. |
||
| comparator_p_25_days | Unknown | 0 | null |
|
|
The 25^th^ percentile of number of observation days for a person in the comparator group. |
||
| comparator_p_75_days | Unknown | 0 | null |
|
|
The 75^th^ percentile of number of observation days for a person in the comparator group. |
||
| comparator_p_90_days | Unknown | 0 | null |
|
|
The 90^th^ percentile of number of observation days for a person in the comparator group. |
||
| database_id | Unknown | 0 | null |
|
|
Foreign key referencing the database. |
||
| outcome_id | Unknown | 0 | null |
|
|
The identifier for the outcome cohort. |
||
| target_id | Unknown | 0 | null |
|
|
The identifier for the target cohort. |
||
| target_max_date | Unknown | 0 | null |
|
|
The last start date of the target cohort observed in the data (after applying all restrictions). |
||
| target_max_days | Unknown | 0 | null |
|
|
The maximum number of observation days for a person in the target group. |
||
| target_median_days | Unknown | 0 | null |
|
|
The median number of observation days for a person in the target group. |
||
| target_min_date | Unknown | 0 | null |
|
|
The first start date of the target cohort observed in the data (after applying all restrictions). |
||
| target_min_days | Unknown | 0 | null |
|
|
The minimum number of observation days for a person. |
||
| target_p_10_days | Unknown | 0 | null |
|
|
The 10^th^ percentile of number of observation days for a person in the target group. |
||
| target_p_25_days | Unknown | 0 | null |
|
|
The 25^th^ percentile of number of observation days for a person in the target group. |
||
| target_p_75_days | Unknown | 0 | null |
|
|
The 75^th^ percentile of number of observation days for a person in the target group. |
||
| target_p_90_days | Unknown | 0 | null |
|
|
The 90^th^ percentile of number of observation days for a person in the target group. |