#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

id: "sql.model.id"
name: "SQL-based model."
version: "1.0.0-1579684422"
description: "Modified SQL-based model auto-generated by NCSqlModelGenerator utility."
metadata:
  sql:cmdline: "-r jdbc:h2:tcp://localhost:9092/nlp2sql -d org.h2.Driver -s PUBLIC\
    \ -o src/main/scala/org/apache/nlpcraft/examples/sql/sql_model_init.yaml"
  sql:url: "jdbc:h2:tcp://localhost:9092/nlp2sql"
  sql:driver: "org.h2.Driver"
  sql:joins:
  - fromtable: "orders"
    fromcolumns:
    - "customer_id"
    totable: "customers"
    tocolumns:
    - "customer_id"
    jointype: "left"
  - fromtable: "orders"
    fromcolumns:
    - "ship_via"
    totable: "shippers"
    tocolumns:
    - "shipper_id"
    jointype: "left"
  - fromtable: "orders"
    fromcolumns:
    - "employee_id"
    totable: "employees"
    tocolumns:
    - "employee_id"
    jointype: "left"
  - fromtable: "order_details"
    fromcolumns:
    - "order_id"
    totable: "orders"
    tocolumns:
    - "order_id"
    jointype: "inner"
  - fromtable: "order_details"
    fromcolumns:
    - "product_id"
    totable: "products"
    tocolumns:
    - "product_id"
    jointype: "inner"
  - fromtable: "territories"
    fromcolumns:
    - "region_id"
    totable: "region"
    tocolumns:
    - "region_id"
    jointype: "inner"
  - fromtable: "products"
    fromcolumns:
    - "supplier_id"
    totable: "suppliers"
    tocolumns:
    - "supplier_id"
    jointype: "left"
  - fromtable: "products"
    fromcolumns:
    - "category_id"
    totable: "categories"
    tocolumns:
    - "category_id"
    jointype: "left"
  - fromtable: "employee_territories"
    fromcolumns:
    - "employee_id"
    totable: "employees"
    tocolumns:
    - "employee_id"
    jointype: "inner"
  - fromtable: "employee_territories"
    fromcolumns:
    - "territory_id"
    totable: "territories"
    tocolumns:
    - "territory_id"
    jointype: "inner"
  sql:output: "src/main/scala/org/apache/nlpcraft/examples/sql/sql_model.yaml"
  sql:timestamp: "2020-03-21T11:50:54.433Z"
  sql:schema: "PUBLIC"
macros:
- name: "<OF>"
  macro: "{of|for|per}"
- name: "<ID>"
  macro: "{unique|_} {id|identifier}"
elements:
- id: "tbl:region"
  groups:
  - "table"
  synonyms:
  - "region"
  metadata:
    sql:name: "region"
    sql:defaultselect:
    - "region_id"
    - "region_description"
    sql:defaultsort:
    - "region.region_id#desc"
  description: "Auto-generated from 'region' table."
- id: "tbl:orders"
  groups:
  - "table"
  synonyms:
  - "orders"
  metadata:
    sql:name: "orders"
    sql:defaultselect:
    - "order_id"
    - "order_date"
    - "required_date"
    sql:defaultsort:
    - "orders.order_id#desc"
    sql:extratables:
    - "customers"
    - "shippers"
    - "employees"
    sql:defaultdate: "orders.order_date"
  description: "Auto-generated from 'orders' table."
- id: "tbl:suppliers"
  groups:
  - "table"
  synonyms:
  - "suppliers"
  metadata:
    sql:name: "suppliers"
    sql:defaultselect:
    - "supplier_id"
    - "company_name"
    - "contact_name"
    sql:defaultsort:
    - "suppliers.supplier_id#desc"
  description: "Auto-generated from 'suppliers' table."
- id: "tbl:order_details"
  groups:
  - "table"
  synonyms:
  - "{order_details|order details}"
  metadata:
    sql:name: "order_details"
    sql:defaultselect:
    - "unit_price"
    - "quantity"
    - "discount"
    sql:defaultsort:
    - "order_details.order_id#desc"
    - "order_details.product_id#desc"
    sql:extratables:
    - "orders"
    - "products"
    sql:defaultdate: "orders.order_date"
  description: "Auto-generated from 'order_details' table."
