   PRIMARY KEY (`user_login_id`),
   CONSTRAINT `login_user_id`
     FOREIGN KEY (`user_login_id`)
-    REFERENCES `emarket`.`user_info` (`user_id`)
-    ON DELETE CASCADE
-    ON UPDATE CASCADE)
-ENGINE = InnoDB;
-
-
--- -----------------------------------------------------
--- Table `emarket`.`address_history`
--- -----------------------------------------------------
-CREATE TABLE IF NOT EXISTS `emarket`.`address_history` (
+    REFERENCES `emarket_test`.`user_info` (`user_id`)
+    ON DELETE CASCADE
+    ON UPDATE CASCADE)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `emarket_test`.`address_history`
+-- -----------------------------------------------------
+CREATE TABLE IF NOT EXISTS `emarket_test`.`address_history` (
   `address_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `address_address` VARCHAR(255) NOT NULL,
   `address_country` VARCHAR(45) NOT NULL,

  INDEX `product_product_spec_id_idx` (`product_info_spec_id` ASC),
  CONSTRAINT `product_user_id`
    FOREIGN KEY (`product_seller_id`)
    REFERENCES `emarket`.`user_info` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `product_spec_id`
    FOREIGN KEY (`product_info_spec_id`)
    REFERENCES `emarket`.`product_specification` (`product_spec_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `emarket`.`bid_history`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `emarket`.`bid_history` (
  `bid_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `bid_user_id` INT UNSIGNED NOT NULL,
  `bid_product_id` INT UNSIGNED NOT NULL,

  INDEX `card_billing_id_idx` (`credit_card_billing_address_id` ASC),
  CONSTRAINT `credit_user_id`
    FOREIGN KEY (`credit_card_user_id`)
    REFERENCES `emarket_test`.`user_info` (`user_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `credit_billing_id`
    FOREIGN KEY (`credit_card_billing_address_id`)
    REFERENCES `emarket_test`.`billing_info` (`billing_id`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `emarket_test`.`bank_info`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `emarket_test`.`bank_info` (
  `bank_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `bank_user_id` INT UNSIGNED NOT NULL,
  `bank_billing_address_id` INT UNSIGNED NOT NULL,
