Relational Data Tables in Unreal Engine 4

I had an interesting problem with Unreal Engine today. I have a Mech character which I want to attach stuff to, maybe it's segments of armour, or internal components, or weapons and other "stuff". Managing all these attach points and attachments is a pain, so I wanted to codify it in a data model, using Data Assets and Data Tables. This way I can have 100 mechs in the future with different skeletons and varieties of attachments, and codify them entirely as data with a single "MechCharacter".

Given my background as a full stack software engineer, my instinct it to reach for a relational database of sorts, which can:

1. Drive common behaviour with data
2. Tie together multiple data sources
3. Self validate and restrict inputs

This isn't necessarily a complete or cohesive list. I'm writing this quite quickly. But basically I want to build a data model and code which gives me an amazing developer experience while building future assets. No weird bugs because I made a minor typo in one row somewhere!

Lastly, maybe there's even more to this I haven't found yet? Maybe there's a superior way to do it? Maybe a best practices issue I'm going to hit down the line? Let me know in the comments!

So let's say I have these 3 structs and an overarching Data Asset. Each struct will be used to create a Data Table in the editor,

USTRUCT(BlueprintType)struct FAttachPoint : public FTableRowBase{    GENERATED_BODY()public:    UPROPERTY(EditAnywhere, BlueprintReadWrite)        FName Bone;};USTRUCT(BlueprintType)struct FArmorPiece : public FTableRowBase{    GENERATED_BODY()public:    UPROPERTY(EditAnywhere, BlueprintReadWrite)        FName AttachPointRowKey;    UPROPERTY(EditAnywhere, BlueprintReadWrite)        UStaticMesh* Mesh;};USTRUCT(BlueprintType)struct FHardpoint : public FTableRowBase{    GENERATED_BODY()public:    UPROPERTY(EditAnywhere, BlueprintReadWrite)        FName AttachPointRowKey;    UPROPERTY(EditAnywhere, BlueprintReadWrite)        UStaticMesh* Mesh;};UCLASS()class MECHGAME_API UDA_MechDefinition : public UDataAsset{    GENERATED_BODY()public:    UPROPERTY(EditAnywhere, BlueprintReadOnly)        USkeletalMesh* Mesh;    UPROPERTY(EditAnywhere, BlueprintReadOnly)        UDataTable* ArmorTable;    UPROPERTY(EditAnywhere, BlueprintReadOnly)        UDataTable* HardpointsTable;};

This is not ideal, because ArmorPiece and Hardpoint Data Tables just expect a row key of an AttachPoint, but I could make a typo, or rename a row and forget to update other data. What if UE4's editor could restrict those FNames to only keys found in a particular AttachPoint Data Table?

Well UE4 actually has some buried ways to achieve this.

// For a reference to a table which uses a particular struct:UPROPERTY(EditAnywhere, BlueprintReadOnly, meta = (RequiredAssetDataTags = "RowStructure=ArmorPiece"))UDataTable* ArmorTable;

// For a handle to a single row within a table which uses a particular struct:UPROPERTY(EditAnywhere, BlueprintReadWrite, meta = (RowType = "AttachPoint"))FDataTableRowHandle AttachPoint;

The new meta information informs the editor how to provide lists of data, restricted by struct type which makes it harder to make mistakes when configuring data models later.