SQL Connection Credentials section of the configuration, and toggle on Database Sync and the optional Database Merge feature.address field in your custom record is blank (your DB doesn't have this info). DB merge allows you to manually edit the record pulled from your database and edit any blank field.localhost or 127.0.0.1. This must be the external IP or domain to reach your database. Learn more about creating an external SQL connection.table name field will contain the name of your database table containing character records.column name field will contain the name of the specific column in the character records table containing data for this row.Character Mapping Column contains a unique ID for the specific character. This unique identifier will also map records in your license and vehicle registration tables back to the character that owns them. Typically, this is a Steam ID or license ID.identifier column to map back to the other characters table.characters table contains our character records. The identifier column contains the character's unique ID, the firstname column contains the characters first name, the lastname character contains the characters last name, etc.Character Mapping Column specified. Again, this is the name of the column in your license/vehicle table containing a unique ID that maps back to the character that owns it.owned_vehicles table contains our stored vehicles. The owner column contains the character's unique ID that owns the vehicle, and the plate column contains the vehicle's license plate.accounts column stores JSON formatted data. For this example, we want to display the bank money in the custom character record.bank.eye_color is a JSON object, with the item property of 0.eye_color.item0 value to an actual color, like "brown".Character Mapping ID column (a column with an ID that directly maps back to the character/civilian record), but may contain a unique ID that maps back to a specific character in another table.vehicle table contains all of the vehicle information, but does not contain a CharacterID column. Instead, the vehicle table contains a VehicleRegistrationID column.VehicleRegistrationId column then maps to the vehicleregistration table. The vehicleregistration table then contains a corresponding CharacterId column, which maps back to the character table.External Key checkbox, as the vehicle table's VehicleId needs to be mapped to an external table to be turned into the proper characterId.vehicleregistration) and the external key's column CharacterId.JSON Column and set the column name to accounts as this is the column in our character table that contains the JSON data.bank.drive_license in your database is converted to Driver's License.tinyint column types may be displayed as numerical values 0 and 1 but be read as True and False by Sonoran CAD.
Instead of mapping the "Database Vaue" as 0 or 1 you will need to map False and True.taxi job value can be automatically converted to Taxi Driver in DB Sync records, and the cardealer jon can be automatically converted to Car Dealer.Modify on the job field's friendly mapping.taxi to a friendly value of Taxi Driver and the raw db value of cardealer to Car Dealer.Import > CSV > Select your downloaded Google spreadsheetImport > JSON > Paste your JSON formatted structurejob field in our character's table.Job field has been added. We can map this new field to our database as any other field.