SQL Connection Credentialssection of the configuration, and toggle on Database Sync and the optional Database Merge feature.
addressfield 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.
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 namefield will contain the name of your database table containing character records.
column namefield will contain the name of the specific column in the character records table containing data for this row.
Character Mapping Columncontains 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.
identifiercolumn to map back to the other characters table.
characterstable contains our character records. The
identifiercolumn contains the character's unique ID, the
firstnamecolumn contains the characters first name, the
lastnamecharacter contains the characters last name, etc.
Character Mapping Columnspecified. 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_vehiclestable contains our stored vehicles. The
ownercolumn contains the character's unique ID that owns the vehicle, and the
platecolumn contains the vehicle's license plate.
accountscolumn stores JSON formatted data. For this example, we want to display the
bankmoney in the custom character record.
eye_coloris a JSON object, with the
Character Mapping IDcolumn (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.
vehicletable contains all of the vehicle information, but does not contain a
CharacterIDcolumn. Instead, the
vehicletable contains a
VehicleRegistrationIdcolumn then maps to the
vehicleregistrationtable then contains a corresponding
CharacterIdcolumn, which maps back to the
External Keycheckbox, as the
VehicleIdneeds to be mapped to an external table to be turned into the proper
vehicleregistration) and the external key's column
JSON Columnand set the column name to
accountsas this is the column in our character table that contains the JSON data.
drive_licensein your database is converted to
taxijob value can be automatically converted to
Taxi Driverin DB Sync records, and the
cardealerjon can be automatically converted to
jobfield's friendly mapping.
taxito a friendly value of
Taxi Driverand the raw db value of
CSV> Select your downloaded Google spreadsheet
JSON> Paste your JSON formatted structure
jobfield in our character's table.
Jobfield has been added. We can map this new field to our database as any other field.