user_url

유저별 url관리 테이블

CREATE TABLE IF NOT EXISTS `yummy_spam`.`user_url` (
  `id` INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(6) UNSIGNED NOT NULL COMMENT 'user 테이블의 primary key (id)',
  `url_id` INT UNSIGNED NOT NULL COMMENT 'domain_url 테이블의 primary key (id)',
  PRIMARY KEY (`id`),
  INDEX `fk_user_id_idx` (`user_id` ASC) VISIBLE,
  UNIQUE INDEX `user_url_UNIQUE` (`user_id` ASC, `url_id` ASC) VISIBLE,
  INDEX `fk_notice_url_id_idx` (`url_id` ASC) VISIBLE,
  CONSTRAINT `fk_user_id`
    FOREIGN KEY (`user_id`)
    REFERENCES `yummy_spam`.`user` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_notice_url_id`
    FOREIGN KEY (`url_id`)
    REFERENCES `yummy_spam`.`domain_url` (`id`)
    ON DELETE CASCADE
    ON UPDATE NO ACTION)
ENGINE = InnoDB