{
    "keyColumn": "profile_id",
    "detailHeaderColumnPrefix": "User Profiles: ",
    "detailHeaderColumns": [
        "user_email"
    ],
    "orderBy": {
        "profile_id": "DESC"
    },
    "listColumns": [
	"profile_id",
        "user_id",
        "user_email",
        "user_phone",
        "user_phone_extension"        
    ],
    "showColumns": [
        "profile_id",
        "user_id",
        "user_email",
        "user_phone",
        "user_phone_extension"
        
    ],
    "detailColumns": [
	"profile_id",
        "user_id",
        "user_email",
        "user_phone",
        "user_phone_extension"      
    ],
    "columns": {
        "profile_id": {
            "name": "Profile ID",
            "sortable": "true",
            "searchable": "true",
            "editoptions": {
                "type": "hidden"
            }
        },
        "user_email": {
            "name": "User Email",
            "sortable": "true"           
        },
        "user_id": {
            "name": "User Name",
            "sortable": "true",
            "external": "true",
            "externalOptions": {
                "externalTable": "tbl_users",
                "externalColumn": "user_id",
                "externalShowColumn":"user_lname"
            }           
        },
        "user_phone": {
            "name": "Phone",
            "searchable": "true",
            "sortable": "true",
            "editoptions": {
                "type": "textbox",
                "label": "Phone Number",
                "class": "textbox",
                "validations": [
                    "required"
                ]
            }
        },
        "user_phone_extension": {
            "name": "Phone Extension",
            "searchable": "true",
            "sortable": "true",
            "editoptions": {
                "type": "textbox",
                "label": "Phone Extension",
                "class": "textbox",
                "validations": [
                    "required"
                ]
            }
        },
        
       
	 
    "opertations": [
	"add",
        "view",
        "edit",
        "delete"
    ],
	"report": {
        "reportTitle": "User Profiles",
        "columns": [
                    "profile_id",
                    "user_email",
                    "user_phone",
                    "user_phone_extension",
                    "User Name"
                ]
    }
}
}
