[ { "name" : "NODE_northwind.suppliers_fcb6fca6-80be-4115-9ab0-f2f73ce54f46", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`suppliers`.`supplier_id` AS `supplier_id`, `northwind`.`suppliers`.`supplier_id` AS `supplier_id`, `northwind`.`suppliers`.`postal_code` AS `postal_code`, `northwind`.`suppliers`.`region` AS `region`, `northwind`.`suppliers`.`contact_name` AS `contact_name`, `northwind`.`suppliers`.`homepage` AS `homepage`, `northwind`.`suppliers`.`fax` AS `fax`, `northwind`.`suppliers`.`phone` AS `phone`, `northwind`.`suppliers`.`contact_title` AS `contact_title`, `northwind`.`suppliers`.`city` AS `city`, `northwind`.`suppliers`.`address` AS `address`, `northwind`.`suppliers`.`company_name` AS `company_name`, `northwind`.`suppliers`.`country` AS `country`, \"Supplier\" AS `_NODE_LABEL_` FROM `northwind`.`suppliers`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "suppliers", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "supplier_id", "alias" : "supplier_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.suppliers" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "supplier_id", "alias" : "supplier_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "supplier_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "postal_code", "alias" : "postal_code", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "postal_code", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "region", "alias" : "region", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "region", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "contact_name", "alias" : "contact_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "contact_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "homepage", "alias" : "homepage", "sql-data-type" : "LONGVARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "homepage", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "fax", "alias" : "fax", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "fax", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "phone", "alias" : "phone", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "phone", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "contact_title", "alias" : "contact_title", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "contact_title", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "city", "alias" : "city", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "city", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "address", "alias" : "address", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "address", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "company_name", "alias" : "company_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "company_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "suppliers", "schema" : "northwind", "name" : "country", "alias" : "country", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "country", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "suppliers", "schema" : "northwind", "name" : "Supplier", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.categories_6eb0961c-2e1f-45e3-989a-4907a2ef3845", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`categories`.`category_id` AS `category_id`, `northwind`.`categories`.`category_id` AS `category_id`, `northwind`.`categories`.`description` AS `description`, `northwind`.`categories`.`category_name` AS `category_name`, \"Category\" AS `_NODE_LABEL_` FROM `northwind`.`categories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "categories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "categories", "schema" : "northwind", "name" : "category_id", "alias" : "category_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.categories" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "categories", "schema" : "northwind", "name" : "category_id", "alias" : "category_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "category_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "categories", "schema" : "northwind", "name" : "description", "alias" : "description", "sql-data-type" : "LONGVARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "description", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "categories", "schema" : "northwind", "name" : "category_name", "alias" : "category_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "category_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "categories", "schema" : "northwind", "name" : "Category", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.products_f30917a7-ebe6-4668-b653-a870359cfefe", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`products`.`product_id` AS `product_id`, `northwind`.`products`.`product_id` AS `product_id`, `northwind`.`products`.`discontinued` AS `discontinued`, `northwind`.`products`.`units_on_order` AS `units_on_order`, `northwind`.`products`.`units_in_stock` AS `units_in_stock`, `northwind`.`products`.`reorder_level` AS `reorder_level`, `northwind`.`products`.`quantity_per_unit` AS `quantity_per_unit`, `northwind`.`products`.`unit_price` AS `unit_price`, `northwind`.`products`.`product_name` AS `product_name`, \"Product\" AS `_NODE_LABEL_` FROM `northwind`.`products`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "products", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "product_id", "alias" : "product_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.products" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "product_id", "alias" : "product_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "product_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "discontinued", "alias" : "discontinued", "sql-data-type" : "INTEGER", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "discontinued", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "units_on_order", "alias" : "units_on_order", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "units_on_order", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "units_in_stock", "alias" : "units_in_stock", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "units_in_stock", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "reorder_level", "alias" : "reorder_level", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "reorder_level", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "quantity_per_unit", "alias" : "quantity_per_unit", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "quantity_per_unit", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "unit_price", "alias" : "unit_price", "sql-data-type" : "DOUBLE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "unit_price", "neo4j-data-type" : "Double", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "product_name", "alias" : "product_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "product_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "products", "schema" : "northwind", "name" : "Product", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "REL_categories_b1823586-4916-4602-bdb1-b8486fe2c163", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`products`.`product_id` AS `product_id`, `northwind`.`products`.`category_id` AS `category_id`, \"PART_OF\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`products`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "products", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "product_id", "alias" : "product_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.products" } }, { "column" : { "type" : "CompositeColumn", "table" : "products", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "category_id", "alias" : "category_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.categories" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "products", "schema" : "northwind", "name" : "PART_OF", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_suppliers_2c62e800-ce14-477e-828d-599cf7eaeddd", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`products`.`product_id` AS `product_id`, `northwind`.`products`.`supplier_id` AS `supplier_id`, \"SUPPLIERS\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`products`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "products", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "product_id", "alias" : "product_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.products" } }, { "column" : { "type" : "CompositeColumn", "table" : "products", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "products", "schema" : "northwind", "name" : "supplier_id", "alias" : "supplier_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.suppliers" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "products", "schema" : "northwind", "name" : "SUPPLIERS", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] } ]