How can I solve FK contraint? With trigger or something else?
#IF "DELETE FROM human where name='a';", error due to the FK contraist.
# If the error, I want in the order:
# FIRSTLY. DELETE FROM address where name='a';
# SECONDLY. DELETE FROM human where name='a';
DROP TABLE human;
DROP TABLE address;
CREATE TABLE human(
name varchar(300) PRIMARY KEY not null
);
CREATE TABLE address(
name varchar(300)
references human.name
);