CREATE TABLE MyappType (
  Id INTEGER NOT NULL UNIQUE
  # ...
);
CREATE TABLE AvailableMyapp (
  MyappTypeId INTEGER NOT NULL,
  FOREIGN KEY(MyappTypeId) REFERENCES MyappType(Id)
  # ...
);