The object type is not null, just the table_name column is acs_object_types, since the object_type itself is the only additional attribute of a subtype. Two places this comes up frequently are acs_rels, where you need to differentiate between rel types but don't need additional attributes, and content_revision subtypes where you need to know the content type, but don't need to add additional attributes.
