Here are the database tables :

Important are node_base, node_identifiable (anything with a name), node_identifier, node_decl, node_type_decl.
Also node_record_type, node_field_decl

introspector/introspector/output/SQL