In the following example from an Oracle data source, both the Employee and the Department tables are enabled for full-text search. In the Employee table, the id column is searchable. In the Department table, the id column is searchable and the address column is not included in the model. OData requests will not return data from the address column.

{
    "odata_mapping_v3": {
        "schemas": [
            {
                "name": "Emp",
                "tables": {
                    "Employee": {
                        "ODataAlias": "Employee",
                        "ODataPluralAlias": "Employees",
                        "searchMode": "full-text",
                        "columns": {
                            "id": {
                                "alias": "Test ID",
                                "primaryKeyComponent": 1,
                                "searchable": true,
                                "typeInfo": {
                                    "dataType": "DECIMAL",
                                    "columnSize": 14,
                                    "isGenerated": true,
                                    "isAutoIncrement": true,
                                    "isNullable": false,
                                    "scale": 4
                                }
                            }
                        }
                    },
                    "Department": {
                        "ODataAlias": "Department",
                        "ODataPluralAlias": "Departments",
                        "searchMode": "full-text",
                        "columns": {
                            "id": {
                                "alias": "Test Department",
                                "primaryKeyComponent": 1,
                                "searchable": true,
                                "typeInfo": {
                                    "dataType": "DECIMAL",
                                    "columnSize": 24,
                                    "isGenerated": true,
                                    "isAutoIncrement": true,
                                    "isNullable": false,
                                    "scale": 4
                                }
                            }
                        },
                        "excludedColumns": [
                            "address"
                        ]
                    }
                }
            }
        ]
    }
}