List of tables

Currently, SQLite Bedrock Packs package does’t support some of the types of objects that you can find in Minecraft resourece packs and behavior packs. The following tables are the ones that are currently supported.

Attachable

CREATE TABLE Attachable (
    Attachable_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    AttachableFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (AttachableFile_fk) REFERENCES AttachableFile (AttachableFile_pk) ON DELETE CASCADE
)

AttachableAnimationControllerField

CREATE TABLE AttachableAnimationControllerField (
    AttachableAnimationControllerField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

AttachableAnimationField

CREATE TABLE AttachableAnimationField (
    AttachableAnimationField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

AttachableFile

CREATE TABLE AttachableFile (
    AttachableFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

AttachableGeometryField

CREATE TABLE AttachableGeometryField (
    AttachableGeometryField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

AttachableItemField

CREATE TABLE AttachableItemField (
    AttachableItemField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    condition TEXT,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

AttachableMaterialField

CREATE TABLE AttachableMaterialField (
    AttachableMaterialField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

AttachableRenderControllerField

CREATE TABLE AttachableRenderControllerField (
    AttachableRenderControllerField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    condition TEXT,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

AttachableTextureField

CREATE TABLE AttachableTextureField (
    AttachableTextureField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Attachable_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Attachable_fk) REFERENCES Attachable (Attachable_pk) ON DELETE CASCADE
)

BehaviorPack

CREATE TABLE BehaviorPack (
    BehaviorPack_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    path Path NOT NULL
)

BpAnimation

CREATE TABLE BpAnimation (
    BpAnimation_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpAnimationFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (BpAnimationFile_fk) REFERENCES BpAnimationFile (BpAnimationFile_pk) ON DELETE CASCADE
)

BpAnimationController

CREATE TABLE BpAnimationController (
    BpAnimationController_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpAnimationControllerFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (BpAnimationControllerFile_fk) REFERENCES BpAnimationControllerFile (BpAnimationControllerFile_pk) ON DELETE CASCADE
)

BpAnimationControllerFile

CREATE TABLE BpAnimationControllerFile (
    BpAnimationControllerFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

BpAnimationFile

CREATE TABLE BpAnimationFile (
    BpAnimationFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

BpBlock

CREATE TABLE BpBlock (
    BpBlock_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpBlockFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (BpBlockFile_fk) REFERENCES BpBlockFile (BpBlockFile_pk) ON DELETE CASCADE
)

BpBlockFile

CREATE TABLE BpBlockFile (
    BpBlockFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

BpBlockGeometryField

CREATE TABLE BpBlockGeometryField (
    BpBlockGeometryField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpBlock_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (BpBlock_fk) REFERENCES BpBlock (BpBlock_pk) ON DELETE CASCADE
)

BpBlockLootField

CREATE TABLE BpBlockLootField (
    BpBlockLootField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpBlock_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (BpBlock_fk) REFERENCES BpBlock (BpBlock_pk) ON DELETE CASCADE
)

BpBlockMaterialInstancesField

CREATE TABLE BpBlockMaterialInstancesField (
    BpBlockMaterialInstancesField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpBlock_fk INTEGER NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (BpBlock_fk) REFERENCES BpBlock (BpBlock_pk) ON DELETE CASCADE
)

BpBlockMaterialInstancesFieldInstance

CREATE TABLE BpBlockMaterialInstancesFieldInstance (
    BpBlockMaterialInstancesFieldInstance_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpBlockMaterialInstancesField_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    texture TEXT NOT NULL,
    renderMethod TEXT NOT NULL,
    FOREIGN KEY (BpBlockMaterialInstancesField_fk) REFERENCES BpBlockMaterialInstancesField (BpBlockMaterialInstancesField_pk) ON DELETE CASCADE
)

BpItem

CREATE TABLE BpItem (
    BpItem_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BpItemFile_fk INTEGER NOT NULL,
    parserVersion TEXT NOT NULL,
    identifier TEXT NOT NULL,
    texture TEXT,
    FOREIGN KEY (BpItemFile_fk) REFERENCES BpItemFile (BpItemFile_pk) ON DELETE CASCADE,
    FOREIGN KEY (parserVersion) REFERENCES BpItemParserversionEnum (value)
)

BpItemFile

CREATE TABLE BpItemFile (
    BpItemFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

BpItemParserversionEnum

CREATE TABLE BpItemParserversionEnum (
    value TEXT PRIMARY KEY
)

ClientEntity

CREATE TABLE ClientEntity (
    ClientEntity_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntityFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (ClientEntityFile_fk) REFERENCES ClientEntityFile (ClientEntityFile_pk) ON DELETE CASCADE
)

ClientEntityAnimationControllerField

CREATE TABLE ClientEntityAnimationControllerField (
    ClientEntityAnimationControllerField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntity_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (ClientEntity_fk) REFERENCES ClientEntity (ClientEntity_pk) ON DELETE CASCADE
)

ClientEntityAnimationField

CREATE TABLE ClientEntityAnimationField (
    ClientEntityAnimationField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntity_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (ClientEntity_fk) REFERENCES ClientEntity (ClientEntity_pk) ON DELETE CASCADE
)

ClientEntityFile

CREATE TABLE ClientEntityFile (
    ClientEntityFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

ClientEntityGeometryField

CREATE TABLE ClientEntityGeometryField (
    ClientEntityGeometryField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntity_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (ClientEntity_fk) REFERENCES ClientEntity (ClientEntity_pk) ON DELETE CASCADE
)

ClientEntityMaterialField

CREATE TABLE ClientEntityMaterialField (
    ClientEntityMaterialField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntity_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (ClientEntity_fk) REFERENCES ClientEntity (ClientEntity_pk) ON DELETE CASCADE
)

ClientEntityRenderControllerField

CREATE TABLE ClientEntityRenderControllerField (
    ClientEntityRenderControllerField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntity_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    condition TEXT,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (ClientEntity_fk) REFERENCES ClientEntity (ClientEntity_pk) ON DELETE CASCADE
)

ClientEntityTextureField

CREATE TABLE ClientEntityTextureField (
    ClientEntityTextureField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ClientEntity_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (ClientEntity_fk) REFERENCES ClientEntity (ClientEntity_pk) ON DELETE CASCADE
)

Entity

CREATE TABLE Entity (
    Entity_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    EntityFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (EntityFile_fk) REFERENCES EntityFile (EntityFile_pk) ON DELETE CASCADE
)

EntityFile

CREATE TABLE EntityFile (
    EntityFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

EntityLootField

CREATE TABLE EntityLootField (
    EntityLootField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Entity_fk INTEGER NOT NULL,
    componentType TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Entity_fk) REFERENCES Entity (Entity_pk) ON DELETE CASCADE,
    FOREIGN KEY (componentType) REFERENCES EntityLootFieldComponenttypeEnum (value)
)

EntityLootFieldComponenttypeEnum

CREATE TABLE EntityLootFieldComponenttypeEnum (
    value TEXT PRIMARY KEY
)

EntitySpawnEggField

CREATE TABLE EntitySpawnEggField (
    EntitySpawnEggField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Entity_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (Entity_fk) REFERENCES Entity (Entity_pk) ON DELETE CASCADE
)

EntityTradeField

CREATE TABLE EntityTradeField (
    EntityTradeField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    Entity_fk INTEGER NOT NULL,
    componentType TEXT NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (Entity_fk) REFERENCES Entity (Entity_pk) ON DELETE CASCADE,
    FOREIGN KEY (componentType) REFERENCES EntityTradeFieldComponenttypeEnum (value)
)

EntityTradeFieldComponenttypeEnum

CREATE TABLE EntityTradeFieldComponenttypeEnum (
    value TEXT PRIMARY KEY
)

Geometry

CREATE TABLE Geometry (
    Geometry_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    GeometryFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    parent TEXT,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (GeometryFile_fk) REFERENCES GeometryFile (GeometryFile_pk) ON DELETE CASCADE
)

GeometryFile

CREATE TABLE GeometryFile (
    GeometryFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

LootTable

CREATE TABLE LootTable (
    LootTable_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    LootTableFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (LootTableFile_fk) REFERENCES LootTableFile (LootTableFile_pk) ON DELETE CASCADE
)

LootTableFile

CREATE TABLE LootTableFile (
    LootTableFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

LootTableItemField

CREATE TABLE LootTableItemField (
    LootTableItemField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    LootTable_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (LootTable_fk) REFERENCES LootTable (LootTable_pk) ON DELETE CASCADE
)

LootTableItemSpawnEggReferenceField

CREATE TABLE LootTableItemSpawnEggReferenceField (
    LootTableItemSpawnEggReferenceField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    LootTableItemField_fk INTEGER NOT NULL,
    connectionType TEXT NOT NULL,
    entityIdentifier TEXT NOT NULL,
    spawnEggIdentifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (LootTableItemField_fk) REFERENCES LootTableItemField (LootTableItemField_pk) ON DELETE CASCADE,
    FOREIGN KEY (connectionType) REFERENCES LootTableItemSpawnEggReferenceFieldConnectiontypeEnum (value)
)

LootTableItemSpawnEggReferenceFieldConnectiontypeEnum

CREATE TABLE LootTableItemSpawnEggReferenceFieldConnectiontypeEnum (
    value TEXT PRIMARY KEY
)

LootTableLootTableField

CREATE TABLE LootTableLootTableField (
    LootTableLootTableField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    LootTable_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (LootTable_fk) REFERENCES LootTable (LootTable_pk) ON DELETE CASCADE
)

Particle

CREATE TABLE Particle (
    Particle_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ParticleFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    material TEXT,
    texture TEXT,
    FOREIGN KEY (ParticleFile_fk) REFERENCES ParticleFile (ParticleFile_pk) ON DELETE CASCADE
)

ParticleFile

CREATE TABLE ParticleFile (
    ParticleFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

RenderController

CREATE TABLE RenderController (
    RenderController_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RenderControllerFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RenderControllerFile_fk) REFERENCES RenderControllerFile (RenderControllerFile_pk) ON DELETE CASCADE
)

RenderControllerFile

CREATE TABLE RenderControllerFile (
    RenderControllerFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

RenderControllerGeometryField

CREATE TABLE RenderControllerGeometryField (
    RenderControllerGeometryField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RenderController_fk INTEGER NOT NULL,
    ownerArray TEXT,
    inOwnerArrayJsonPath TEXT,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RenderController_fk) REFERENCES RenderController (RenderController_pk) ON DELETE CASCADE
)

RenderControllerMaterialsField

CREATE TABLE RenderControllerMaterialsField (
    RenderControllerMaterialsField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RenderController_fk INTEGER NOT NULL,
    ownerArray TEXT,
    inOwnerArrayJsonPath TEXT,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    boneNamePattern TEXT,
    FOREIGN KEY (RenderController_fk) REFERENCES RenderController (RenderController_pk) ON DELETE CASCADE
)

RenderControllerTexturesField

CREATE TABLE RenderControllerTexturesField (
    RenderControllerTexturesField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RenderController_fk INTEGER NOT NULL,
    ownerArray TEXT,
    inOwnerArrayJsonPath TEXT,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RenderController_fk) REFERENCES RenderController (RenderController_pk) ON DELETE CASCADE
)

ResourcePack

CREATE TABLE ResourcePack (
    ResourcePack_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    path Path NOT NULL
)

RpAnimation

CREATE TABLE RpAnimation (
    RpAnimation_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpAnimationFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RpAnimationFile_fk) REFERENCES RpAnimationFile (RpAnimationFile_pk) ON DELETE CASCADE
)

RpAnimationController

CREATE TABLE RpAnimationController (
    RpAnimationController_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpAnimationControllerFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RpAnimationControllerFile_fk) REFERENCES RpAnimationControllerFile (RpAnimationControllerFile_pk) ON DELETE CASCADE
)

RpAnimationControllerFile

CREATE TABLE RpAnimationControllerFile (
    RpAnimationControllerFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

RpAnimationControllerParticleEffect

CREATE TABLE RpAnimationControllerParticleEffect (
    RpAnimationControllerParticleEffect_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpAnimationController_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RpAnimationController_fk) REFERENCES RpAnimationController (RpAnimationController_pk) ON DELETE CASCADE
)

RpAnimationControllerSoundEffect

CREATE TABLE RpAnimationControllerSoundEffect (
    RpAnimationControllerSoundEffect_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpAnimationController_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RpAnimationController_fk) REFERENCES RpAnimationController (RpAnimationController_pk) ON DELETE CASCADE
)

RpAnimationFile

CREATE TABLE RpAnimationFile (
    RpAnimationFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

RpAnimationParticleEffect

CREATE TABLE RpAnimationParticleEffect (
    RpAnimationParticleEffect_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpAnimation_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RpAnimation_fk) REFERENCES RpAnimation (RpAnimation_pk) ON DELETE CASCADE
)

RpAnimationSoundEffect

CREATE TABLE RpAnimationSoundEffect (
    RpAnimationSoundEffect_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpAnimation_fk INTEGER NOT NULL,
    shortName TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (RpAnimation_fk) REFERENCES RpAnimation (RpAnimation_pk) ON DELETE CASCADE
)

RpItem

CREATE TABLE RpItem (
    RpItem_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    RpItemFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    icon TEXT,
    FOREIGN KEY (RpItemFile_fk) REFERENCES RpItemFile (RpItemFile_pk) ON DELETE CASCADE
)

RpItemFile

CREATE TABLE RpItemFile (
    RpItemFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

SoundDefinition

CREATE TABLE SoundDefinition (
    SoundDefinition_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    SoundDefinitionsFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (SoundDefinitionsFile_fk) REFERENCES SoundDefinitionsFile (SoundDefinitionsFile_pk) ON DELETE CASCADE
)

SoundDefinitionSoundField

CREATE TABLE SoundDefinitionSoundField (
    SoundDefinitionSoundField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    SoundDefinition_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (SoundDefinition_fk) REFERENCES SoundDefinition (SoundDefinition_pk) ON DELETE CASCADE
)

SoundDefinitionsFile

CREATE TABLE SoundDefinitionsFile (
    SoundDefinitionsFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

SoundFile

CREATE TABLE SoundFile (
    SoundFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

TerrainTexture

CREATE TABLE TerrainTexture (
    TerrainTexture_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    TerrainTextureFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (TerrainTextureFile_fk) REFERENCES TerrainTextureFile (TerrainTextureFile_pk) ON DELETE CASCADE
)

TerrainTextureFile

CREATE TABLE TerrainTextureFile (
    TerrainTextureFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

TerrainTextureVariation

CREATE TABLE TerrainTextureVariation (
    TerrainTextureVariation_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    TerrainTexture_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    jsonPath Path NOT NULL,
    variantIndex INTEGER,
    variationIndex INTEGER,
    weight INTEGER,
    tintColor TEXT,
    overlayColor TEXT,
    FOREIGN KEY (TerrainTexture_fk) REFERENCES TerrainTexture (TerrainTexture_pk) ON DELETE CASCADE
)

TextureFile

CREATE TABLE TextureFile (
    TextureFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    ResourcePack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (ResourcePack_fk) REFERENCES ResourcePack (ResourcePack_pk) ON DELETE CASCADE
)

TradeTable

CREATE TABLE TradeTable (
    TradeTable_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    TradeTableFile_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    FOREIGN KEY (TradeTableFile_fk) REFERENCES TradeTableFile (TradeTableFile_pk) ON DELETE CASCADE
)

TradeTableFile

CREATE TABLE TradeTableFile (
    TradeTableFile_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    BehaviorPack_fk INTEGER NOT NULL,
    path Path NOT NULL,
    FOREIGN KEY (BehaviorPack_fk) REFERENCES BehaviorPack (BehaviorPack_pk) ON DELETE CASCADE
)

TradeTableItemField

CREATE TABLE TradeTableItemField (
    TradeTableItemField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    TradeTable_fk INTEGER NOT NULL,
    identifier TEXT NOT NULL,
    dataValue INTEGER,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (TradeTable_fk) REFERENCES TradeTable (TradeTable_pk) ON DELETE CASCADE
)

TradeTableItemSpawnEggReferenceField

CREATE TABLE TradeTableItemSpawnEggReferenceField (
    TradeTableItemSpawnEggReferenceField_pk INTEGER PRIMARY KEY AUTOINCREMENT,
    TradeTableItemField_fk INTEGER NOT NULL,
    entityIdentifier TEXT NOT NULL,
    spawnEggIdentifier TEXT NOT NULL,
    jsonPath TEXT NOT NULL,
    FOREIGN KEY (TradeTableItemField_fk) REFERENCES TradeTableItemField (TradeTableItemField_pk) ON DELETE CASCADE
)