- id: "tbl:territories"
  groups:
  - "table"
  synonyms:
  - "territories"
  metadata:
    sql:name: "territories"
    sql:defaultselect:
    - "territory_id"
    - "territory_description"
    - "region_id"
    sql:defaultsort:
    - "territories.territory_id#desc"
    sql:extratables:
    - "region"
  description: "Auto-generated from 'territories' table."
- id: "tbl:shippers"
  groups:
  - "table"
  synonyms:
  - "shippers"
  metadata:
    sql:name: "shippers"
    sql:defaultselect:
    - "shipper_id"
    - "company_name"
    - "phone"
    sql:defaultsort:
    - "shippers.shipper_id#desc"
  description: "Auto-generated from 'shippers' table."
- id: "tbl:products"
  groups:
  - "table"
  synonyms:
  - "products"
  metadata:
    sql:name: "products"
    sql:defaultselect:
    - "product_id"
    - "product_name"
    - "quantity_per_unit"
    sql:defaultsort:
    - "products.product_id#desc"
    sql:extratables:
    - "suppliers"
    - "categories"
    - "order_details"
  description: "Auto-generated from 'products' table."
- id: "tbl:employee_territories"
  groups:
  - "table"
  synonyms:
  - "{employee_territories|employee territories}"
  metadata:
    sql:name: "employee_territories"
    sql:defaultselect:
    - "employee_id"
    - "territory_id"
    sql:defaultsort:
    - "employee_territories.employee_id#desc"
    - "employee_territories.territory_id#desc"
    sql:extratables:
    - "employees"
    - "territories"
    sql:defaultdate: "employees.birth_date"
  description: "Auto-generated from 'employee_territories' table."
- id: "tbl:customers"
  groups:
  - "table"
  synonyms:
  - "customers"
  metadata:
    sql:name: "customers"
    sql:defaultselect:
    - "customer_id"
    - "company_name"
    - "contact_name"
    sql:defaultsort:
    - "customers.customer_id#desc"
  description: "Auto-generated from 'customers' table."
- id: "tbl:categories"
  groups:
  - "table"
  synonyms:
  - "categories"
  metadata:
    sql:name: "categories"
    sql:defaultselect:
    - "category_id"
    - "category_name"
    - "description"
    sql:defaultsort:
    - "categories.category_id#desc"
  description: "Auto-generated from 'categories' table."
- id: "tbl:employees"
  groups:
  - "table"
  synonyms:
  - "employees"
  metadata:
    sql:name: "employees"
    sql:defaultselect:
    - "employee_id"
    - "last_name"
    - "first_name"
    sql:defaultsort:
    - "employees.employee_id#desc"
  description: "Auto-generated from 'employees' table."
- id: "col:region_region_id"
  groups:
  - "column"
  synonyms:
  - "{region_id|region <ID>}"
  - "region {region_id|region <ID>}"
  - "{region_id|region <ID>} <OF> region"
  metadata:
    sql:name: "region_id"
    sql:tablename: "region"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'region.region_id' column."
- id: "col:region_region_description"
  groups:
  - "column"
  synonyms:
  - "{region_description|region description}"
  - "region {region_description|region description}"
  - "{region_description|region description} <OF> region"
  metadata:
    sql:name: "region_description"
    sql:tablename: "region"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'region.region_description' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:orders_order_id"
  groups:
  - "column"
  synonyms:
  - "{order_id|order <ID>}"
  - "orders {order_id|order <ID>}"
  - "{order_id|order <ID>} <OF> orders"
  metadata:
    sql:name: "order_id"
    sql:tablename: "orders"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'orders.order_id' column."
- id: "col:orders_customer_id"
  groups:
  - "column"
  synonyms:
  - "{customer_id|customer <ID>}"
  - "orders {customer_id|customer <ID>}"
  - "{customer_id|customer <ID>} <OF> orders"
  metadata:
    sql:name: "customer_id"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.customer_id' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:orders_employee_id"
  groups:
  - "column"
  synonyms:
  - "{employee_id|employee <ID>}"
  - "orders {employee_id|employee <ID>}"
  - "{employee_id|employee <ID>} <OF> orders"
  metadata:
    sql:name: "employee_id"
    sql:tablename: "orders"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.employee_id' column."
