Updates to "back links" and DDL

Made some columns NOT NULL based on common sense.