Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| analysis_id | Unknown | 0 | null |
|
|
A unique identifier for an analysis. |
|||||
| database_id | Unknown | 0 | null |
|
|
Foreign key referencing the database. |
|||||
| era_id | Unknown | 0 | null |
|
|
A unique identifier, corresponding to the ID in the source table (e.g. cohort_definition_id in a cohort table, or the drug_concept_id in the drug_era table). |
|||||
| era_name | Unknown | 0 | null |
|
|
A name for the era. Is NULL for eras derived from cohorts. |
|||||
| era_type | Unknown | 0 | null |
|
|
The type of era (e.g. ‘rx’ for drugs). |
|||||
| exposures_outcome_set_id | Unknown | 0 | null |
|
|
A foreign key referencing the sccs_exposures_outcome_set table. |