Database Table Scheme For MHRise Skill Simulator

gistfile1.txt

CREATE TABLE `weapons` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '武器ID',
  `name` varchar(255) NOT NULL COMMENT '武器名',
  `type` tinyint(4) unsigned NOT NULL COMMENT '武器種',
  `tree` varchar(255) NOT NULL COMMENT '派生名',
  `rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度',
  `rank` tinyint(4) unsigned NOT NULL COMMENT 'ランク',
  `attack` int(11) unsigned NOT NULL COMMENT '攻撃力',
  `sharpness` json DEFAULT NULL COMMENT '切れ味',
  `affinity` tinyint(4) NOT NULL COMMENT '会心率',
  `defense_bonus` int(11) NOT NULL COMMENT '防御力',
  `element1` tinyint(4) unsigned NOT NULL COMMENT '属性1',
  `element2` tinyint(4) unsigned NOT NULL COMMENT '属性2',
  `elem1_value` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '属性値1',
  `elem2_value` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '属性値2',
  `slot1` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット1',
  `slot2` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット2',
  `slot3` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット3',
  `rampage_skills` json DEFAULT NULL COMMENT '百竜スキル',
  `forging_materials` json DEFAULT NULL COMMENT '生産素材',
  `upgrade_materials` json DEFAULT NULL COMMENT '強化素材',
  `forge_funds` int(11) unsigned NOT NULL COMMENT '生産費用',
  `forge_with_money` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '購入費用',
  `upgrade_funds` int(11) unsigned NOT NULL COMMENT '強化費用',
  `rollbackable` bit(1) NOT NULL DEFAULT b'1' COMMENT 'ロールバック可否',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='武器マスター'
;

CREATE TABLE `armors` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '防具ID',
  `name` varchar(255) NOT NULL COMMENT '防具名',
  `series` varchar(255) NOT NULL COMMENT 'シリーズ名',
  `type` tinyint(4) unsigned NOT NULL COMMENT '部位',
  `rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度',
  `rank` tinyint(4) unsigned NOT NULL COMMENT 'ランク',
  `defense` int(11) unsigned NOT NULL COMMENT '防御力',
  `level` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT 'レベル',
  `max_level` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '最大レベル',
  `fire_resistance` tinyint(4) NOT NULL COMMENT '火耐性',
  `water_resistance` tinyint(4) NOT NULL COMMENT '水耐性',
  `thunder_resistance` tinyint(4) NOT NULL COMMENT '雷耐性',
  `ice_resistance` tinyint(4) NOT NULL COMMENT '氷耐性',
  `dragon_resistance` tinyint(4) NOT NULL COMMENT '龍耐性',
  `slot1` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット1',
  `slot2` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット2',
  `slot3` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット3',
  `skills` json DEFAULT NULL COMMENT 'スキル',
  `forging_materials` json DEFAULT NULL COMMENT '生産素材',
  `forge_funds` int(11) unsigned NOT NULL COMMENT '生産費用',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='防具マスター'
;

CREATE TABLE `talismans` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '護石ID',
  `name` varchar(255) NOT NULL COMMENT '護石名',
  `rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度',
  `slot1` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット1',
  `slot2` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット2',
  `slot3` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット3',
  `skills` json DEFAULT NULL COMMENT 'スキル',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='護石マスター'
;

CREATE TABLE `decorations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '装飾品ID',
  `name` varchar(255) NOT NULL COMMENT '装飾品名',
  `rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度',
  `slot` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT 'スロット',
  `skills` json DEFAULT NULL COMMENT 'スキル',
  `forging_materials` json DEFAULT NULL COMMENT '生産素材',
  `forge_funds` int(11) unsigned NOT NULL COMMENT '生産費用',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='装飾品マスター'
;

Oops, I forgot the skills table.

CREATE TABLE `skills` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'スキルID',
  `name` varchar(255) NOT NULL COMMENT 'スキル名',
  `description` text NOT NULL COMMENT 'スキル概要',
  `max_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '最大レベル',
  `status` json DEFAULT NULL COMMENT 'ステータス',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='スキルマスター'
;