Sharing a with foreign Keys issue

[StewartLynch]

I am working with the CKSyncEngine now and am trying to share a property with a user.
A property has a one to many relationship with rooms and rooms has a one to many relationship with items.
When sharing, the Property and the rooms are all shared, but I do not get any of the items.
Here is how my tables are created in the migration step.
Am I missing something here? Items can only belong to one room and a room to a single property
However, though each item can only have a single category, these categories be assigned to items in rooms that belong to other properties too. Is it the Category that is preventing the items from being shared? Here is how my schema is defined.

migrator.registerMigration("Create tables") { db in
    try #sql("""
        CREATE TABLE properties (
            id TEXT PRIMARY KEY NOT NULL ON CONFLICT REPLACE DEFAULT (uuid()),
            name TEXT NOT NULL DEFAULT '',
            address TEXT DEFAULT ('') NOT NULL) 
        STRICT
        """)
    .execute(db)
    try #sql("""
        CREATE TABLE rooms (
            id TEXT PRIMARY KEY NOT NULL ON CONFLICT REPLACE DEFAULT (uuid()),
            name TEXT NOT NULL DEFAULT '',
            location TEXT NOT NULL DEFAULT '',
            propertyID TEXT NOT NULL REFERENCES properties(id) ON DELETE CASCADE
        ) STRICT
        """)
    .execute(db)
    try #sql("""
        CREATE TABLE items (
          id TEXT PRIMARY KEY NOT NULL ON CONFLICT REPLACE DEFAULT (uuid()),
          name text NOT NULL DEFAULT(''),
          brand text NOT NULL DEFAULT(''),
          cost integer NOT NULL DEFAULT(0),
          description text NOT NULL DEFAULT(''),
          isArchived integer NOT NULL DEFAULT(0),
          purchaseDate text,
          archiveDate text,
          archiveNote text NOT NULL DEFAULT(''),
          roomID TEXT NOT NULL REFERENCES rooms(id) ON DELETE CASCADE,
          categoryID text REFERENCES categories(id) ON DELETE SET NULL
        ) STRICT
        """)
    .execute(db)
    try #sql("""
        CREATE TABLE categories (
          id TEXT PRIMARY KEY NOT NULL ON CONFLICT REPLACE DEFAULT (uuid()),
          name text NOT NULL DEFAULT(''),
          hexColor text NOT NULL DEFAULT('0000ff')
        ) STRICT
        """)
    .execute(db)
}```

[davidrothera]

Yes it is the category which is causing the issue here.

SyncEngine code will ignore any types with multiple FKs.

The Tag/TagList tables from the examples would be a good example of a similar model. To unblock you would need to have a look-through table such as ItemCategories and then have that have FK to Item and Category

[StewartLynch]

OK. I am converting this to a many to many relationship and will restrict the number of categories to 1 only so the UI will remain the same. Thanks