| i10snom_id | varchar(36) | NO | | PRI | | |
| i10snom_effective_date | date | NO | | MUL | | |
| i10snom_active | tinyint(1) | NO | 1 | | | |
| i10snom_reference_component_id | bigint(20) | NO | | MUL | | |
| i10snom_reference_component_name | varchar(512) | NO | | | | |
| i10snom_map_group | int(11) | NO | 0 | | | |
| i10snom_map_priority | int(11) | NO | 0 | MUL | | |
| i10snom_map_rule | text | NO | | | | |
| i10snom_map_advice | text | NO | | | | |
| i10snom_map_target | varchar(10) | NO | | MUL | | ICD10 code |
| i10snom_map_category_id | bigint(20) | NO | | MUL | | |
| i10snom_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| i10snom_created | timestamp | YES | CURRENT_TIMESTAMP | | | |