Mysterious wp_posts.post_status values (1 post)

object, attachment, inherit, future? Any documentation of what these are?

If I just want to pull the current, visible posts up from the database to display somewhere on my site (outside of the blog), will getting posts where post_status = "publish" and post_date <= now() do it? Will that be enough to hide scheduled posts, password protected posts, drafts, etc.?