CREATE TABLE creditcard_applications (
  id INT AUTO_INCREMENT PRIMARY KEY,
  card_id INT NOT NULL,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(100) NOT NULL,
  phone VARCHAR(20) NOT NULL,
  nationality VARCHAR(50) NOT NULL,
  salary DECIMAL(10, 2) NOT NULL,
  agree BOOLEAN NOT NULL DEFAULT false,
  submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  
  -- Foreign key with ON DELETE NO ACTION
  FOREIGN KEY (card_id) REFERENCES creditcards(idcreditcards)
    ON DELETE NO ACTION
);