- id: "col:orders_order_date"
  groups:
  - "column"
  synonyms:
  - "{order_date|order date}"
  - "orders {order_date|order date}"
  - "{order_date|order date} <OF> orders"
  metadata:
    sql:name: "order_date"
    sql:tablename: "orders"
    sql:datatype: 91
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.order_date' column."
- id: "col:orders_required_date"
  groups:
  - "column"
  synonyms:
  - "{required_date|required date}"
  - "orders {required_date|required date}"
  - "{required_date|required date} <OF> orders"
  metadata:
    sql:name: "required_date"
    sql:tablename: "orders"
    sql:datatype: 91
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.required_date' column."
- id: "col:orders_shipped_date"
  groups:
  - "column"
  synonyms:
  - "{shipped_date|shipped date}"
  - "orders {shipped_date|shipped date}"
  - "{shipped_date|shipped date} <OF> orders"
  metadata:
    sql:name: "shipped_date"
    sql:tablename: "orders"
    sql:datatype: 91
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.shipped_date' column."
- id: "col:orders_ship_via"
  groups:
  - "column"
  synonyms:
  - "{ship_via|ship via}"
  - "orders {ship_via|ship via}"
  - "{ship_via|ship via} <OF> orders"
  metadata:
    sql:name: "ship_via"
    sql:tablename: "orders"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_via' column."
- id: "col:orders_freight"
  groups:
  - "column"
  synonyms:
  - "freight"
  - "orders freight"
  - "freight <OF> orders"
  metadata:
    sql:name: "freight"
    sql:tablename: "orders"
    sql:datatype: 8
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.freight' column."
- id: "col:orders_ship_name"
  groups:
  - "column"
  synonyms:
  - "{ship_name|ship name}"
  - "orders {ship_name|ship name}"
  - "{ship_name|ship name} <OF> orders"
  metadata:
    sql:name: "ship_name"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:orders_ship_address"
  groups:
  - "column"
  synonyms:
  - "{ship_address|ship address}"
  - "orders {ship_address|ship address}"
  - "{ship_address|ship address} <OF> orders"
  metadata:
    sql:name: "ship_address"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_address' column."
- id: "col:orders_ship_city"
  groups:
  - "column"
  synonyms:
  - "{ship_city|ship city}"
  - "orders {ship_city|ship city}"
  - "{ship_city|ship city} <OF> orders"
  metadata:
    sql:name: "ship_city"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_city' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:orders_ship_region"
  groups:
  - "column"
  synonyms:
  - "{ship_region|ship region}"
  - "orders {ship_region|ship region}"
  - "{ship_region|ship region} <OF> orders"
  metadata:
    sql:name: "ship_region"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_region' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:orders_ship_postal_code"
  groups:
  - "column"
  synonyms:
  - "{ship_postal_code|ship postal code}"
  - "orders {ship_postal_code|ship postal code}"
  - "{ship_postal_code|ship postal code} <OF> orders"
  metadata:
    sql:name: "ship_postal_code"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_postal_code' column."
- id: "col:orders_ship_country"
  groups:
  - "column"
  synonyms:
  - "{ship_country|ship country}"
  - "orders {ship_country|ship country}"
  - "{ship_country|ship country} <OF> orders"
  metadata:
    sql:name: "ship_country"
    sql:tablename: "orders"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'orders.ship_country' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_supplier_id"
  groups:
  - "column"
  synonyms:
  - "{supplier_id|supplier <ID>}"
  - "suppliers {supplier_id|supplier <ID>}"
  - "{supplier_id|supplier <ID>} <OF> suppliers"
  metadata:
    sql:name: "supplier_id"
    sql:tablename: "suppliers"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'suppliers.supplier_id' column."
