如何在Xamari表单中使用SQLite创建到同一个表的两个外键

using SQLite;

namespace YourAppName.Models
{
    public class Table1Model
    {
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }

        public string Name { get; set; }
        
        [ForeignKey(typeof(Table2Model))]
        public int Table2Id1 { get; set; }
        
        [ForeignKey(typeof(Table2Model))]
        public int Table2Id2 { get; set; }
    }
}

using SQLite;

namespace YourAppName.Models
{
    public class Table2Model
    {
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }

        public string Description { get; set; }
    }
}

using SQLite;
using YourAppName.Models;

namespace YourAppName.Services
{
    public class DatabaseService
    {
        private SQLiteConnection _database;

        public DatabaseService(string dbPath)
        {
            _database = new SQLiteConnection(dbPath);
            _database.CreateTable<Table1Model>();
            _database.CreateTable<Table2Model>();
            _database.Execute("PRAGMA foreign_keys = ON"); // 开启外键约束
        }

        public void SaveData(Table1Model data)
        {
            _database.Insert(data);
        }

        // 其他数据库操作方法...
    }
}

using YourAppName.Models;
using YourAppName.Services;

namespace YourAppName.ViewModels
{
    public class MainPageViewModel : INotifyPropertyChanged
    {
        private DatabaseService _databaseService;

        public MainPageViewModel()
        {
            string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "database.db");
            _databaseService = new DatabaseService(dbPath);
        }

        public void SaveDataToDatabase()
        {
            Table1Model data = new Table1Model()
            {
                Name = "Example",
                Table2Id1 = 1,
                Table2Id2 = 2
            };

            _databaseService.SaveData(data);
        }

        // 其他ViewModel逻辑...
    }
}