Subset of Columns from Devstronomy's Dataset

devstronomy_small_ddl.sql

CREATE TABLE `l_planet` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `mass` decimal(16,6) NOT NULL,
  `diameter` decimal(16,6) NOT NULL,
  `density` decimal(16,6) NOT NULL,
  `gravity` decimal(16,6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `l_satellite` (
  `id` int(11) NOT NULL DEFAULT '0',
  `planet_id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `radius` decimal(16,6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;