- id: "col:suppliers_company_name"
  groups:
  - "column"
  synonyms:
  - "{company_name|company name}"
  - "suppliers {company_name|company name}"
  - "{company_name|company name} <OF> suppliers"
  metadata:
    sql:name: "company_name"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'suppliers.company_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_contact_name"
  groups:
  - "column"
  synonyms:
  - "{contact_name|contact name}"
  - "suppliers {contact_name|contact name}"
  - "{contact_name|contact name} <OF> suppliers"
  metadata:
    sql:name: "contact_name"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.contact_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_contact_title"
  groups:
  - "column"
  synonyms:
  - "{contact_title|contact title}"
  - "suppliers {contact_title|contact title}"
  - "{contact_title|contact title} <OF> suppliers"
  metadata:
    sql:name: "contact_title"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.contact_title' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_address"
  groups:
  - "column"
  synonyms:
  - "address"
  - "suppliers address"
  - "address <OF> suppliers"
  metadata:
    sql:name: "address"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.address' column."
- id: "col:suppliers_city"
  groups:
  - "column"
  synonyms:
  - "city"
  - "suppliers city"
  - "city <OF> suppliers"
  metadata:
    sql:name: "city"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.city' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_region"
  groups:
  - "column"
  synonyms:
  - "region"
  - "suppliers region"
  - "region <OF> suppliers"
  metadata:
    sql:name: "region"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.region' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_postal_code"
  groups:
  - "column"
  synonyms:
  - "{postal_code|postal code}"
  - "suppliers {postal_code|postal code}"
  - "{postal_code|postal code} <OF> suppliers"
  metadata:
    sql:name: "postal_code"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.postal_code' column."
- id: "col:suppliers_country"
  groups:
  - "column"
  synonyms:
  - "country"
  - "suppliers country"
  - "country <OF> suppliers"
  metadata:
    sql:name: "country"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.country' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:suppliers_phone"
  groups:
  - "column"
  synonyms:
  - "phone"
  - "suppliers phone"
  - "phone <OF> suppliers"
  metadata:
    sql:name: "phone"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.phone' column."
- id: "col:suppliers_fax"
  groups:
  - "column"
  synonyms:
  - "fax"
  - "suppliers fax"
  - "fax <OF> suppliers"
  metadata:
    sql:name: "fax"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.fax' column."
- id: "col:suppliers_homepage"
  groups:
  - "column"
  synonyms:
  - "homepage"
  - "suppliers homepage"
  - "homepage <OF> suppliers"
  metadata:
    sql:name: "homepage"
    sql:tablename: "suppliers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'suppliers.homepage' column."
- id: "col:order_details_order_id"
  groups:
  - "column"
  synonyms:
  - "{order_id|order <ID>}"
  - "{order_details|order details} {order_id|order <ID>}"
  - "{order_id|order <ID>} <OF> {order_details|order details}"
  metadata:
    sql:name: "order_id"
    sql:tablename: "order_details"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'order_details.order_id' column."
- id: "col:order_details_product_id"
  groups:
  - "column"
  synonyms:
  - "{product_id|product <ID>}"
  - "{order_details|order details} {product_id|product <ID>}"
  - "{product_id|product <ID>} <OF> {order_details|order details}"
  metadata:
    sql:name: "product_id"
    sql:tablename: "order_details"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'order_details.product_id' column."
- id: "col:order_details_unit_price"
  groups:
  - "column"
  synonyms:
  - "{orders|_} {unit_price|unit price}"
  - "{order_details|order details} {unit_price|unit price}"
  - "{unit_price|unit price} <OF> {order_details|order details}"
  metadata:
    sql:name: "unit_price"
    sql:tablename: "order_details"
    sql:datatype: 8
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'order_details.unit_price' column."
- id: "col:order_details_quantity"
  groups:
  - "column"
  synonyms:
  - "{orders|_} quantity"
  - "{order_details|order details} quantity"
  - "quantity <OF> {order_details|order details}"
  metadata:
    sql:name: "quantity"
    sql:tablename: "order_details"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'order_details.quantity' column."
