I've noticed that some boolean fields in the database are defined as 2-digit integers (e.g. node.stiky, node.promote, node.moderate...)

Why aren't they defined as 1-digit integers?

When I create my own table, how should I define my boolean fields?