word

단어 테이블

CREATE TABLE IF NOT EXISTS `yummy_spam`.`word` (
  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `word` VARCHAR(45) NOT NULL COMMENT '단어',
  `lang_id` INT UNSIGNED NOT NULL COMMENT 'lang_mst 테이블의 primary key(id)',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `word_UNIQUE` (`word` ASC) VISIBLE,
  INDEX `fk_lang_mst_id_idx` (`lang_id` ASC) VISIBLE,
  CONSTRAINT `fk_lang_id`
    FOREIGN KEY (`lang_id`)
    REFERENCES `yummy_spam`.`lang_mst` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB