# On the Spider node

MariaDB [gbd]> show create table output_epi_single_year_v19063_prevalence\G;
*************************** 1. row ***************************
       Table: output_epi_single_year_v19063_prevalence
Create Table: CREATE TABLE `output_epi_single_year_v19063_prevalence` (
  `measure_id` tinyint(3) NOT NULL COMMENT 'Required. Fk to shared.measure.measure_id ',
  `year_id` smallint(5) NOT NULL COMMENT 'Required. Fk to shared.year.year_id',
  `location_id` mediumint(7) NOT NULL COMMENT 'Required. Fk to shared.location.location_id',
  `sex_id` tinyint(3) NOT NULL COMMENT 'Required. Fk to shared.sex.sex_id ',
  `age_group_id` smallint(5) NOT NULL COMMENT 'Required. Fk to shared.age_group.age_group_id ',
  `cause_id` smallint(5) NOT NULL COMMENT 'Required. Fk to shared.cause.cause_id',
  `metric_id` tinyint(3) NOT NULL COMMENT 'Required. Fk to gbd.metric.metric_id ',
  `val` double NOT NULL COMMENT 'Required. Mean or actual value',
  `upper` double DEFAULT NULL COMMENT 'Optional. ',
  `lower` double DEFAULT NULL COMMENT 'Optional. ',
  PRIMARY KEY (`measure_id`,`year_id`,`location_id`,`sex_id`,`age_group_id`,`cause_id`,`metric_id`)
) ENGINE=SPIDER DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=COMPRESSED COMMENT='wrapper "mysql", 
srv "modeling_gbd_remote", table "output_epi_single_year_v19063_prevalence"'
1 row in set (0.000 sec)



# On the backend node

MariaDB [gbd]> show create table output_epi_single_year_v19063_prevalence\G;
*************************** 1. row ***************************
       Table: output_epi_single_year_v19063_prevalence
Create Table: CREATE TABLE `output_epi_single_year_v19063_prevalence` (
  `measure_id` tinyint(3) NOT NULL COMMENT 'Required. Fk to shared.measure.measure_id ',
  `location_id` mediumint(7) NOT NULL COMMENT 'Required. Fk to shared.location.location_id',
  `sex_id` tinyint(3) NOT NULL COMMENT 'Required. Fk to shared.sex.sex_id ',
  `age_group_id` smallint(5) NOT NULL COMMENT 'Required. Fk to shared.age_group.age_group_id ',
  `metric_id` tinyint(3) NOT NULL COMMENT 'Required. Fk to gbd.metric.metric_id ',
  `val` double NOT NULL COMMENT 'Required. Mean or actual value',
  `upper` double DEFAULT NULL COMMENT 'Optional. ',
  `lower` double DEFAULT NULL COMMENT 'Optional. ',
  `year_id` smallint(5) NOT NULL COMMENT 'Required. Fk to shared.year.year_id',
  `cause_id` smallint(5) NOT NULL COMMENT 'Required. Fk to shared.cause.cause_id',
  PRIMARY KEY (`measure_id`,`year_id`,`location_id`,`sex_id`,`age_group_id`,`cause_id`,`metric_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci ROW_FORMAT=COMPRESSED
1 row in set (0.000 sec)