- id: "col:order_details_discount"
  groups:
  - "column"
  synonyms:
  - "{orders|_} discount"
  - "{order_details|order details} discount"
  - "discount <OF> {order_details|order details}"
  metadata:
    sql:name: "discount"
    sql:tablename: "order_details"
    sql:datatype: 8
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'order_details.discount' column."
- id: "col:territories_territory_id"
  groups:
  - "column"
  synonyms:
  - "{territory_id|territory <ID>}"
  - "territories {territory_id|territory <ID>}"
  - "{territory_id|territory <ID>} <OF> territories"
  metadata:
    sql:name: "territory_id"
    sql:tablename: "territories"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'territories.territory_id' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:territories_territory_description"
  groups:
  - "column"
  synonyms:
  - "{territory_description|territory description}"
  - "territories {territory_description|territory description}"
  - "{territory_description|territory description} <OF> territories"
  metadata:
    sql:name: "territory_description"
    sql:tablename: "territories"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'territories.territory_description' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:territories_region_id"
  groups:
  - "column"
  synonyms:
  - "{region_id|region <ID>}"
  - "territories {region_id|region <ID>}"
  - "{region_id|region <ID>} <OF> territories"
  metadata:
    sql:name: "region_id"
    sql:tablename: "territories"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'territories.region_id' column."
- id: "col:shippers_shipper_id"
  groups:
  - "column"
  synonyms:
  - "{shipper_id|shipper <ID>}"
  - "shippers {shipper_id|shipper <ID>}"
  - "{shipper_id|shipper <ID>} <OF> shippers"
  metadata:
    sql:name: "shipper_id"
    sql:tablename: "shippers"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'shippers.shipper_id' column."
- id: "col:shippers_company_name"
  groups:
  - "column"
  synonyms:
  - "{company_name|company name}"
  - "shippers {company_name|company name}"
  - "{company_name|company name} <OF> shippers"
  metadata:
    sql:name: "company_name"
    sql:tablename: "shippers"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'shippers.company_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:shippers_phone"
  groups:
  - "column"
  synonyms:
  - "phone"
  - "shippers phone"
  - "phone <OF> shippers"
  metadata:
    sql:name: "phone"
    sql:tablename: "shippers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'shippers.phone' column."
- id: "col:products_product_id"
  groups:
  - "column"
  synonyms:
  - "{product_id|product <ID>}"
  - "products {product_id|product <ID>}"
  - "{product_id|product <ID>} <OF> products"
  metadata:
    sql:name: "product_id"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'products.product_id' column."
- id: "col:products_product_name"
  groups:
  - "column"
  synonyms:
  - "{product_name|product name}"
  - "products {product_name|product name}"
  - "{product_name|product name} <OF> products"
  metadata:
    sql:name: "product_name"
    sql:tablename: "products"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'products.product_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:products_supplier_id"
  groups:
  - "column"
  synonyms:
  - "{supplier_id|supplier <ID>}"
  - "products {supplier_id|supplier <ID>}"
  - "{supplier_id|supplier <ID>} <OF> products"
  metadata:
    sql:name: "supplier_id"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.supplier_id' column."
- id: "col:products_category_id"
  groups:
  - "column"
  synonyms:
  - "{category_id|category <ID>}"
  - "products {category_id|category <ID>}"
  - "{category_id|category <ID>} <OF> products"
  metadata:
    sql:name: "category_id"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.category_id' column."
- id: "col:products_quantity_per_unit"
  groups:
  - "column"
  synonyms:
  - "{quantity_per_unit|quantity per unit}"
  - "products {quantity_per_unit|quantity per unit}"
  - "{quantity_per_unit|quantity per unit} <OF> products"
  metadata:
    sql:name: "quantity_per_unit"
    sql:tablename: "products"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.quantity_per_unit' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:products_unit_price"
  groups:
  - "column"
  synonyms:
  - "{unit_price|unit price}"
  - "products {unit_price|unit price}"
  - "{unit_price|unit price} <OF> products"
  metadata:
    sql:name: "unit_price"
    sql:tablename: "products"
    sql:datatype: 8
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.unit_price' column."
- id: "col:products_units_in_stock"
  groups:
  - "column"
  synonyms:
  - "{units_in_stock|units in stock}"
  - "products {units_in_stock|units in stock}"
  - "{units_in_stock|units in stock} <OF> products"
  metadata:
    sql:name: "units_in_stock"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.units_in_stock' column."
