[ { "name" : "NODE_northwind.orders_8a48bd6e-0c3f-444d-8610-207719d32924", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`orders`.`order_id` AS `order_id`, `northwind`.`orders`.`order_id` AS `order_id`, `northwind`.`orders`.`ship_city` AS `ship_city`, `northwind`.`orders`.`ship_postal_code` AS `ship_postal_code`, `northwind`.`orders`.`order_date` AS `order_date`, `northwind`.`orders`.`ship_country` AS `ship_country`, `northwind`.`orders`.`ship_address` AS `ship_address`, `northwind`.`orders`.`required_date` AS `required_date`, `northwind`.`orders`.`ship_name` AS `ship_name`, `northwind`.`orders`.`shipped_date` AS `shipped_date`, `northwind`.`orders`.`ship_region` AS `ship_region`, `northwind`.`orders`.`freight` AS `freight`, \"Order\" AS `_NODE_LABEL_` FROM `northwind`.`orders`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.orders" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "order_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_city", "alias" : "ship_city", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "ship_city", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_postal_code", "alias" : "ship_postal_code", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "ship_postal_code", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "order_date", "alias" : "order_date", "sql-data-type" : "DATE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "order_date", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_country", "alias" : "ship_country", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "ship_country", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_address", "alias" : "ship_address", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "ship_address", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "required_date", "alias" : "required_date", "sql-data-type" : "DATE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "required_date", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_name", "alias" : "ship_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "ship_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "shipped_date", "alias" : "shipped_date", "sql-data-type" : "DATE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "shipped_date", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_region", "alias" : "ship_region", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "ship_region", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "freight", "alias" : "freight", "sql-data-type" : "DOUBLE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "freight", "neo4j-data-type" : "Double", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "orders", "schema" : "northwind", "name" : "Order", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.customers_d2f0a81c-5aa0-4f63-80d4-5557be439d07", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`customers`.`customer_id` AS `customer_id`, `northwind`.`customers`.`customer_id` AS `customer_id`, `northwind`.`customers`.`fax` AS `fax`, `northwind`.`customers`.`address` AS `address`, `northwind`.`customers`.`postal_code` AS `postal_code`, `northwind`.`customers`.`region` AS `region`, `northwind`.`customers`.`contact_title` AS `contact_title`, `northwind`.`customers`.`country` AS `country`, `northwind`.`customers`.`contact_name` AS `contact_name`, `northwind`.`customers`.`city` AS `city`, `northwind`.`customers`.`phone` AS `phone`, `northwind`.`customers`.`company_name` AS `company_name`, \"Customer\" AS `_NODE_LABEL_` FROM `northwind`.`customers`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "customers", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "customers", "schema" : "northwind", "name" : "customer_id", "alias" : "customer_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.customers" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "customers", "schema" : "northwind", "name" : "customer_id", "alias" : "customer_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "customer_id", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "customers", "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" : "customers", "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" : "customers", "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" : "customers", "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" : "customers", "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" : "customers", "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" : "Data", "table" : "customers", "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" : "customers", "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" : "customers", "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" : "customers", "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" : "Literal", "table" : "customers", "schema" : "northwind", "name" : "Customer", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.employees_33e170ad-06fa-4cc3-ab21-5fe2344837e0", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`employees`.`employee_id` AS `employee_id`, `northwind`.`employees`.`employee_id` AS `employee_id`, `northwind`.`employees`.`first_name` AS `first_name`, `northwind`.`employees`.`photo_path` AS `photo_path`, `northwind`.`employees`.`title_of_courtesy` AS `title_of_courtesy`, `northwind`.`employees`.`last_name` AS `last_name`, `northwind`.`employees`.`region` AS `region`, `northwind`.`employees`.`reports_to` AS `reports_to`, `northwind`.`employees`.`city` AS `city`, `northwind`.`employees`.`notes` AS `notes`, `northwind`.`employees`.`address` AS `address`, `northwind`.`employees`.`country` AS `country`, `northwind`.`employees`.`extension` AS `extension`, `northwind`.`employees`.`home_phone` AS `home_phone`, `northwind`.`employees`.`title` AS `title`, `northwind`.`employees`.`postal_code` AS `postal_code`, `northwind`.`employees`.`hire_date` AS `hire_date`, `northwind`.`employees`.`birth_date` AS `birth_date`, \"Employee\" AS `_NODE_LABEL_` FROM `northwind`.`employees`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "employees", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.employees" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "employee_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "first_name", "alias" : "first_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "first_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "photo_path", "alias" : "photo_path", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "photo_path", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "title_of_courtesy", "alias" : "title_of_courtesy", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "title_of_courtesy", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "last_name", "alias" : "last_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "last_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "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" : "employees", "schema" : "northwind", "name" : "reports_to", "alias" : "reports_to", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "reports_to", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "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" : "employees", "schema" : "northwind", "name" : "notes", "alias" : "notes", "sql-data-type" : "LONGVARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "notes", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "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" : "employees", "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" : "Data", "table" : "employees", "schema" : "northwind", "name" : "extension", "alias" : "extension", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "extension", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "home_phone", "alias" : "home_phone", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "home_phone", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "title", "alias" : "title", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "title", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "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" : "employees", "schema" : "northwind", "name" : "hire_date", "alias" : "hire_date", "sql-data-type" : "DATE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "hire_date", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employees", "schema" : "northwind", "name" : "birth_date", "alias" : "birth_date", "sql-data-type" : "DATE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "birth_date", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "employees", "schema" : "northwind", "name" : "Employee", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.territories_b9461b8c-64ac-4727-8cf0-3c2a217b1f6c", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`territories`.`territory_id` AS `territory_id`, `northwind`.`territories`.`territory_id` AS `territory_id`, `northwind`.`territories`.`territory_description` AS `territory_description`, \"Territory\" AS `_NODE_LABEL_` FROM `northwind`.`territories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "territories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.territories" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "territory_id", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "territories", "schema" : "northwind", "name" : "territory_description", "alias" : "territory_description", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "territory_description", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "territories", "schema" : "northwind", "name" : "Territory", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.categories_c8bbf5b9-685c-4c07-8593-d3cd2eee6e81", "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.customercustomerdemo_56e499d2-2c53-4bee-a80d-aac7a20defe6", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`customer_customer_demo`.`customer_id` AS `customer_id`, `northwind`.`customer_customer_demo`.`customer_type_id` AS `customer_type_id`, `northwind`.`customer_customer_demo`.`customer_id` AS `customer_id`, `northwind`.`customer_customer_demo`.`customer_type_id` AS `customer_type_id`, \"CustomerCustomerDemo\" AS `_NODE_LABEL_` FROM `northwind`.`customer_customer_demo`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "customer_customer_demo", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_customer_demo", "schema" : "northwind", "name" : "customer_id", "alias" : "customer_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_customer_demo", "schema" : "northwind", "name" : "customer_type_id", "alias" : "customer_type_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.customer_customer_demo" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_customer_demo", "schema" : "northwind", "name" : "customer_id", "alias" : "customer_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "customer_id", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_customer_demo", "schema" : "northwind", "name" : "customer_type_id", "alias" : "customer_type_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "customer_type_id", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "customer_customer_demo", "schema" : "northwind", "name" : "CustomerCustomerDemo", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.employeeterritories_b14af058-86ff-494d-902a-d86da164e9cd", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`employee_territories`.`employee_id` AS `employee_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, `northwind`.`employee_territories`.`employee_id` AS `employee_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, \"EmployeeTerritory\" AS `_NODE_LABEL_` FROM `northwind`.`employee_territories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.employee_territories" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "employee_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "territory_id", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "employee_territories", "schema" : "northwind", "name" : "EmployeeTerritory", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.usstates_00251338-0758-4ff1-a942-67cbd2a589f8", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`us_states`.`state_id` AS `state_id`, `northwind`.`us_states`.`state_id` AS `state_id`, `northwind`.`us_states`.`state_abbr` AS `state_abbr`, `northwind`.`us_states`.`state_name` AS `state_name`, `northwind`.`us_states`.`state_region` AS `state_region`, \"UsState\" AS `_NODE_LABEL_` FROM `northwind`.`us_states`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "us_states", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "us_states", "schema" : "northwind", "name" : "state_id", "alias" : "state_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.us_states" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "us_states", "schema" : "northwind", "name" : "state_id", "alias" : "state_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "state_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "us_states", "schema" : "northwind", "name" : "state_abbr", "alias" : "state_abbr", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "state_abbr", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "us_states", "schema" : "northwind", "name" : "state_name", "alias" : "state_name", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "state_name", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "us_states", "schema" : "northwind", "name" : "state_region", "alias" : "state_region", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "state_region", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "us_states", "schema" : "northwind", "name" : "UsState", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.products_5ecf40a2-9024-4d44-b8a1-a2e13416016b", "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" : "NODE_northwind.region_a2bdf674-26d2-4183-a4db-850754f75cd5", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`region`.`region_id` AS `region_id`, `northwind`.`region`.`region_id` AS `region_id`, `northwind`.`region`.`region_description` AS `region_description`, \"Region\" AS `_NODE_LABEL_` FROM `northwind`.`region`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "region", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "region", "schema" : "northwind", "name" : "region_id", "alias" : "region_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.region" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "region", "schema" : "northwind", "name" : "region_id", "alias" : "region_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "region_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "region", "schema" : "northwind", "name" : "region_description", "alias" : "region_description", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "region_description", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "region", "schema" : "northwind", "name" : "Region", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.shippers_eb863206-e7d8-4ee0-9503-b06630e42c1d", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`shippers`.`shipper_id` AS `shipper_id`, `northwind`.`shippers`.`shipper_id` AS `shipper_id`, `northwind`.`shippers`.`company_name` AS `company_name`, `northwind`.`shippers`.`phone` AS `phone`, \"Shipper\" AS `_NODE_LABEL_` FROM `northwind`.`shippers`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "shippers", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "shippers", "schema" : "northwind", "name" : "shipper_id", "alias" : "shipper_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.shippers" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "shippers", "schema" : "northwind", "name" : "shipper_id", "alias" : "shipper_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "shipper_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "shippers", "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" : "shippers", "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" : "Literal", "table" : "shippers", "schema" : "northwind", "name" : "Shipper", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "NODE_northwind.suppliers_d425c7b0-ab06-433c-b2a2-877fd90b7409", "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.customerdemographics_7c498c87-f60c-42aa-832e-64639621314c", "schema" : "northwind", "graph-object-type" : "Node", "sql" : "SELECT `northwind`.`customer_demographics`.`customer_type_id` AS `customer_type_id`, `northwind`.`customer_demographics`.`customer_type_id` AS `customer_type_id`, `northwind`.`customer_demographics`.`customer_desc` AS `customer_desc`, \"CustomerDemographic\" AS `_NODE_LABEL_` FROM `northwind`.`customer_demographics`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "customer_demographics", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_demographics", "schema" : "northwind", "name" : "customer_type_id", "alias" : "customer_type_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "Id", "name" : "", "id-space" : "northwind.customer_demographics" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_demographics", "schema" : "northwind", "name" : "customer_type_id", "alias" : "customer_type_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "customer_type_id", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "customer_demographics", "schema" : "northwind", "name" : "customer_desc", "alias" : "customer_desc", "sql-data-type" : "LONGVARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "customer_desc", "neo4j-data-type" : "String", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "customer_demographics", "schema" : "northwind", "name" : "CustomerDemographic", "alias" : "_NODE_LABEL_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Label" } } ] }, { "name" : "REL_employees_9c273cd8-04ee-4572-9367-28fc060c087f", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`orders`.`order_id` AS `order_id`, `northwind`.`orders`.`employee_id` AS `employee_id`, \"EMPLOYEES\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`orders`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.orders" } }, { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.employees" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "orders", "schema" : "northwind", "name" : "EMPLOYEES", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_shippers_fca2ca7b-8ef1-4f4a-afab-0f42dc115f84", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`orders`.`order_id` AS `order_id`, `northwind`.`orders`.`ship_via` AS `ship_via`, \"SHIPPERS\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`orders`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.orders" } }, { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "ship_via", "alias" : "ship_via", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.shippers" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "orders", "schema" : "northwind", "name" : "SHIPPERS", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_region_713b59e2-1ed4-44d9-bee3-327c2c9d427b", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`territories`.`territory_id` AS `territory_id`, `northwind`.`territories`.`region_id` AS `region_id`, \"REGION\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`territories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "territories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.territories" } }, { "column" : { "type" : "CompositeColumn", "table" : "territories", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "territories", "schema" : "northwind", "name" : "region_id", "alias" : "region_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.region" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "territories", "schema" : "northwind", "name" : "REGION", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_customers_ce31bf89-c6b5-414e-9ef6-43fa6865078f", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`orders`.`order_id` AS `order_id`, `northwind`.`orders`.`customer_id` AS `customer_id`, \"CUSTOMERS\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`orders`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.orders" } }, { "column" : { "type" : "CompositeColumn", "table" : "orders", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "orders", "schema" : "northwind", "name" : "customer_id", "alias" : "customer_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.customers" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "orders", "schema" : "northwind", "name" : "CUSTOMERS", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_territories_3e30d34c-7196-492a-ad61-d31578081cc0", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`employee_territories`.`employee_id` AS `employee_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, \"TERRITORIES\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`employee_territories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.employee_territories" } }, { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.territories" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "employee_territories", "schema" : "northwind", "name" : "TERRITORIES", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_suppliers_0b04125d-4516-4cbd-be2e-6455f80ffc34", "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" } } ] }, { "name" : "REL_territories_206fd7e5-ffcb-44c1-b61a-a03818c804bd", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`employee_territories`.`employee_id` AS `employee_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, \"TERRITORIES\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`employee_territories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.employee_territories" } }, { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.territories" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "employee_territories", "schema" : "northwind", "name" : "TERRITORIES", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_categories_f20dbed3-518a-4db9-816b-0d9f116f2e3e", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`products`.`product_id` AS `product_id`, `northwind`.`products`.`category_id` AS `category_id`, \"CATEGORIES\" 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" : "CATEGORIES", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_employees_29961d30-89cc-4bbb-b599-0c60b7b06e8c", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`employee_territories`.`employee_id` AS `employee_id`, `northwind`.`employee_territories`.`territory_id` AS `territory_id`, `northwind`.`employee_territories`.`employee_id` AS `employee_id`, \"EMPLOYEES\" AS `_RELATIONSHIP_TYPE_` FROM `northwind`.`employee_territories`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "PrimaryKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "territory_id", "alias" : "territory_id", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.employee_territories" } }, { "column" : { "type" : "CompositeColumn", "table" : "employee_territories", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "employee_territories", "schema" : "northwind", "name" : "employee_id", "alias" : "employee_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.employees" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "employee_territories", "schema" : "northwind", "name" : "EMPLOYEES", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } } ] }, { "name" : "REL_ORDERDETAILS_6d7eb6f8-1f43-4597-8750-2c926959dd30", "schema" : "northwind", "graph-object-type" : "Relationship", "sql" : "SELECT `northwind`.`order_details`.`order_id` AS `order_id`, `northwind`.`order_details`.`product_id` AS `product_id`, \"ORDER_DETAILS\" AS `_RELATIONSHIP_TYPE_`, `northwind`.`order_details`.`order_id` AS `order_id`, `northwind`.`order_details`.`product_id` AS `product_id`, `northwind`.`order_details`.`quantity` AS `quantity`, `northwind`.`order_details`.`unit_price` AS `unit_price`, `northwind`.`order_details`.`discount` AS `discount` FROM `northwind`.`order_details`", "mappings" : [ { "column" : { "type" : "CompositeColumn", "table" : "order_details", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "order_details", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "StartId", "id-space" : "northwind.orders" } }, { "column" : { "type" : "CompositeColumn", "table" : "order_details", "schema" : "northwind", "role" : "ForeignKey", "columns" : [ { "type" : "SimpleColumn", "role" : "Data", "table" : "order_details", "schema" : "northwind", "name" : "product_id", "alias" : "product_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" } ] }, "field" : { "type" : "EndId", "id-space" : "northwind.products" } }, { "column" : { "type" : "SimpleColumn", "role" : "Literal", "table" : "order_details", "schema" : "northwind", "name" : "ORDER_DETAILS", "alias" : "_RELATIONSHIP_TYPE_", "sql-data-type" : "VARCHAR", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "RelationshipType" } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "order_details", "schema" : "northwind", "name" : "order_id", "alias" : "order_id", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "order_id", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "order_details", "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" : "order_details", "schema" : "northwind", "name" : "quantity", "alias" : "quantity", "sql-data-type" : "SMALLINT", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "quantity", "neo4j-data-type" : "Long", "is-array" : false } }, { "column" : { "type" : "SimpleColumn", "role" : "Data", "table" : "order_details", "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" : "order_details", "schema" : "northwind", "name" : "discount", "alias" : "discount", "sql-data-type" : "DOUBLE", "column-value-selection-strategy" : "SelectColumnValue" }, "field" : { "type" : "Data", "name" : "discount", "neo4j-data-type" : "Double", "is-array" : false } } ] } ]