CREATE TABLE USER_BRANCH_XREF (
    USER    VARCHAR2(20)  NOT NULL  REFERENCES USERS(USERNAME)
   ,BRANCH  NUMBER        NOT NULL  REFERENCES BRANCHES(ID)
   ,CONSTRAINT PRIMARY KEY (USER, BRANCH)
);