alchemytest.sql

CREATE TABLE account (
  id SERIAL NOT NULL UNIQUE,
  name TEXT NOT NULL
);

CREATE TABLE credit_card (
  id SERIAL NOT NULL UNIQUE,
  account_id INTEGER NOT NULL REFERENCES account(id),
  card_number TEXT NOT NULL,
  UNIQUE (account_id, id)
);

CREATE TABLE address (
  id SERIAL NOT NULL UNIQUE,
  account_id INTEGER NOT NULL REFERENCES account(id),
  credit_card_id INTEGER NULL,
  FOREIGN KEY (credit_card_id, account_id) REFERENCES credit_card(id, account_id)
);