| id: "sql.model.id" |
| name: "SQL-based model." |
| version: "1.0.0-1589887347" |
| description: "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-05-19T11:22:28.461Z" |
| 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" |
| - "customer_id" |
| - "employee_id" |
| sql:defaultsort: |
| - "orders.order_id#desc" |
| sql:extratables: |
| - "customers" |
| - "shippers" |
| - "employees" |
| 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: |
| - "order_id" |
| - "product_id" |
| - "unit_price" |
| sql:defaultsort: |
| - "order_details.order_id#desc" |
| - "order_details.product_id#desc" |
| sql:extratables: |
| - "orders" |
| - "products" |
| 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" |
| - "supplier_id" |
| sql:defaultsort: |
| - "products.product_id#desc" |
| sql:extratables: |
| - "suppliers" |
| - "categories" |
| 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" |
| 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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: |
| - "{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: |
| - "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: |
| - "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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| - 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." |
| 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 |