return bigint to inherit int, as it allows length; boolean type should be boolean, not tinyint