{"ACCOUNTS": {"columns": [[0, "custid", "BIGINT", 1, null, 1], [1, "name", "VARCHAR(64)", 1, null, 0]], "primary_keys": ["custid"], "foreign_keys": [], "unique_constraints": [[[0, 0, "custid"]]], "check_constraints": []}, "SAVINGS": {"columns": [[0, "custid", "BIGINT", 1, null, 1], [1, "balance", "FLOAT", 1, null, 0]], "primary_keys": ["custid"], "foreign_keys": [[0, 0, "ACCOUNTS", "custid", "custid", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "custid"]]], "check_constraints": []}, "CHECKING": {"columns": [[0, "custid", "BIGINT", 1, null, 1], [1, "balance", "FLOAT", 1, null, 0]], "primary_keys": ["custid"], "foreign_keys": [[0, 0, "ACCOUNTS", "custid", "custid", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "custid"]]], "check_constraints": ["CREATE TABLE CHECKING ("]}}
CREATE TABLE ACCOUNTS (
    custid BIGINT NOT NULL  PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    UNIQUE (custid)
);

CREATE TABLE SAVINGS (
    custid BIGINT NOT NULL  PRIMARY KEY,
    balance FLOAT NOT NULL,
    UNIQUE (custid),
    FOREIGN KEY (custid) REFERENCES ACCOUNTS(custid)
);

CREATE TABLE CHECKING (
    custid BIGINT NOT NULL  PRIMARY KEY,
    balance FLOAT NOT NULL,
    UNIQUE (custid),
    FOREIGN KEY (custid) REFERENCES ACCOUNTS(custid),
    CREATE TABLE CHECKING (
);