- id: "col:products_units_on_order"
  groups:
  - "column"
  synonyms:
  - "{units_on_order|units on order}"
  - "products {units_on_order|units on order}"
  - "{units_on_order|units on order} <OF> products"
  metadata:
    sql:name: "units_on_order"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.units_on_order' column."
- id: "col:products_reorder_level"
  groups:
  - "column"
  synonyms:
  - "{reorder_level|reorder level}"
  - "products {reorder_level|reorder level}"
  - "{reorder_level|reorder level} <OF> products"
  metadata:
    sql:name: "reorder_level"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'products.reorder_level' column."
- id: "col:products_discontinued"
  groups:
  - "column"
  synonyms:
  - "discontinued"
  - "products discontinued"
  - "discontinued <OF> products"
  metadata:
    sql:name: "discontinued"
    sql:tablename: "products"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'products.discontinued' column."
- id: "col:employee_territories_employee_id"
  groups:
  - "column"
  synonyms:
  - "{employee_id|employee <ID>}"
  - "{employee_territories|employee territories} {employee_id|employee <ID>}"
  - "{employee_id|employee <ID>} <OF> {employee_territories|employee territories}"
  metadata:
    sql:name: "employee_id"
    sql:tablename: "employee_territories"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'employee_territories.employee_id' column."
- id: "col:employee_territories_territory_id"
  groups:
  - "column"
  synonyms:
  - "{territory_id|territory <ID>}"
  - "{employee_territories|employee territories} {territory_id|territory <ID>}"
  - "{territory_id|territory <ID>} <OF> {employee_territories|employee territories}"
  metadata:
    sql:name: "territory_id"
    sql:tablename: "employee_territories"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'employee_territories.territory_id' column."
- id: "col:customers_customer_id"
  groups:
  - "column"
  synonyms:
  - "{customer_id|customer <ID>}"
  - "customers {customer_id|customer <ID>}"
  - "{customer_id|customer <ID>} <OF> customers"
  metadata:
    sql:name: "customer_id"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'customers.customer_id' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:customers_company_name"
  groups:
  - "column"
  synonyms:
  - "{company_name|company name}"
  - "customers {company_name|company name}"
  - "{company_name|company name} <OF> customers"
  metadata:
    sql:name: "company_name"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'customers.company_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:customers_contact_name"
  groups:
  - "column"
  synonyms:
  - "{contact_name|contact name}"
  - "customers {contact_name|contact name}"
  - "{contact_name|contact name} <OF> customers"
  metadata:
    sql:name: "contact_name"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.contact_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:customers_contact_title"
  groups:
  - "column"
  synonyms:
  - "{contact_title|contact title}"
  - "customers {contact_title|contact title}"
  - "{contact_title|contact title} <OF> customers"
  metadata:
    sql:name: "contact_title"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.contact_title' column."
- id: "col:customers_address"
  groups:
  - "column"
  synonyms:
  - "address"
  - "customers address"
  - "address <OF> customers"
  metadata:
    sql:name: "address"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.address' column."
- id: "col:customers_city"
  groups:
  - "column"
  synonyms:
  - "city"
  - "customers city"
  - "city <OF> customers"
  metadata:
    sql:name: "city"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.city' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:customers_region"
  groups:
  - "column"
  synonyms:
  - "region"
  - "customers region"
  - "region <OF> customers"
  metadata:
    sql:name: "region"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.region' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:customers_postal_code"
  groups:
  - "column"
  synonyms:
  - "{postal_code|postal code}"
  - "customers {postal_code|postal code}"
  - "{postal_code|postal code} <OF> customers"
  metadata:
    sql:name: "postal_code"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.postal_code' column."
- id: "col:customers_country"
  groups:
  - "column"
  synonyms:
  - "country"
  - "customers country"
  - "country <OF> customers"
  metadata:
    sql:name: "country"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.country' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:customers_phone"
  groups:
  - "column"
  synonyms:
  - "phone"
  - "customers phone"
  - "phone <OF> customers"
  metadata:
    sql:name: "phone"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.phone' column."
