Are there still any ATMs in Japan that don’t charge fees for withdrawing with a foreign card?

I just got back to Japan for the first time in five years.

I seem to recall that that some ATMs here don’t accept foreign cards, some do but charge a fee, and some do and charge no fee.

I’m 100% aware of the fees my bank at home charges me to use ATMs overseas, I’m not asking about that.

I believe it used to be that the Post Office ATMs and the ones at 7-Eleven didn’t charge fees. But when I used my first 7-Eleven one this trip it did charge a fee. Googling, I have found that Post Office ATMs now charge a fee but since results were still saying 7-Eleven doesn’t charge a fee I can see such pages are not up-to-date.

Does anybody know which, if any, ATMs in Japan still don’t have a fee?

Foreign keys in UML Designer [on hold]

I’m trying to create a basic UML diagram for a project and found the UML Designer software which works wonders so far.

The only thing I don’t seem to be able to do (or at least I can’t find how to do it) is link the attribute from one Class to the attribute of another class.

What I want to do is define the attribute from one Class as a foreign key originating from an attribute of another Class (like a normal UML Diagram).

For example I have a Country class and a City class and I would like the City class to have an attribute Country name as a foreign key connected to the Country class Name attribute.

Thanks in advance.

How to use a variable in Mysql to remove a foreign key from a table?

I am attempting to delete a foreign key and index dynamically based on the table names, columns etc.

My products table looks as follows: Id Title Description Price Quantity DepartmentId

My department table looks as follows: Id Title

This is within a MySql database and i’ve tried the following:

SET @foreignKey = (SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'testemp' AND COLUMN_NAME = 'departmentid' AND TABLE_NAME = 'products' AND REFERENCED_TABLE_NAME = 'departments');  ALTER TABLE Products DROP FOREIGN KEY @foreignKey; ALTER TABLE Products DROP INDEX departmentId; 

which left me with this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@foreignKey' at line 1 

Laravel , migración con Foreign Key

Tengo estas migraciones en un proyecto de laravel 5.8 , en una creo la tabla Users y en la otra user_profiles , en la segunda pongo una Foreign Key del campo “user_id” al campo “id” de la tabla “users”

public function up() { Schema::create(‘users’, function (Blueprint $ table) { $ table->increments(‘id’); $ table->string(‘name’); $ table->rememberToken(); $ table->timestamps(); }); }

public function up() {     Schema::create('user_profiles', function (Blueprint $  table) {         $  table->increments('id')->unsigned();         $  table->integer('user_id')->unique();         $  table->integer('age')->nullable();          $  table->foreign('user_id')->references('id')->on('users');      }); } 

El error obtenido es el siguiente

Migrating: 2015_10_12_000000_create_user_profiles_table

Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1005 Can’t create table portal.#sql-4cc8_70 (errno: 150 “Foreign key constraint is incorrectly formed”) (SQL: alter table user_pro files add constraint user_profiles_user_id_foreign foreign key (user_id) references users (id))

Prime Video – Foreign Speech Subtitles in Original Language

I’ve noticed this with shows that have dialogue in multiple languages. For reference I live in Germany, so on amazon.de there will be shows available in German and “original voice” (usually English), titled [dt./OV]. This lets me select English as the audio language and “none” as the subtitle language. When I do this I get no subtitles for regular dialogue. However, speaking in foreign languages, e.g. Spanish, will still be subtitled in German, which is very annoying if I’m trying to watch a show as originally intended. Is there any way to convince Amazon’s player to give the complete original experience, including no subtitles and English/original for foreign dialogue?

I suspect the answer will be no since I haven’t found any hidden settings, but maybe I missed something. My guess is that Amazon supplies subtitles and audio tracks in multiple languages but only the German render of the video and that these foreign language subtitles are baked into that video file. In that case, I would be very disappointed with Amazon for providing supposedly OV content, but not even bothering to switch the video source to the right language!

Any ideas?

I work for a foreign government. Can I travel to the USA on an A-2 visa?

I have Dutch citizenship and I work for a German federal government agency. My employer has advised its employees that they must obtain an A-2 visa when travelling to the United States for work and must not travel on ESTA. The U.S. Department of State defines several categories for A-2, including:

Government official representing your government, coming to the United States based on written request of your country to perform official, government related duties.

Does the phrasing your government means the government I represent must match my nationality (country issuing passport), or can I travel on an A-2 visa on behalf of a government different from the one that issued my passport? The purpose of my travel is to attend a conference (with any regular employer I would have simply travelled on VWP/ESTA, but my employer has explicitly advised that we must not do so).

Validating form with the foreign key relation

i am developing api to create “posts” , so i am posting like below and the relation has been defined in User and Posts entity

{    "user": {         "username": "some_name"    },    "title": "testing",    "content": "test content" } 

and i need to validate whether correct username is posted?. How could i do that?

My controller like this

$  post = new Post(); $  form = $  this->createForm(PostType::class, $  post); $  form->submit($  request->request->all()); 

My builder Form like this

$  builder     ->add('title', TextType::class)     ->add('content', TextType::class)     ->add('User', UserType::class, array(         'data_class' => User::class     )); 

But it tries to create user everytime instead of checking valid username is passed. Any ideas?

Foreign Keys with ON DELETE SET NULL are still deleted when TRUNCATE CASCADE is called on the foreign table in Postgres

Maybe I am missing something here:

CREATE TABLE public.example_table (     id integer UNIQUE );  CREATE TABLE public.foreign_table (     id integer,     example_table_id integer,     CONSTRAINT fk_example_table_id     FOREIGN KEY (example_table_id)     REFERENCES public.example_table (id)     ON DELETE SET NULL );  INSERT INTO public.example_table (id) VALUES     (1);  INSERT INTO public.foreign_table (id, example_table_id) VALUES     (1, 1),     (2, null); 

If I run TRUNCATE CASCADE, both tables are wiped which is not what I expected would happen.

TRUNCATE example_table CASCADE;  SELECT COUNT(*) FROM public.foreign_table;  0 

What I would expect to happen would be that foreign_table would alter to:

(1, null) (2, null) 

Am I not understanding what SET NULL is supposed to accomplish?

Is there a way to use TRUNCATE CASCADE without having it delete from the other table? I use Laravel where I can call Model::truncate(); and it will automatically truncate the table and reset my indexes, I was hoping I could call this on the example_table and have it reset all the rows in foreign_table to null instead of just deleting the whole table.

Thanks for your help.