Get Data Model
get_data_modelRetrieve ImmPort release database schemas—tables, columns, types, keys, and joins—to clarify field meanings and join paths before querying or analyzing release data.
Instructions
Get the ImmPort data model: the tables of the release database (the same tables as the Tab.zip / MySQL release files), with columns, types, descriptions, keys and joins. Public — no authentication needed.
• no table → index of all tables: [{name, type, description, columnCount}] (~110 tables) • table='arm_or_cohort' → that table in full: columns [{name, type, nullable, default, description}], primaryKey, foreignKeys [{columns, referencedTable, referencedColumns}], indexes, and referencedBy (tables that point to it)
Use it to understand what a column means, which columns hold controlled values (foreign keys to lk_* tables — get the values with lookup_controlled_vocabulary), and how to join tables (e.g. subject → arm_2_subject → arm_or_cohort → study) before analysing Tab.zip or MySQL files or writing SQL. For the overview of entities and API endpoints read immport://data-model.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |