Datadefinition

{ "datadefID": "register", "table": "er_register", "name": "er_register", "headtitle": "er_register", "headdescription": "This is element wast created with K8 Web Kit", "revision": 2, "objectclass": "data_accessclass", "requiredfile": "masterdata\/class_data_accessclass.php", "rightcheck": 1, "key": "registerID", "columns": [ { "Field": "registerID", "Type": "int(10)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "mytype": "INT", "size": "10", "fieldname": "registerID", "myextra": "auto_increment", "noupdate": 1, "noinsert": 1 }, { "Field": "gender", "Type": "tinyint(4)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "TINYINT", "size": "4", "fieldname": "gender", "myextra": "" }, { "Field": "firstname", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "firstname", "myextra": "" }, { "Field": "lastname", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "lastname", "myextra": "" }, { "Field": "street", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "street", "myextra": "" }, { "Field": "country", "Type": "varchar(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "10", "fieldname": "country", "myextra": "" }, { "Field": "code", "Type": "varchar(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "10", "fieldname": "code", "myextra": "" }, { "Field": "city", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "city", "myextra": "" }, { "Field": "phone", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": "", "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "phone", "myextra": "" }, { "Field": "mobile", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": "", "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "mobile", "myextra": "" }, { "Field": "email", "Type": "varchar(250)", "Null": "YES", "Key": "", "Default": "", "Extra": "", "mytype": "VARCHAR", "size": "250", "fieldname": "email", "myextra": "" }, { "Field": "concern", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": "", "Extra": "", "mytype": "VARCHAR", "size": "100", "fieldname": "concern", "myextra": "" }, { "Field": "facebook", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": "", "Extra": "", "mytype": "VARCHAR", "size": "100", "fieldname": "facebook", "myextra": "" }, { "Field": "memo", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "TEXT", "size": "", "fieldname": "memo", "myextra": "" }, { "Field": "status", "Type": "tinyint(4)", "Null": "NO", "Key": "", "Default": "0", "Extra": "", "mytype": "TINYINT", "size": "4", "fieldname": "status", "myextra": "" }, { "Field": "already18", "Type": "tinyint(4)", "Null": "NO", "Key": "", "Default": "0", "Extra": "", "mytype": "TINYINT", "size": "4", "fieldname": "already18", "myextra": "" }, { "Field": "datetimecreated", "Type": "datetime", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "DATETIME", "size": "", "fieldname": "datetimecreated", "myextra": "" }, { "Field": "datetimedone", "Type": "datetime", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "DATETIME", "size": "", "fieldname": "datetimedone", "myextra": "" }, { "Field": "creatorID", "Type": "int(10)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "INT", "size": "10", "fieldname": "creatorID", "myextra": "", "noupdate": 1, "noinsert": 1 } ], "masterdata": { "url_new": "index.php?page=form&datadefID=register&process_action=New&page_mode=2", "url_edit": "index.php?page=form&datadefID=register&process_action=Edit&page_mode=2", "url_detail": "index.php?page=detail&datadefID=register", "url_load": "masterdata\/ProcessData.php?datadefID=register&process_action=Load", "url_save": "masterdata\/ProcessData.php?datadefID=register&process_action=Save", "url_del": "masterdata\/ProcessData.php?datadefID=register&process_action=Del", "url_readfilter": "masterdata\/ProcessData.php", "data_readfilter": { "datadefID": "register", "process_action": "ReadFilter" }, "sql_derived": "SELECT er_register.*,'' as k8select,k8login.username FROM er_register LEFT OUTER JOIN k8login ON er_register.creatorID=k8login.userID WHERE 1=1", "rightuser_create": 0 }, "tabulator": { "columns": [ { "title": "registerID", "field": "registerID", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "gender", "field": "gender", "headerFilter": true, "hozAlign": "right", "width": "80" }, { "title": "firstname", "field": "firstname", "headerFilter": true }, { "title": "lastname", "field": "lastname", "headerFilter": true }, { "title": "street", "field": "street", "headerFilter": true }, { "title": "country", "field": "country", "headerFilter": true }, { "title": "code", "field": "code", "headerFilter": true }, { "title": "city", "field": "city", "headerFilter": true }, { "title": "phone", "field": "phone", "headerFilter": true }, { "title": "mobile", "field": "mobile", "headerFilter": true, "visible": false }, { "title": "email", "field": "email", "headerFilter": true, "visible": false }, { "title": "concern", "field": "concern", "headerFilter": true, "visible": false }, { "title": "facebook", "field": "facebook", "headerFilter": true, "visible": false }, { "title": "memo", "field": "memo", "headerFilter": true, "visible": false }, { "title": "status", "field": "status", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "already18", "field": "already18", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "datetimecreated", "field": "datetimecreated", "headerFilter": "input", "width": 160, "formatter": "datetime", "formatterParams": { "inputFormat": "yyyy-MM-dd HH:mm:ss", "outputFormat": "GLOBALS_tabulatordatetimeformat" }, "visible": false }, { "title": "datetimedone", "field": "datetimedone", "headerFilter": "input", "width": 160, "formatter": "datetime", "formatterParams": { "inputFormat": "yyyy-MM-dd HH:mm:ss", "outputFormat": "GLOBALS_tabulatordatetimeformat" }, "visible": false }, { "title": "creatorID", "field": "creatorID", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "creatorname", "field": "username", "headerFilter": true } ] }, "k8form": { "selector": ".js_dataform", "templatetype": "masterform", "fields": [ { "name": "registerID", "type": "hidden", "label": "registerID" }, { "name": "gender", "type": "number", "label": "gender" }, { "name": "firstname", "type": "text", "label": "firstname", "attributes": { "maxlength": "50" } }, { "name": "lastname", "type": "text", "label": "lastname", "attributes": { "maxlength": "50" } }, { "name": "street", "type": "text", "label": "street", "attributes": { "maxlength": "50" } }, { "name": "country", "type": "text", "label": "country", "attributes": { "maxlength": "10" } }, { "name": "code", "type": "text", "label": "code", "attributes": { "maxlength": "10" } }, { "name": "city", "type": "text", "label": "city", "attributes": { "maxlength": "50" } }, { "name": "phone", "type": "text", "label": "phone", "attributes": { "maxlength": "50" } }, { "name": "mobile", "type": "text", "label": "mobile", "attributes": { "maxlength": "50" } }, { "name": "email", "type": "text", "label": "email", "attributes": { "maxlength": "250" } }, { "name": "concern", "type": "text", "label": "concern", "attributes": { "maxlength": "100" } }, { "name": "facebook", "type": "text", "label": "facebook", "attributes": { "maxlength": "100" } }, { "name": "memo", "tagName": "textarea", "label": "memo" }, { "name": "status", "type": "number", "label": "status" }, { "name": "already18", "type": "number", "label": "already18" }, { "name": "datetimedone", "type": "datetime-local", "label": "datetimedone" } ] } }