CREATE TABLE `battery_case_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT 'e.g., L1, L2, D26',
  `standard` enum('DIN','JIS','BCI') DEFAULT 'DIN' COMMENT '??????????????????: ??????????????/??????????/????????????????',
  `length_mm` int(10) unsigned DEFAULT NULL COMMENT '?????? ???? ?????????????????',
  `width_mm` int(10) unsigned DEFAULT NULL COMMENT '?????? ???? ?????????????????',
  `height_mm` int(10) unsigned DEFAULT NULL COMMENT '???????????? ???? ?????????????????',
  `terminal_type` enum('A','B','SIDE') DEFAULT 'A' COMMENT '?????? ??????????????: A=?????????????? ?????????? B=?????????? ?????????? SIDE=??????????',
  `is_tall_base` tinyint(1) DEFAULT 1 COMMENT '???????? ????????=TRUE?? ???????? ??????????=FALSE',
  `display_order` int(11) DEFAULT 0 COMMENT '?????????? ??????????',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