- id: "col:customers_fax"
  groups:
  - "column"
  synonyms:
  - "fax"
  - "customers fax"
  - "fax <OF> customers"
  metadata:
    sql:name: "fax"
    sql:tablename: "customers"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'customers.fax' column."
- id: "col:categories_category_id"
  groups:
  - "column"
  synonyms:
  - "{category_id|category <ID>}"
  - "categories {category_id|category <ID>}"
  - "{category_id|category <ID>} <OF> categories"
  metadata:
    sql:name: "category_id"
    sql:tablename: "categories"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'categories.category_id' column."
- id: "col:categories_category_name"
  groups:
  - "column"
  synonyms:
  - "{category_name|category name}"
  - "categories {category_name|category name}"
  - "{category_name|category name} <OF> categories"
  metadata:
    sql:name: "category_name"
    sql:tablename: "categories"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'categories.category_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:categories_description"
  groups:
  - "column"
  synonyms:
  - "description"
  - "categories description"
  - "description <OF> categories"
  metadata:
    sql:name: "description"
    sql:tablename: "categories"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'categories.description' column."
- id: "col:employees_employee_id"
  groups:
  - "column"
  synonyms:
  - "{employee_id|employee <ID>}"
  - "employees {employee_id|employee <ID>}"
  - "{employee_id|employee <ID>} <OF> employees"
  metadata:
    sql:name: "employee_id"
    sql:tablename: "employees"
    sql:datatype: 4
    sql:isnullable: false
    sql:ispk: true
  description: "Auto-generated from 'employees.employee_id' column."
- id: "col:employees_last_name"
  groups:
  - "column"
  synonyms:
  - "{last_name|last name}"
  - "employees {last_name|last name}"
  - "{last_name|last name} <OF> employees"
  metadata:
    sql:name: "last_name"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'employees.last_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:employees_first_name"
  groups:
  - "column"
  synonyms:
  - "{first_name|first name}"
  - "employees {first_name|first name}"
  - "{first_name|first name} <OF> employees"
  metadata:
    sql:name: "first_name"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: false
    sql:ispk: false
  description: "Auto-generated from 'employees.first_name' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:employees_title"
  groups:
  - "column"
  synonyms:
  - "title"
  - "employees title"
  - "title <OF> employees"
  metadata:
    sql:name: "title"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.title' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:employees_title_of_courtesy"
  groups:
  - "column"
  synonyms:
  - "{title_of_courtesy|title of courtesy}"
  - "employees {title_of_courtesy|title of courtesy}"
  - "{title_of_courtesy|title of courtesy} <OF> employees"
  metadata:
    sql:name: "title_of_courtesy"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.title_of_courtesy' column."
- id: "col:employees_birth_date"
  groups:
  - "column"
  synonyms:
  - "{birth_date|birth date}"
  - "employees {birth_date|birth date}"
  - "{birth_date|birth date} <OF> employees"
  metadata:
    sql:name: "birth_date"
    sql:tablename: "employees"
    sql:datatype: 91
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.birth_date' column."
- id: "col:employees_hire_date"
  groups:
  - "column"
  synonyms:
  - "{hire_date|hire date}"
  - "employees {hire_date|hire date}"
  - "{hire_date|hire date} <OF> employees"
  metadata:
    sql:name: "hire_date"
    sql:tablename: "employees"
    sql:datatype: 91
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.hire_date' column."
- id: "col:employees_address"
  groups:
  - "column"
  synonyms:
  - "address"
  - "employees address"
  - "address <OF> employees"
  metadata:
    sql:name: "address"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.address' column."
- id: "col:employees_city"
  groups:
  - "column"
  synonyms:
  - "city"
  - "employees city"
  - "city <OF> employees"
  metadata:
    sql:name: "city"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.city' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:employees_region"
  groups:
  - "column"
  synonyms:
  - "region"
  - "employees region"
  - "region <OF> employees"
  metadata:
    sql:name: "region"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.region' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:employees_postal_code"
  groups:
  - "column"
  synonyms:
  - "{postal_code|postal code}"
  - "employees {postal_code|postal code}"
  - "{postal_code|postal code} <OF> employees"
  metadata:
    sql:name: "postal_code"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.postal_code' column."
