{"success":true,"message":"./application/models/tables/ap_master_material.js","body":{},"params":{"tbl_name":"ap_master_material"},"queries":{},"data":[{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_master_material","COLUMN_NAME":"material_id","ORDINAL_POSITION":1,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"int","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":0,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"int(11)","COLUMN_KEY":"PRI","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_master_material","COLUMN_NAME":"name","ORDINAL_POSITION":2,"COLUMN_DEFAULT":null,"IS_NULLABLE":"NO","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":255,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"latin1","COLLATION_NAME":"latin1_swedish_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_master_material","COLUMN_NAME":"description","ORDINAL_POSITION":3,"COLUMN_DEFAULT":"'0'","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":255,"CHARACTER_OCTET_LENGTH":255,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"latin1","COLLATION_NAME":"latin1_swedish_ci","COLUMN_TYPE":"varchar(255)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_master_material","COLUMN_NAME":"stock_qty","ORDINAL_POSITION":4,"COLUMN_DEFAULT":"0.00","IS_NULLABLE":"YES","DATA_TYPE":"decimal","CHARACTER_MAXIMUM_LENGTH":null,"CHARACTER_OCTET_LENGTH":null,"NUMERIC_PRECISION":10,"NUMERIC_SCALE":2,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":null,"COLLATION_NAME":null,"COLUMN_TYPE":"decimal(10,2)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null},{"TABLE_CATALOG":"def","TABLE_SCHEMA":"app","TABLE_NAME":"ap_master_material","COLUMN_NAME":"unit_name_short","ORDINAL_POSITION":5,"COLUMN_DEFAULT":"NULL","IS_NULLABLE":"YES","DATA_TYPE":"varchar","CHARACTER_MAXIMUM_LENGTH":50,"CHARACTER_OCTET_LENGTH":50,"NUMERIC_PRECISION":null,"NUMERIC_SCALE":null,"DATETIME_PRECISION":null,"CHARACTER_SET_NAME":"latin1","COLLATION_NAME":"latin1_swedish_ci","COLUMN_TYPE":"varchar(50)","COLUMN_KEY":"","EXTRA":"","PRIVILEGES":"select,insert,update,references","COLUMN_COMMENT":"","IS_GENERATED":"NEVER","GENERATION_EXPRESSION":null}]}