Datadefinition

If the datadefinition is valid, it will be displayed. Enter a new datadefID and a valid table to generate a new definition.

JSON data definition

{
    "datadefID": "k8components",
    "table": "k8components",
    "name": "k8components",
    "objectclass": "data_accessclass",
    "requiredfile": "masterdata\/class_data_accessclass.php",
    "rightcheck": 1,
    "key": "componentID",
    "columns": [
        {
            "Field": "componentID",
            "Type": "int(10)",
            "Null": "NO",
            "Key": "PRI",
            "Default": null,
            "Extra": "auto_increment",
            "mytype": "INT",
            "size": 10,
            "fieldname": "componentID"
        },
        {
            "Field": "clientID",
            "Type": "int(10)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "INT",
            "size": 10,
            "fieldname": "clientID"
        },
        {
            "Field": "status",
            "Type": "tinyint(4)",
            "Null": "YES",
            "Key": "",
            "Default": "0",
            "Extra": "",
            "mytype": "TINYINT",
            "size": 4,
            "fieldname": "status"
        },
        {
            "Field": "componentnumber",
            "Type": "varchar(20)",
            "Null": "YES",
            "Key": "MUL",
            "Default": null,
            "Extra": "",
            "mytype": "VARCHAR",
            "size": 20,
            "fieldname": "componentnumber"
        },
        {
            "Field": "text1",
            "Type": "varchar(50)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "VARCHAR",
            "size": 50,
            "fieldname": "text1"
        },
        {
            "Field": "text2",
            "Type": "varchar(50)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "VARCHAR",
            "size": 50,
            "fieldname": "text2"
        },
        {
            "Field": "textdimensions",
            "Type": "text",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "TEXT",
            "size": 0,
            "fieldname": "textdimensions"
        },
        {
            "Field": "descriptionlong",
            "Type": "text",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "TEXT",
            "size": 0,
            "fieldname": "descriptionlong"
        },
        {
            "Field": "category",
            "Type": "varchar(20)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "VARCHAR",
            "size": 20,
            "fieldname": "category"
        },
        {
            "Field": "baseunit",
            "Type": "varchar(10)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "VARCHAR",
            "size": 10,
            "fieldname": "baseunit"
        },
        {
            "Field": "salesunit",
            "Type": "varchar(10)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "VARCHAR",
            "size": 10,
            "fieldname": "salesunit"
        },
        {
            "Field": "vatclass",
            "Type": "int(11)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "INT",
            "size": 11,
            "fieldname": "vatclass"
        },
        {
            "Field": "conversionfactorsales",
            "Type": "float",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "FLOAT",
            "size": 0,
            "fieldname": "conversionfactorsales"
        },
        {
            "Field": "price",
            "Type": "float",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "FLOAT",
            "size": 0,
            "fieldname": "price"
        },
        {
            "Field": "creatorID",
            "Type": "int(11)",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "INT",
            "size": 11,
            "fieldname": "creatorID"
        },
        {
            "Field": "datecreated",
            "Type": "datetime",
            "Null": "YES",
            "Key": "",
            "Default": null,
            "Extra": "",
            "mytype": "DATETIME",
            "size": 0,
            "fieldname": "datecreated"
        }
    ],
    "masterdata": {
        "object_mode": 0,
        "add_empty_rec": 0,
        "root": "",
        "url_new": "index.php?page=form&datadefID=k8components&process_action=New&page_mode=1",
        "url_edit": "index.php?page=form&datadefID=k8components&process_action=Edit&page_mode=1",
        "url_getR": "masterdata\/ProcessData.php?datadefID=k8components&process_action=getRecords",
        "url_init": "masterdata\/ProcessData.php?datadefID=k8components&process_action=Init",
        "url_load": "masterdata\/ProcessData.php?datadefID=k8components&process_action=Load",
        "url_save": "masterdata\/ProcessData.php?datadefID=k8components&process_action=Save",
        "url_del": "masterdata\/ProcessData.php?datadefID=k8components&process_action=Del",
        "url_readfilter": "masterdata\/ProcessData.php",
        "data_readfilter": {
            "datadefID": "k8components",
            "process_action": "ReadFilter"
        },
        "rightuser_create": 0
    },
    "tabulator": {
        "columns": [
            {
                "title": "componentID",
                "field": "componentID",
                "headerFilter": true,
                "align": "right",
                "width": "80"
            },
            {
                "title": "status",
                "field": "status",
                "headerFilter": true,
                "align": "right",
                "width": "80"
            },
            {
                "title": "componentnumber",
                "field": "componentnumber",
                "headerFilter": true
            },
            {
                "title": "text1",
                "field": "text1",
                "headerFilter": true
            },
            {
                "title": "text2",
                "field": "text2",
                "headerFilter": true
            },
            {
                "title": "textdimensions",
                "field": "textdimensions",
                "headerFilter": true
            },
            {
                "title": "descriptionlong",
                "field": "descriptionlong",
                "headerFilter": true
            },
            {
                "title": "category",
                "field": "category",
                "headerFilter": true
            },
            {
                "title": "baseunit",
                "field": "baseunit",
                "headerFilter": true
            },
            {
                "title": "salesunit",
                "field": "salesunit",
                "headerFilter": true,
                "visible": false
            },
            {
                "title": "vatclass",
                "field": "vatclass",
                "headerFilter": true,
                "align": "right",
                "width": "80",
                "visible": false
            },
            {
                "title": "conversionfactorsales",
                "field": "conversionfactorsales",
                "headerFilter": true,
                "align": "right",
                "width": "80",
                "formatter": "money",
                "formatterParams": {
                    "decimal": "GLOBALS_decimal_point",
                    "thousand": "GLOBALS_thousands_sep",
                    "precision": 2
                },
                "visible": false
            },
            {
                "title": "price",
                "field": "price",
                "headerFilter": true,
                "align": "right",
                "width": "80",
                "formatter": "money",
                "formatterParams": {
                    "decimal": "GLOBALS_decimal_point",
                    "thousand": "GLOBALS_thousands_sep",
                    "precision": 2
                },
                "visible": false
            },
            {
                "title": "creatorID",
                "field": "creatorID",
                "headerFilter": true,
                "align": "right",
                "width": "80",
                "visible": false
            },
            {
                "title": "datecreated",
                "field": "datecreated",
                "headerFilter": true,
                "width": 160,
                "formatter": "datetime",
                "formatterParams": {
                    "inputFormat": "YYYY-MM-DD hh:mm:ss",
                    "outputFormat": "GLOBALS_tabulatordatetimeformat"
                },
                "visible": false
            }
        ]
    },
    "jsonform": {
        "schema": {
            "componentID": {
                "type": "number",
                "title": "componentID"
            },
            "status": {
                "type": "number",
                "title": "status"
            },
            "componentnumber": {
                "type": "string",
                "title": "componentnumber",
                "maxLength": 20
            },
            "text1": {
                "type": "string",
                "title": "text1",
                "maxLength": 50
            },
            "text2": {
                "type": "string",
                "title": "text2",
                "maxLength": 50
            },
            "textdimensions": {
                "type": "string",
                "title": "textdimensions"
            },
            "descriptionlong": {
                "type": "string",
                "title": "descriptionlong"
            },
            "category": {
                "type": "string",
                "title": "category",
                "maxLength": 20
            },
            "baseunit": {
                "type": "string",
                "title": "baseunit",
                "maxLength": 10
            },
            "salesunit": {
                "type": "string",
                "title": "salesunit",
                "maxLength": 10
            },
            "vatclass": {
                "type": "number",
                "title": "vatclass"
            },
            "conversionfactorsales": {
                "type": "number",
                "title": "conversionfactorsales"
            },
            "price": {
                "type": "number",
                "title": "price"
            }
        }
    },
    "k8form": {
        "selector": ".js_dataform",
        "templatetype": "masterform",
        "fields": [
            {
                "name": "componentID",
                "type": "number",
                "label": "componentID"
            },
            {
                "name": "status",
                "type": "number",
                "label": "status"
            },
            {
                "name": "componentnumber",
                "type": "string",
                "label": "componentnumber",
                "maxLength": 20
            },
            {
                "name": "text1",
                "type": "string",
                "label": "text1",
                "maxLength": 50
            },
            {
                "name": "text2",
                "type": "string",
                "label": "text2",
                "maxLength": 50
            },
            {
                "name": "textdimensions",
                "type": "string",
                "label": "textdimensions"
            },
            {
                "name": "descriptionlong",
                "type": "string",
                "label": "descriptionlong"
            },
            {
                "name": "category",
                "type": "string",
                "label": "category",
                "maxLength": 20
            },
            {
                "name": "baseunit",
                "type": "string",
                "label": "baseunit",
                "maxLength": 10
            },
            {
                "name": "salesunit",
                "type": "string",
                "label": "salesunit",
                "maxLength": 10
            },
            {
                "name": "vatclass",
                "type": "number",
                "label": "vatclass"
            },
            {
                "name": "conversionfactorsales",
                "type": "number",
                "label": "conversionfactorsales"
            },
            {
                "name": "price",
                "type": "number",
                "label": "price"
            }
        ]
    }
}

the copy clipboard method is not supported in IE8 and earlier.