Therefore, the table representing the nt:file node type will have 3 columns: the "jcr:created" and "jcr:createdBy" columns inherited from the mix:created mixin node type (via the nt:hierarchyNode node type), and the "jcr:primaryType" column inherited from the nt:base node type, which is the implicit supertype of the nt:hierarchyNode (and all node types).
ModeShape adheres to this behavior with the exception that a "SELECT *" will result in the additional pseudo-columns. Thus, this next query: