Constraints are missing completely. Please add NOT NULL and FOREIGN KEY constraints.