Why do I need an ID column?
Two-way sync needs a unique ID for every Supabase record. Whalesync uses your primary key, or adds a whalesync_postgres_id column if the table has none.
To enable two-way sync between Supabase and your other apps, Whalesync needs a way to uniquely identify each record in your Supabase database.
If your table already has a unique primary key, Whalesync will use it.
If not, Whalesync will automatically add a whalesync_postgres_id column to ensure each record can be tracked reliably.
Alternatively, if you'd prefer to add your unique ID field manually, you can follow these steps:
Adding default values to primary keys