- id: "col:employees_country"
  groups:
  - "column"
  synonyms:
  - "country"
  - "employees country"
  - "country <OF> employees"
  metadata:
    sql:name: "country"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.country' column."
  valueLoader: "org.apache.nlpcraft.examples.sql.db.SqlValueLoader"
- id: "col:employees_home_phone"
  groups:
  - "column"
  synonyms:
  - "{home_phone|home phone}"
  - "employees {home_phone|home phone}"
  - "{home_phone|home phone} <OF> employees"
  metadata:
    sql:name: "home_phone"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.home_phone' column."
- id: "col:employees_extension"
  groups:
  - "column"
  synonyms:
  - "extension"
  - "employees extension"
  - "extension <OF> employees"
  metadata:
    sql:name: "extension"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.extension' column."
- id: "col:employees_notes"
  groups:
  - "column"
  synonyms:
  - "notes"
  - "employees notes"
  - "notes <OF> employees"
  metadata:
    sql:name: "notes"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.notes' column."
- id: "col:employees_photo_path"
  groups:
  - "column"
  synonyms:
  - "{photo_path|photo path}"
  - "employees {photo_path|photo path}"
  - "{photo_path|photo path} <OF> employees"
  metadata:
    sql:name: "photo_path"
    sql:tablename: "employees"
    sql:datatype: 12
    sql:isnullable: true
    sql:ispk: false
  description: "Auto-generated from 'employees.photo_path' column."
- id: "col"
  groups:
    - "element"
  synonyms:
    - "^^[colName]{has(groups(), 'column') && value() == null}^^"
- id: "col:val"
  groups:
    - "element"
  synonyms:
    - "^^[colVal]{has(groups(), 'column') && value() != null}^^"
- id: "col:num"
  groups:
    - "element"
  synonyms:
    - "^^{id() == 'col' && has(list(4, 8), meta_part('colName', 'sql:datatype'))}^^"
- id: "col:date"
  groups:
    - "element"
  synonyms:
    - "^^{id() == 'col' && meta_part('colName', 'sql:datatype') == 91}^^"
- id: "col:varchar"
  groups:
    - "element"
  synonyms:
    - "^^{id() == 'col' && meta_part('colName', 'sql:datatype') == 12}^^"
- id: "condition:num"
  groups:
    - "condition"
  synonyms:
    - "^^{id() == 'col:num'}^^ ^^{id() == 'nlpcraft:num'}^^ "
- id: "condition:value"
  groups:
    - "condition"
  synonyms:
    - "^^{id() == 'col:varchar'}^^ {is|equal|_} ^^{id() == 'col:val'}^^"
    - "^^{id() == 'col:val'}^^"
- id: "condition:date"
  groups:
    - "condition"
  synonyms:
    - "^^{id() == 'col:date'}^^ ^^{id() == 'nlpcraft:date'}^^"
- id: "sort:best"
  groups:
    - "Sort criteria"
  synonyms:
    - "best {performing|_}"
- id: "sort:worst"
  groups:
    - "Sort criteria"
  synonyms:
    - "{worst|least} {performing|_}"
enabledBuiltInTokens:
  - "nlpcraft:date"
  - "nlpcraft:num"
  - "nlpcraft:relation"
  - "nlpcraft:limit"
  - "nlpcraft:sort"
maxUnknownWords: 2147483647
maxFreeWords: 2147483647
maxSuspiciousWords: 0
minWords: 1
maxWords: 50
minTokens: 0
maxTokens: 50
minNonStopwords: 0
jiggleFactor: 2
maxTotalSynonyms: 2147483647
nonEnglishAllowed: true
notLatinCharsetAllowed: false
swearWordsAllowed: false
noNounsAllowed: true
noUserTokensAllowed: true
dupSynonymsAllowed: true
permutateSynonyms: true