data.js 2.7 KB

1
  1. var columns = [{ "isInPrimaryKey": true, "isInForeignKey": false, "isNullable": false, "inputType": "digits", "isAutoKey": true, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "ProductID", "text": "ProductID", "type": "column", "icon": "images/table_key.png" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": false, "inputType": "text", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "ProductName", "text": "ProductName" }, { "isInPrimaryKey": false, "isInForeignKey": true, "isNullable": true, "inputType": "digits", "isAutoKey": false, "sourceTableName": "Suppliers", "sourceTableIDField": "SupplierID", "sourceTableTextField": "CompanyName", "name": "SupplierID", "text": "SupplierID" }, { "isInPrimaryKey": false, "isInForeignKey": true, "isNullable": true, "inputType": "digits", "isAutoKey": false, "sourceTableName": "Categories", "sourceTableIDField": "CategoryID", "sourceTableTextField": "CategoryName", "name": "CategoryID", "text": "CategoryID" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": true, "inputType": "text", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "QuantityPerUnit", "text": "QuantityPerUnit" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": true, "inputType": "number", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "UnitPrice", "text": "UnitPrice" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": true, "inputType": "digits", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "UnitsInStock", "text": "UnitsInStock" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": true, "inputType": "digits", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "UnitsOnOrder", "text": "UnitsOnOrder" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": true, "inputType": "digits", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "ReorderLevel", "text": "ReorderLevel" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": false, "inputType": "checkbox", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "Discontinued", "text": "Discontinued" }, { "isInPrimaryKey": false, "isInForeignKey": false, "isNullable": true, "inputType": "text", "isAutoKey": false, "sourceTableName": "", "sourceTableIDField": "", "sourceTableTextField": "", "name": "EAN13", "text": "EAN13"}];